Hi There Please do the following Please create a hidden parameter and with allow null values.In the dataset properties go to the parameter tab and create expression for hidden parameter like this=iif(instr(join(Parameters!Multi.Value,","),"A")> 0 ,"A1",nothing) Where multi is your multivalued parameter Now go to your query and change the query like this SELECT [ID] ,[Name] FROM [dbo].[NaMeCheck] Where [ID] in (@Multi) or [ID] in (@HiddenParam) =iif(instr(join(Parameters!Multi.Value,","),"A")> 0 ,"A1",nothing) SELECT [ID] ,[Name] FROM [dbo].[NaMeCheck] Where [ID] in (@Multi) or [ID] in (@HiddenParam) I am putting some screenshot for your help If you have any questions please ask. Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

Hi, We have an SSRS report which has a parameter called Level. Levels include A, B, C and D Some of our data has the values A1 and A - I would like A and A1 values returned when A is selected. So the question is how do I use the expression builder to return other values when a specific parameter value is chosen? Thanks

Hi There Please do the following Please create a hidden parameter and with allow null values.In the dataset properties go to the parameter tab and create expression for hidden parameter like this=iif(instr(join(Parameters!Multi.Value,","),"A")> 0 ,"A1",nothing) Where multi is your multivalued parameter Now go to your query and change the query like this SELECT [ID] ,[Name] FROM [dbo].[NaMeCheck] Where [ID] in (@Multi) or [ID] in (@HiddenParam) =iif(instr(join(Parameters!Multi.Value,","),"A")> 0 ,"A1",nothing) SELECT [ID] ,[Name] FROM [dbo].[NaMeCheck] Where [ID] in (@Multi) or [ID] in (@HiddenParam) I am putting some screenshot for your help If you have any questions please ask. Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

Thanks - I'll try this and feedback.