Last post Jul 30, 2013 10:41 AM by BrennanU
Jul 10, 2013 07:45 AM|BrennanU|LINK
Hello all. I am running into a bizarre problem with an app I am working on. For some reason, the non header rows are duplicating for some records in a report. This report is one that I migrated from a legacy version of the app that I am rewriting. I copied
the viewing page and dataset almost verbatim, and the problem appears in the new app only. Both projects are .NET 4.0. I am completely confused because the old app did not do this. Also it only happens for some records. I did not create the report, so I don't
know exactly how it works, but I viewed the table properties, and nothing looks like it would make this happen. (See Screeenshots below)
These are in the same report on the new application, just different pages showing different records.
Edit: One other thing: I copied the rdlc file verbatim, and it works completely fine in the other app, and is a problem in this one.
Jul 30, 2013 10:41 AM|BrennanU|LINK
I was able to figure it out. In the old application what was once a unique primary key was now joined with another table. That means that there were duplicate rows with that same key. There was a row group by clause that was causing SSRS to combine those
records that should have been separate.