May 13, 2014 at 11:24 am
SSRS 2008 Newbie here...
I have created a shared dataset that has 2 parameters: an ID and a title. The ID references an existing parameter from another query. The title is a text string that needs to be passed to the dataset query. Up to this point, I have no problem generating the report.
However, instead of passing one text string as the title, I want to choose from 2 text strings at run time. I need to base that choice on an existing dataset field from the results of another query for this report. However, when I try to enter an expression for the title parameter value in the dataset parameters area, I get an error "Fields cannot be used in query parameter expressions".
Here is the expression I'm trying to use:
=IIF(First(Fields!MainDate.Value, "CaseData") IS NOT NULL,"CEO","CFO").
How can I use a query that requires a parameter value based on the results of another query? Do I need to create a parameter from the 2nd query to use for title parameter value? If so, how do I do that? Thanks.
May 13, 2014 at 2:09 pm
I think I found an answer:
I ended up creating a parameter pulled from the dataset field. Then, instead of referencing the query field directly, I used the parameter in the IIF expression.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply