Forum Discussion
Dynamic Subscriptions and a Paginated Report with a multi-value parameter
I've got a Paginated Report that has a multi-value parameter list. Multiple customer numbers can be selected with this parameter for generating the report output. For a Dynamic Subscription, how ...
Go the other way and do it inside the Paginated Report and not on the Dynamic Scheduling side.
I have a listing of Project ID's (MACROID) against a Project Manager.
| Bob Smith | [email protected] | 12345, 23456, 3467 |
My Parameter has the Project Manager name as the Label and the Project ID's (MACROID) as the value. So on selection of the PM you get the value of "12345, 23456, 3467" returned to use in the filter.
Within your dataset then for your output set a Filter using the IN operator.
Ensuring that I'm using a String here on the Expression.
Then the Split for the Value section.
Then on the dynamic report you can use the Parameter to select the Project Manager for the report.