locked
SSRS Grouping Problem with Joined Data RRS feed

  • Question

  • In my SSRS table, I'm trying to group some values, that I've joined and unioned together from different DB tables in one data set.

    so instead of the merged rows:

    January

    February

    March

     

    I get for example:

    January

    January

    February

    March

    So it splits the rows, even if they have the same value... Maybe this could be a Collation / Language problem in the background? Ive checked the DB and the fields are in both tables VARCHAR 9 and Collation = DB Default.

    Any ideas??? Thanks!

    Wednesday, March 30, 2011 8:58 AM

Answers

  •  the gruping should work in eather way. Chech if your database entries are all the same, without leading spaces for month names.
    • Proposed as answer by Challen Fu Tuesday, April 5, 2011 2:50 AM
    • Marked as answer by Challen Fu Thursday, April 7, 2011 10:03 AM
    • Edited by Challen Fu Thursday, April 7, 2011 10:03 AM
    Thursday, March 31, 2011 7:19 AM

All replies

  • Did you group your data on a report table? If you get multiple rows for one record (examp. more than one row for month Januar in your dataset), then you should group your data on report table.

    If you select entire details row on a table and right-click it, you get option Row Group - Group properties. On General tab you can define on which field you want to group data (in your case this is probably Month). 

    Wednesday, March 30, 2011 10:02 AM
  • Thanks for your answer

    Yes, I've already grouped on this column! When i use the Month Number instead of the Month Name (01 instead of January) the Grouping works... I gess there must be some hidden data, that is not displayed in the cell, but distinguishes the Value "JANUARY" from Table A to "JANUARY" from Table B?

    I also merged the data in a table, to be sure its not a problem of the union join of the data set... in fact, the problem was the same again, with the identically type of cell...

    Strange... for now its okey for me with the workaround with Group on "MonthNumber" and Display "MonthName" in the same TableCell... But i'd be interestet in a solution for the future...

    regards

    Wednesday, March 30, 2011 1:54 PM
  •  the gruping should work in eather way. Chech if your database entries are all the same, without leading spaces for month names.
    • Proposed as answer by Challen Fu Tuesday, April 5, 2011 2:50 AM
    • Marked as answer by Challen Fu Thursday, April 7, 2011 10:03 AM
    • Edited by Challen Fu Thursday, April 7, 2011 10:03 AM
    Thursday, March 31, 2011 7:19 AM