ReportServer Forum

Kritsanapong

Member

Registered: 2024-07-17

Multi-level cascading parameter

Hi,

I am trying to create a report with multi-level cascading parameter where the list of selectable parameter values get filtered depending on the selected value of another parameter.

For example, in the case of selecting an employee within a company operating across multiple companies, we could have three parameters
- Country
- Branch
- Employee
where selection of a Country will filter the list of selectable Branches to only include Branches within the selected Country
and selection of a Branch will filter the list of selectable Employees to only include Employees within the selected Branch

I am running into 2 issue,

1. When I create a report variant with these 3 parameters set, the generated report is displaying correctly. However, when I try to edit the variant, the value for the lowest level parameter, Employee in this case, is showing as nothing is selected. This means that when I need to edit the variant, I need to re-select the Employee value again every time. Otherwise, no Employee value will not be selected and the report generated from the updated variant will include data for all Employees.

2. Is it possible to set up the Employee field to not depend on both Country AND Branch together? Can I only select either one of Country or Branch and filter the list of selectable Employees based only on the selected Country or Branch?

IF_Jasmin

Moderator

Registered: 2024-11-14

Re: Multi-level cascading parameter

Hello,

Could you please send us a screenshot of what your "depends on" fields for the parameters look like?

And please also send us a screenshot of the specific properties.

To upload screenshots to the forum, you can use, for example, http://imgbb.com  .

Best regards
Jasmin

Kritsanapong

Member

Registered: 2024-07-17

Re: Multi-level cascading parameter

Hi Jasmin,

Here is the list of parameters for my report

The notable parameters are
- C_COUNTRY which represents the country codes
- C_CLIENT_GROUP_3 which represents the client groups and belongs to a country
- C_CLIENT_NAME which represents the name of the client and belongs to a client group

Below are their properties
C_COUNTRY

C_CLIENT_GROUP_3

C_CLIENT_NAME