I am using ReportViewer in VS 2010. The following describes the scenario: Table A has 5 columns Col1 Col2 Col3 Col4 Col5 Row1 A B D F G Row2 A C D F G Row 3 1 2 3 4 5 Row 4 1 2 3 10 5 I would like this displayed as: Col1 Col2 Col3 Col4 Col5 Row1 A B D F G Row2 C Row3 1 2 3 4 5 Row4 10 I would like to suppress values that repeat. Can someone please provide suggestions? Thanks very much.

Hi, In SSRS 2008 report, on textbox (in tablix cell) there is property HideDuplicates. Set this value to the field which you want the supression, then repeated values will be supressed. Thanks.

Thanks for replying. That helped a lot however now this is what is happening: Please note there's an additional fieldName column that groups by fieldNames (1, 2 etc) fieldName Col1 Col2 Col3 Col4 Col5 Row 1 1 0 0 1 2 3 Row 2 2 0 0 5 7 8 Row 3 2 0 0 3 7 8 Desired output is fieldName Col1 Col2 Col3 Col4 Col5 Row 1 1 0 0 1 2 3 Row 2 2 0 0 5 7 8 Row 3 3 However actual output after setting hideDuplicates field is fieldName Col1 Col2 Col3 Col4 Col5 Row 1 1 0 0 1 2 3 Row 2 2 5 7 8 Row 3 0 0 3 Please note Col1, Col2 values disappeared for Row2 since Row1 has the same values however the issue is that Row1 lists fieldName 1's values whereas Row2 and Row3 are for fieldname 2. Is there a way to enable hide duplicates only if it occurs within the same row?