Hi to all,
I'm trying to pass parameter values from on Parent report to a child report.
3 Prompt values and 2 column values. This is what i have tried so far:
METHOD 1:
Drill Thru using a TEXT object (instead of a column).
In this case i can only SEEM to pass the 3 prompt values by choosing "Pass Parameter Value". I can't seem to choose "Pass Data Item Value" to pass my column values.
Which seems normal because my link is a TEXT type object and not a Query item object.
QUESTION : IS THERE SOMETHING I AM NOT DOING CORRECTLY OR IT IS NORMAL AND IS NOT POSSIBLE TO DO WHAT I WHANT TO DO ?
METHOD 2:
I use 2 HTML items and between them i place a TEXT object that will serve as link to the child report. I have found an article on the Cognos website that has the necessary code to do the job. BUT, it only seems to CONCERN passing "HARDCODED" values to the parameters of the CHILD report. In the code below the section that INTERESTS me is the pParameter1 and pParameter2:
Solution:
...
Steps:
1. Create a new blank (empty) report in Report Studio
2. Add an HTML Item to the report, and use the text below as the content:
<input type="hidden" name="b_action" value="xts.run">
<input type="hidden" name="m" value="portal/report-viewer.xts">
<input type="hidden" name="method" value="execute">
<input type="hidden" name="m_obj" value="/content/package[@name='GO Sales and Retailers']/folder[@name='Report Studio Report Samples']/report[@name='Consumer Trends']">
<input type="hidden" name="nh" value="1">
<input type="hidden" name="tb" value="0">
<input type="hidden" name="run.prompt" value="false">
<input type="hidden" name="p_Parameter1" value="Canada">
<input type="hidden" name="p_Parameter2" value="Navigation">
<script>
document.formWarpRequest.submit();
</script>
3. Run the empty report. It will execute the Consumer Trends report, with the parameters Canada as Country, and Naviagtion as Product Line.
QUESTION: How do i do if i whant to pass dynamic values. To pass the values selected by the user in the PARENT report ?
Thanks in advance people !