Hi , I have been facing this problem from a long time, so thought of asking some help. So I have a parameter that should be populated based on other. I have given this value to my second parameter this way =iif(Parameters!EmailReport.Value = "1", 1, 0) how ever when i select 1 in emailreport my second parameter does not show any value . It is grayed out, i cannot select anything This has happened to my other reports too Could any show some light please ThanksAkki

Hi There Where are you putting this expression =iif(Parameters!EmailReport.Value = "1", 1, 0) in available value or in default value of the second parameter ? please explain further Then I might be able to help you Many thanks Syed qazafi Anjum can you please try this as well =iif(Parameters!EmailReport.Value = "1", "1", "0")

Hi, I have tried placing that on both, default and Available. But its not working. And i also tried =iif(Parameters!EmailReport.Value = "1", "1", "0") and its not working. Have u face this problem too? Thanks! Akki Akki

Hi There No it is working for me indeed What I have done I have created a parameter EmailReport and put some values inside say 0, 1,2 I have created another parameter and in the available values I have choose specify values and both of value and label I have put =iif(Parameters!EmailReport.Value="1",1,0) And then go to default value and I have put again same =iif(Parameters!EmailReport.Value="1",1,0) and it worked greate I am putting screenshot for your help If it does not work for you can you please do the following Create a new datasetAnd put something like this if @EmailReport='1' select 1 as id else select 0 as id if @EmailReport='1' select 1 as id else select 0 as id And then assign this dataset to your second parameter both for available as well as default values then it will work also Many thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful

I shall try, and let u know... Thanks!Akki

well, my mistake....it works when i am not selecting multi value, But when i am selecting multi value for @emailreport , it does not work.. let me show u the steps that gave, for @emailreport dataset: select 'EmailMatched' as label, 1 as value union all select 'EmailMisMatched' , 2 @emailreport: muti value parameter and it works fine. dataset for second report: SELECT * INTO #email FROM split function(@Emailreport, ',') ---split function SELECT CASE WHEN ( 1 ) IN ( SELECT FieldValue FROM #email ) THEN 1 ELSE 0 END DROP TABLE #email also under parameters I used join(parameters!emailreport!value,",") @secondparameter : I am using the above dataset for available and also defult.. but it does not work Let me know if the above procedure is wrong.. Thanks! Akki

Hi There Please just put this for your multivalued parameter inside available values as well as default values =iif(instr(join(Parameters!EmailReport.Value,","),"1")>0,1,0) Many thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful =iif(instr(join(Parameters!EmailReport.Value,","),"1")>0,1,0)

I am trying but no, I am not seeing the results......I wonder how u r getting things worked. The second parameter is just graying out as usual. But u know what, it works when Iam supplying values though dataset sets not by IIF clauses...This is ridiculous.. Anyways thanks for ur help..... Akki