I’m trying to display a dynamic parameter that accepts multiple values. I have gotten as far as creating the array and using the join function to display the records. But I need to adjust it some more. What I would like to display is the position and department of the recipient of the report e.g Director, Mailing Division. Each recipient should be in a new line. So far all I can display is the list of positions. I’m not certain how to concatenate the positions and the departments and how to adjust the array function to display.
Can anyone offer directions please?
Create a dynamic parameter that allows for discrete and multiple values. “Value” will be the key value for the data you wish it to collect. Set the parameter to display the description associated with that key value. (i.e. Value = <position_id>, Description = <position_description>) The dynamic parameter will act as an array.
Add to your report (footer?) a sub-report that queries for Positions and Departments. Create a parameter in the sub-report, allowing for multiple and discrete values. Add this parameter to Record Selection of the sub-report. Design the sub-report to perform the desired formatting.
In the main report, use “Change Subreport Links” to connect your two parameters.
This may not cover every detail, nor work entirely as desired, but it’s a good start.