I have a requirement to create a link to a child report on clicking a particular column. I am using BO 4.0 and the report is created on a BEx query.
Parent Report has below information. When the user clicks on Document, I need to pass Document as well as the month.Year Month
So, If user clicks on "aaa" in the first row the below child report should be displayed with Document number "aaa" and month as "1"Month
In the child report, we have created the prompt for Document number and month. But when the document "aaa" is clicked, the month is not being passed and we see 3 rows in child report instead of seeing just 1.
Please let me know what I am missing..