Home:ALL Converter>Displaying duplicate values in SSRS

Displaying duplicate values in SSRS

Ask Time:2018-06-08T22:10:15         Author:Ryan Gadsdon

Json Formatter

I am trying to show duplicates in an SSRS report but it keeps displaying the format like this:

Order   Item
 111    567
        789
        567
 222    789
        345
        521

Whereas, im looking for it to be like this:

Order   Item
 111    567
 111    789
 111    567
 222    789
 222    345
 222    521

I can only assume this is something to do with the grouping. It is currently being grouped by order and item because i want to display both.

I have tried all the answers here inlcluding (changing the hideduplicates column and adding a sub group) but i still cant seem to fix it and get the output i want

"https://social.msdn.microsoft.com/Forums/sqlserver/en-US/f37b8965-b4ca-471c-ae24-f85b8176d51e/how-to-show-duplicates-in-reports?forum=sqlreportingservices"

Has anyone got any other ideas?

Author:Ryan Gadsdon,eproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/50762525/displaying-duplicate-values-in-ssrs
yy