Not able to pass values in filter parameters from main report to sub reports
Hi,
I have a request to filter a report, from the Report Browser, by the Resolved Time Stamp of cases. However, the main report is composed by few Sub Reports which count the number of cases based on a specific property.
I have configured the Reports as it follows: I have set a parameter in the Main Report, a parameter in the Sub Report and configured the parameter in the Sub Report to be like the parameter of the Main Report. However, even if I put a default value for the parameter in the Main Report, if I change the value of the filter from the Report Browser the data are not refreshed.
How can I resolve the issue? If I was not clear, please ask me any possible clarifying questions.
Thanks.
***Edited by Moderator Marissa to update Pega Academy to General; update platform capability tags***
Pegasystems Inc.
US
Evonsys
US
Hi,
You can do below approach which will work.
1. In the main report, in Report Browser tab select "Display filters using custom section".
2. In the custom filter section add an input field for your parameter.
3. Create a Page type Data Page "D_FilterInput" with source as Data Transform in which you can set default filter values. You need to create a property for parameter and set default value to that.
4. In the section input field configuration provide D_FilterInput.FilterProperty. In "Change" action of the control you can do a post value.
5. Use D_FilterInput.FilterProperty for filter for both main report and sub report.
Changes in the filter values in the main report do not propagate to the sub-reports. There are several existing enhancement requests to add this capability, but so far it has not been implemented.
In order to do this, you will have to define custom filter properties that you can refer to in both the main report and the sub-reports. Refer to these properties in a custom filter section for the main report. When you change the value of these filter properties, you can pick up the new values in the sub-reports.