How to Pass Selected Value from Parent Report to Child Report’s Data Source Flow?

hannahmontanna

How can I pass the selected row value from the parent report to the child report’s data source flow inputs?

The child report’s data source flow needs this value to filter data from a large external source before loading. Currently, it fetches all data first and then applies the report filters afterward, causing significant performance issues.

For example, passing the selected WorkflowID from the parent report to the child report’s data source flow so it only retrieves relevant records and improves loading speed.

Thanks!

Manisha_Decisions

Hello!

To improve performance and filter data early, you can pass the selected row value from the parent report to the child report’s data source flow inputs by making the flow Page Context Aware.

Here’s how:

1. In the parent report, set up a filter change source name for the field you want to pass (e.g., WorkflowID).
2. In the child report, add a filter with the same name to accept the passed value.
3. Modify the child report’s data source flow to be a Page Context Aware Flow.
4. Inside this flow, use the Get Page Variable step to read the filter value (e.g., WorkflowID) passed via URL or page context.
5. Use this value inside your flow to query only the relevant data from the external source, reducing data volume and improving performance.

This way, instead of loading the entire dataset and filtering afterward, the child report fetches only the necessary data based on the selected row, significantly improving load times and reducing strain on the external system.