locked
SSRS repeating rows in table. RRS feed

  • Question

  • I just built a table which displays the results of a query and I am getting loads of repeating data. Is there a setting which I need to configure to stop this.

    I have added DISTINCT to my query but it did not help.

    an example of my result is

    1             Car
    1             Car
    1             Car
    1             Car
    1             Car
    1             Car
    1             Car
    1             Car

    Mr Shaw
    Thursday, April 2, 2009 2:16 PM

Answers

  • I guess there are other columns in your dataset and you are adding only two columns to the table. Try adding group in your table with these two columns in the group by fields..
    ..hegde
    Thursday, April 2, 2009 2:20 PM
    Answerer