Parameters Users Utilization

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

davdam8 Hall of Fame Points: 3620 More actions · Answer 1

Basically:

How to pass NULL value to a Multi value parameter in SSRS?

Thanks

Regards!

H4K Hall of Fame Points: 3374 More actions · Answer 2

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

sanjeewan99 Say Hey Kid Points: 700 More actions · Answer 3

Hello,

Go to this link will Help you to pass multiple or All parameter value

davdam8 Hall of Fame Points: 3620 More actions · Answer 4

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!