Subreports within a group column

[antmoe3]

How do I create a link for summary report to a sub-report in a grouped column?


(See Example below). I want to be able to click a value in the division column (say Division - A) and it provide the detailed sub-report. Then I want the ability to click another value in the summary report (say Division - C) and it provide the detailed sub-report.

I know I need a hyperlink or just insert the sub-report but I do not know how to do this in a Group that has different division and values and within the same group.

DIVISION SALES AMOUNT
A 2500 4000
B 1000 5000
C 1500 3100


SUB-REPORT - DIVISION A
DEPT SALES AMOUNT
A23 1000 1000
B12 1000 2000
B34 500 1000


SUB-REPORT - DIVISION C
DEPT SALES AMOUNT
A77 500 1000
E15 500 1000
F87 500 2100

 

[lbass]

You could manage this just with drilldown. If you have the department, sales and amount in the detail section, you can then hide the detail section, so that clicking on the division will reveal the detail. You don't really need a subreport for this.

-LB