|
|
|
SSC-Enthusiastic
      
Group: General Forum Members
Last Login: Yesterday @ 10:53 AM
Points: 163,
Visits: 612
|
|
Hi geniuses!
I have a report with 3 parameters. PARAM1 PARAM2 (multivalue and depending on PARAM1 selection) PARAM3 (multivalue and depending on PARAM2 selection)
Right now the user is forced to use them all. I want the user to be free to choose if he only want sto use only 1, 2 or all of them.
Suggestions?
Thanks Regards!
|
|
|
|
|
SSC-Enthusiastic
      
Group: General Forum Members
Last Login: Yesterday @ 10:53 AM
Points: 163,
Visits: 612
|
|
Basically: How to pass NULL value to a Multi value parameter in SSRS? Thanks
Regards!
|
|
|
|
|
SSC-Enthusiastic
      
Group: General Forum Members
Last Login: Wednesday, May 01, 2013 4:11 AM
Points: 127,
Visits: 507
|
|
You can set the parameter properties to 'Allow NULL' and also handle it accordingly on the query side. For example:
Where (customer = @Customer or @Customer is NULL) OR Where (customer IN (@Customer) or @Customer is NULL)
BI Developer SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL Please visit... ApplyBI
|
|
|
|
|
SSC-Enthusiastic
      
Group: General Forum Members
Last Login: Tuesday, March 12, 2013 7:23 AM
Points: 114,
Visits: 386
|
|
Hello, Go to this link will Help you to pass multiple or All parameter value http://www.bi-rootdata.com/2012/09/efficient-way-of-using-all-as-parameter.html
|
|
|
|
|
SSC-Enthusiastic
      
Group: General Forum Members
Last Login: Yesterday @ 10:53 AM
Points: 163,
Visits: 612
|
|
H4K, your solution does not work because SSRS 2008 will not allow to have multivalue parameter and allow null value checked.
What I got is this:
CapPARAM Parameter Query:
SELECT DISTINCT ISNULL(cap.title, '') AS Captitle, ISNULL(cap.title, 'NULL') AS CaptitleDesc, cha.title AS Expr1 FROM ABC WHERE (chap.title = @ChapPARAM) CapPARAM Parameter Properties: Allow Multivalue Available Values: Value field: Captitle , Label field: CaptitleDesc.
Dataset Query
SELECT DISTINCT chap.title, cap.title AS Expr1, cap.ed_pecent FROM ABC WHERE (chap.title = @ChapPARAM) AND (ISNULL(cap.title, '') IN (@CapPARAM)) ORDER BY chap.title What I need is to enable the report user to not interact imperatively in all of the parameters, but he does have to select values from the first one.
Need solutions here, Thanks Best Regards!
|
|
|
|