Problem with matrix (in subreport, multiple groups), groups repeating first row data
I have a new SQL 2005 (SP2) Reporting Services server to which I've just upgraded and deployed some SSRS 2000 reports. I have a subreport that contains a matrix with two groups. The report data seems to be inexplicably repeating the data for the first row in the group for all rows in the group. Example: ID1 ID2 DisplayData 1 1 A 1 2 B 1 3 C 2 1 A 2 2 B 2 3 C Parent group is on ID1, child group is on ID2, report would show: 1 1 A 2 A 3 A 2 1 A 2 A 3 A Is this a matrix bug in 2005 SP2, or do I need to do something differently? I can no longer pull a comparison version from an SSRS 2000 server to verify, but I believe it was working as expected before...
January 25th, 2008 5:31pm

Hi, In the property sheet for the matrix, check the settings on the Grouping tab. Perhaps the combination of row and column groups is causing your problem. If this doesn't help, check the the grouping settings for the underlying List control if that is what you are using. Hope this helps, Bill
Free Windows Admin Tool Kit Click here and download it now
February 7th, 2008 1:15pm

Did you ever find a solution to this. I am having the same issue except it only occurs on one of my servers, not in development or on any other machine
May 9th, 2011 12:14am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics