In Report Studio 10.1.1, I want to take a multi-select parameter and use it as a query field for further manipulation. I know I can use a layout calculation, but that can't be used in the query itself so I can't do anything further with it in the query.
Any attempt to show the value of a parameter only shows the first value. That or I get parsing error message.
So, what am I trying to do? my report has page break on field 'x'. 'x' is a multi-select input parameter. I want the report to sort on the order that the parameters were entered, not their alpha sort. If I can get the position of 'x' in the parameter list, then I can figure out how to sort.
Appreciate any feedback.