Duplicate Values in the Parameters
Hi All I have created a report in SSRS and added five parameters including the date paramter. DATE PARAMETER USER NAME PARAMETER : John,Joseph,Kevin,Peri CASE TYPE:ACTIVE,INACTIVE,INPROCESS PAY TYPE: VISA,MASTER,CASH,CHECK,MO ACCOUNT TYPE:PRIVATE,FUNDED,PUBLIC,PP My problem is once i added these parameters and clicked on the preview report , in the drop down for each paramter i'm seeing duplicate values for these distinct values. I used other reporting tools and never came across anything like this. I'm new to SSRS, can anyone please guide me here to get rid of duplicate values in the parameters? ThanksSV
September 30th, 2012 6:34pm

How are you getting values for the parameter(s)? If from a query, make sure the query itself does not return duplicates. This article may also help: http://social.msdn.microsoft.com/Forums/is/sqlreportingservices/thread/98afe03e-08da-435b-8f0a-1827954bbebeBonediggler
Free Windows Admin Tool Kit Click here and download it now
September 30th, 2012 7:07pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics