cancel
Showing results for 
Search instead for 
Did you mean: 

Link to Document

Former Member
0 Kudos

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.

YearMonth
Document
Amount
20131aaa1000
20132aaa1200
20133aaa800
20131bbb500
20134bbb900

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
DocumentAmount
1aaa1000

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

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Thanks All.

It seems like the Month prompt created in BEx is a range prompt.

So, the child report expects a range , and not a single value and so the Month is not being passed..

Former Member
0 Kudos

Hi Dinesh,

Is your issue solved now, after passing range of months to the child report.

Thanks

Mallik

Former Member
0 Kudos

Hi Dinesh,

Please check you open Doc URL or update the hyperlink from interactive mode and ensure you have assigned Month key from the parent report  to the Month prompt of the detailed report when defining hyperlink, similar to what you would have done for Document.

please ensure your Open Doc URL reads something like lsSMonth="+[Month]+" similar to the assignment you have for document.

This will ensure you pass data to two prompts of detailed report even though you are selecting hyper linked value on one column.

Thanks

Mallik

former_member189638
Active Contributor
0 Kudos

It simply means Month is not getting passed to the Child report, But Document is definitely getting passed. Just check the code for the Document and make a similar one for Month.

Former Member
0 Kudos

Hi Komal,

Can you please post the openDocument url that is used (just want to see how you are passing the month)? It looks very straight forward as the specific row has the month information, you should be able to pass the relevant month. Also if you look at the URL in web viewer, can you see the difference between the rows?

Cheers

Mohan