Hide First Duplicate value in RDLC.

basic0220

Hi Guys,

maybe someone here have encountered a scenario where the client wants
the report to display line values as one if the specific Item No. has the same Item No. But In Different line,


i have here the sample of what I'm going to do.




The one's crossed out are the values that I will have to remove, since there is totaling of their respective Quantities.
Here's what it looks like in NAV




As I have mentioned earlier, the duplicates should be hidden, like the ones that I crossed out in the first screenshot. .



I hope Someone helps and for this thread to help other's with the same scenario,

Thank again in Advance guys!
Cheers!

SanderDk

HI @basic0220 ,
You can group you way out of that, but grouping on Item No. Prod. ord. Component is not enough, you will need to group on multiple values in your dataset.

SanderDk

HI @basic0220 ,
You can group you way out of that, but grouping on Item No. Prod. ord. Component is not enough, you will need to group on multiple values in your dataset.

kriki

[Topic moved from 'NAV/Navision Classic Client' forum to 'NAV Three Tier' forum]