Pass a group (dataset?) to a subreport

Hi all,

I'm a noob. I need to call from a master report a detailed report. In the master report I've a cross table with some totals defined as summary fields. I've to click on the totals and open a subreport. For that reason my subreport should have in input as a parmaeter a list of values. How could I define the parameter on the subreport to accept a dataset? How should I setup the hyperlink to pass that parameter using the drill trough?
At the moment I pass the dataset as a group dimension. But when I open the subreport it doesn't show anything. Only blank result.

How could I do?

thank in advance for your support

Find more posts tagged with

Comments

averma

Hi vucciria,
You could pass in the value of dimension from the crosstab to the subreport as a parameter value and then use this value to filter the dataset in your subreport. See the attached sample report.

Ashwini

vucciria

I tried to replicate your same example but the main report still doesn't pass the dataset to the subreport which continues to show empty result

thank you

averma

Try this link:<br />
<a class='bbc_url' href='http://demo.birt-exchange.com/iportal/executereport.do?__executableName=/LinkedExamples/BIRT Sample Reports/Reporting Feature Examples/Crosstab Drill Down/SalesByProductlineAndYearFinal.rptdesign'>Crosstab Drill Down Sample</a><br />
<br />
Ashwini

vucciria

I've tried to reproduce a similar example but I've not same result.Maybe I also know the reason:

in my cross table I've A and B as rows and columns which are my dimensions. Then I've C (the number which I would link to the subreport) which is measured basing on A and B. The list of C record (which in the main report is expressed as a total) must be passed to the subreport.
In your example the year is a dimension too so maybe that's the reason why in the example you mentioned it works.
I can't pass my "total" field as dimension to the subreport (it is also passed as a measure/number) so, maybe, that's the reason why it doesn't work.

Thanks anyway

averma

Hi vucciria,
If you can illustrate your issue with a sample report, it will help me understand the issue better.

Ashwini