SQLServer Reporting Service

Posted by Naveenmanam under ASP.NET on 4/29/2010 | Views : 1119 | Status : [Member] | Replies : 1
I have created a Report with SQLServer Reporting Service

I have MainReport with a table. with in that table i have one subreport. when i run the mainreport i have some duplicate records within the table.

I have controled the duplicates with "Hide duplicate" Property of textbox

But i need to hide duplicates of subreport.

How can i achieve this?

NaveenKumar


Responses

Posted by: Easwaran on: 7/1/2010 [Member] Starter

Up
0
Down

Hi,

Avoid returning duplicate records in the dataset itself.

Some ways to avoid duplicate records are:

1. Select DISTINCT col1, col2,.... from Table

2. Select col1,col2 from Table group by col1,col2 having count(*) = 1
union all
Select col1,col2 from Table group by col1,col2 having count(*) > 1

I hope this helps.

Regards,
Easwaran.

Naveenmanam, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response