Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Doubt Cascade Subrepot
Anderley Viana
<p>Hi bodies,</p>
<p> </p>
<p>I'm trying make a report with two dataset and this in cascade. I have a nested subreport that had a key that be filled from outer report.</p>
<p>How could I do to pass a value from outer dataset to a inner dataset query with a joker(?) in the where clauses that depends the outer dataset value?</p>
<p> </p>
<p>Every helps will be pretty appreciated.</p>
<p> </p>
<p> </p>
<p>Anderley</p>
Find more posts tagged with
Comments
BRM
<p>1. Set up the inner dataset with a parameter that can be obtained from the outer dataset.</p>
<p>2. Put a table on the report that contains the data for the outer dataset</p>
<p>3. Add a column to the table where you want the inner dataset to show up</p>
<p>4. Put a table bound to the inner data set in this column</p>
<p>5. For the inner table, click binding and then the button "Data Set Parameter Binding"</p>
<p>6. Bind the Inner Data Set parameter to the appropriate column from the Outer Data Set</p>
<p>7. Done!</p>
<p> </p>
<p>See the attached report design as an example.</p>
<p> </p>
<p> </p>