Hi, I need to open a new report from my main report when the user clicks on an image. The value of the parameters I pass changes depending on the values in the specific row of data. I am having problems passing the multi-value parameter to the sub-report.
In the Image Properties, on the Action tab, under the 'Use these parameters to run the report' section, I have the following statement in the "Value" field for the parameter:
=IIF(Fields!phase.Value = “Z”, "I,E,C,T,P", Fields!phase.Value)
It works fine for the images that only pass a single value, but leaves the parameter box blank on the sub-report when I click on the image that should pass multiple values.
Can anyone help?