0

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?

jarlh
  • 42,561
  • 8
  • 45
  • 63
Ryan Gadsdon
  • 2,272
  • 4
  • 31
  • 56
  • 1
    Take out grouping and just have a flat result set? – Tab Alleman Jun 08 '18 at 14:27
  • *Why* are you grouping on both values? Are there additional columns in the table? If you just need both these columns to show all values, as Tab says, just remove the grouping altogether. – iamdave Jun 08 '18 at 14:44
  • Take a look at this. It's a bit hackey, but it works: https://stackoverflow.com/questions/868064/ssrs-repeat-tablix-left-most-row-group-value-on-each-row – Ryan B. Jun 08 '18 at 15:24

2 Answers2

0

Click on the Order textbox and go to properties, Under Other set Hide Duplicates to False.HideDuplicates

NewGuy
  • 1,020
  • 1
  • 9
  • 24
0

I am working in Visual Studio, so the options available to me might differ from yours, but my solution is this: In your report layout, in the General properties tab for the Order group, add Item to the Group expressions list. Since Item is more granular than Order, the Order value should repeat for each row.

LGangl
  • 1