Reportviewer (rdlc) hide/supress duplicates

[johnisotank]

Hi,

I have created a report and the table in this report has the setting 'Hide Duplicates' ticked.

Problem is that even though the duplicate values are now hidden, the row that they would have been displayed on is still there taking up space.

Could someone tell me a way around this because there doesn't look to be a 'point and click' simple solution for me.

Apologies if I've given too little info, didn't want to ramble on with probably useless details...
thanks a lot
John

 

[ousoonerjoe]

Rather than trying to have the report filter out the dupes, change your dataset to use an SQL statement with DISTINCT. This will have a secondary benefit of less over head from the database by not having to send as much data to the form. To go one step further, put the SQL statement in a Stored Procedure. In the event you have to make a minor change to the query, simply update the Stored Proc instead of the entire application.

"If I were to wake up with my head sewn to the carpet, I wouldn't be more surprised than I am right now.

 

[johnisotank]

Thanks a lot for that, I've heard of DISTINCT before but need to brush up on it so I'll take a look.

Thanks again,
John