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