on 06-04-2013 11:45 PM
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
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..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.