Drill Through Report

[SG1907]

Hi Team,

I have a requirement as below...

From Parent report user should drill through to Child Report.



              
State      2013    2014

Alabama      $2500   $2800
Alaska      $4800   $5000      
Arizona    $3800   $2233
Arkansas    $7600   $3200
California    $8900   $5000

For example When user clicks on a measure ($2500) for Alabama in 2013 then

then child report should display for Alabama, 2013 detail sales as below...

Retailer Sale-Amount   
ABC    $400
XYZ    $300
DEF    $800
PQR     $200
GHI    $100
STU    $400
JKL    $300
Total        $2500

So when we see the total of Sale-Amount in child report it is $2500 which we can see as amount in 2013 for Alabama in Main report

Can some body suggest best possible ways to achieve this requirement

Thanks in advance...

[sunny bachan prasad]

Hi sg1907,

You can create a child report with list and pass state and year as a parameter to this report from parent report. To calculate total you can do the summary.