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,
-
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.
-
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?
