Open detailed report from parent report

[dm21]

Hi,

I was wondering if it is possible to open a detailed report from the parent report by passing parameter values from main report.

for eg. parent report has columns
sales_team volume revenue
==========================
1 10 20
2 100 200
3 50 100

Child reprot has columns
sales_team product volume revenue
==================================
1 A 10 20
2 B 100 200
3 C 50 100



I would like to open the child report showing all sales team by taking values of parameters from parent report.

Thanks.

 

[DoubleD]

Sounds like you want to utilize drill through capability. The key is to have sales_team named exactly the same in both reports. Then click on the little cross icon, select the column you want to drill through on, then browse for the report you want to drill to. Now the sales_team field becomes a hyperlink to the child report.

 

[dm21]

In Drill through if I select sales team 1 , the child report will show only value for salesteam 1.

Any how how can I pass parameter values to child report.

 

[DoubleD]

If you are not attempting to pass sales_team, what parameter are you trying to pass. It is only a matter of defining something in your parent report that you can pass to your child report.

If you don't understand my question, show an example of what in your parent report should be deciding the records shown in your child report, then show a sample of what you expect as output.

 

[dm21]

Say I am passing date range from parent to child report

and drill through by sales team.

 

[DoubleD]

You can specify passing multiple fields from your parent report to your drill report. Just select them as "Columns to be included in the drill through filter" when you set your drill down options.