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!

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).

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

Strage, the gruping should work in eather way. Chech if your database entries are all the same, without leading spaces for month names.