Hide First Duplicate value in RDLC.
basic0220
Member Posts: 43
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!
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!
0
Best Answer
-
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.
For help, do not use PM, use forum instead, perhaps other people have the same question, or better answers.5
Answers
-
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.
For help, do not use PM, use forum instead, perhaps other people have the same question, or better answers.5 -
[Topic moved from 'NAV/Navision Classic Client' forum to 'NAV Three Tier' forum]
Regards,Alain Krikilion
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 333 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
