InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 16:25:22 GMT20http://www.sqlservercentral.com/Forums/Topic1393378-150-1.aspxNo problem!Fri, 07 Dec 2012 02:55:30 GMTGazarethhttp://www.sqlservercentral.com/Forums/Topic1393378-150-1.aspxIt works perfectly! Thank you so much. :-)Thu, 06 Dec 2012 23:08:22 GMTTeeehttp://www.sqlservercentral.com/Forums/Topic1393378-150-1.aspxHi,Multi-valued parameters can't be NULL as far as I know, no value supplied gives a parameter value of blank rather than NULL.Try this expression:=iif(Join(Parameters!uidIncidentTypeId.Value) = "", Fields!vchParentIncidentType.Value, Fields!vchIncidentType.Value)CheersGazThu, 06 Dec 2012 07:42:49 GMTGazarethhttp://www.sqlservercentral.com/Forums/Topic1393378-150-1.aspxHi All, I'd like to display different fields/columns in a graph based on a parameter.If the parameter is Null I need to display this field: Fields!vchParentIncidentType.Value and if its not null i need to diaplay this field:Fields!vchIncidentType.Value I'm using the expression below but at the moment its just displaying this field: vchIncidentType.Value - even if there's no value supplied for the parameter(NULL)=IIF(ISNothing(Parameters!uidIncidentTypeId.Value), Fields!vchParentIncidentType.Value, Fields!vchIncidentType.Value)Please help with the correct expression to use.Kind RegardsTeeeThu, 06 Dec 2012 02:08:41 GMTTeee