SQLServer Reporting Service

Posted by Naveenmanam under ASP.NET on 4/29/2010 | Views : 2037 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

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

Latest Posts