Forum Discussion
Paginated Reports optional parameter help
Hi hannahsamd,
Follow the steps given below to achieve this.
1. Add a dataset to the report with column of Year evaluated from the Year column of the data.
2. Add another dataset with column of Quarter from the Quarter column of the data.
3. Add first parameter as "Year" with "Available Values" assigned to column from Step 1.
4. Add second paramter as "Quarter" with "Available Values" and "Default Values" assigned to column from Step 2.
5. Add these parameters as query parameters/ filters on dataset which is assigned to Tablix.
When you're willing to get Year wise, you can select only year. When you're willing to get Year-Quarter wise data, you can select both in a same report.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi! When I get to step 4, I am getting the error "Multiple values were specified for the parameter, but the parameter does not allow multiple values
To resolve this,
In parameter properties, go to "General" window, check the option "Allow Multiple Values".