Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Parameters Users Utilization Expand / Collapse
Author
Message
Posted Wednesday, October 24, 2012 8:26 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, December 24, 2013 4:56 AM
Points: 178, Visits: 668

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!
Post #1376513
Posted Wednesday, October 24, 2012 9:20 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, December 24, 2013 4:56 AM
Points: 178, Visits: 668


Basically:
How to pass NULL value to a Multi value parameter in SSRS?
Thanks

Regards!



Post #1376547
Posted Thursday, October 25, 2012 12:46 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, January 7, 2014 2:21 PM
Points: 132, Visits: 557
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
Post #1376802
Posted Friday, October 26, 2012 6:03 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 12:57 AM
Points: 116, Visits: 396
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
Post #1377529
Posted Monday, October 29, 2012 3:35 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, December 24, 2013 4:56 AM
Points: 178, Visits: 668
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!
Post #1378166
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse