InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 09:25:40 GMT20http://www.sqlservercentral.com/Forums/Topic1376513-150-1.aspxH4K, 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:[code="sql"]SELECT DISTINCT ISNULL(cap.title, '') AS Captitle, ISNULL(cap.title, 'NULL') AS CaptitleDesc, cha.title AS Expr1FROM ABCWHERE (chap.title = @ChapPARAM)[/code]CapPARAM Parameter Properties:[i]Allow Multivalue[/i]Available Values: [i]Value field: Captitle , Label field: CaptitleDesc.[/i] Dataset Query[code="sql"]SELECT DISTINCT chap.title, cap.title AS Expr1, cap.ed_pecentFROM ABCWHERE (chap.title = @ChapPARAM) AND (ISNULL(cap.title, '') IN (@CapPARAM))ORDER BY chap.title[/code]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, ThanksBest Regards!Mon, 29 Oct 2012 03:35:32 GMTdavdam8http://www.sqlservercentral.com/Forums/Topic1376513-150-1.aspxHello, 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.htmlFri, 26 Oct 2012 06:03:04 GMTsanjeewan99http://www.sqlservercentral.com/Forums/Topic1376513-150-1.aspxYou 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)ORWhere (customer IN (@Customer) or @Customer is NULL)Thu, 25 Oct 2012 00:46:28 GMTH4Khttp://www.sqlservercentral.com/Forums/Topic1376513-150-1.aspxBasically:How to pass NULL value to a Multi value parameter in SSRS? ThanksRegards!Wed, 24 Oct 2012 09:20:09 GMTdavdam8http://www.sqlservercentral.com/Forums/Topic1376513-150-1.aspxHi geniuses!I have a report with 3 parameters. PARAM1PARAM2 (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?ThanksRegards!Wed, 24 Oct 2012 08:26:09 GMTdavdam8