locked
Table Duplicating RRS feed

  • Question

  • User-1152693950 posted

    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.

    [I[/IMG]

    Any Suggestions?

    Thanks!

    Brennan

    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.

    Wednesday, July 10, 2013 7:45 AM

Answers

  • User-1152693950 posted

    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.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, July 30, 2013 10:41 AM