Link to Document

Hi,

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.

Eg:

Parent Report has below information. When the user clicks on Document, I need to pass Document as well as the month.

Year Month
Document
Amount 2013 1 aaa 1000 2013 2 aaa 1200 2013 3 aaa 800 2013 1 bbb 500 2013 4 bbb 900

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
Document Amount 1 aaa 1000

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

Thanks