web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Remove duplicates and ...

Microsoft Dynamics AX (Archived)

Remove duplicates and add values in SSRS design

(0) Share

Report

Report

Posted on by Sathish Sivakumar

3,732

Hi,

I have to achieve this scenario as mentioned in this link: http://www.techbrothersit.com/2013/12/ssis-how-to-remove-duplicate-records.html

The same way I have to achieve this in SSRS report. Please help....

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Sathish Sivakumar 3,732 on at

Like (0)

Report

Hi,

In my case salesAmt have to be added and it should disply as Aamir - 200, Raza - 200, Shujeeth - 600.

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

Hi Sathish,

you can group records based on any filed. if you don't have any other fields than name and amount, in such case you can group by Name. if you have some other fields also such as employee id or salesman id etc, you can group based on that.

In SSRS there is something called Row Grouping, you can use that

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hi Sathish,

Either you can take care of sum of salesAmt in Data Provider class's processReport method while populating the temp table of your report OR you can have a grouping as mentioned in Sohaib's post earlier.

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

Martin Dráb 4 Most Valuable Professional

#1

#3

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans