topic Paginated Reports optional parameter help in Report Server

Paginated Reports optional parameter help

hannahsamd — Mon, 24 Jul 2023 15:41:29 GMT

Hi,

I have a report that I am builder in Power BI report builder. I have 2 parameters, Year and Quarter. I am creating quarterly and yearly reports. I want the quarter parameter to be optional so I can easily get the yearly report in the same place as the quarterly report. ANy help would be great! Right now the parameters are just drop downs

Re: Paginated Reports optional parameter help

KVRKarthik — Mon, 24 Jul 2023 18:34:53 GMT

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.

Re: Paginated Reports optional parameter help

hannahsamd — Mon, 24 Jul 2023 19:37:01 GMT

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

Re: Paginated Reports optional parameter help

KVRKarthik — Tue, 25 Jul 2023 14:02:35 GMT

To resolve this,

In parameter properties, go to "General" window, check the option "Allow Multiple Values".