Passing filter values between parent & child reports.

Mukta shared this question 1 year ago
Answered

I have a parent report say 'Summary_Report' which has a filter called 'Show Zero Balance'.This filter contains values as 'Yes' & 'No'.Now, when I am drilling through to a child report say 'Detail_Report', I want to pass the value of filter 'Show Zero Balance' to child report only when its value in parent report is 'No'.When the filter's value is 'Yes' in parent report, I do not want it to be passed from parent to child report.Any suggestions/thoughts on this?

Comments (4)

photo
1

We have somehow managed to do it.You can close the request.

Thanks.

photo
1

Hi Mukta,


Glad you got it sorted, though I've also managed to get it working using an OR filter on the child report, with a hard coded value also.

In my case (using Ski Team data) I've got a gender filter on the child report, and have Gender = Male OR Gender = <user prompt>

This way when you link to the parent report, and click on 'Female', it passes that along, and the report will already have 'Male' selected also.

If you click on 'Male', then it will be applying 'Male' & 'Male', so no Female results.

See screens below along with export against Ski Team.

45332e3326f9a9b7b38b610d7f8ade0e

79a52801eb4b06b162e6b58c581110cc

f05587fd1e45908caa5e45f67d39c83a

Hope this may help someone else with a similar request :)


Please let us know if there was anything else you were after.


Regards,

David

photo
1

Thanks for your explanation David.I have also done something similar to this.

Regards,

Mukta

photo
1

No probs

photo