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!