Selective Drill-down based upon where you click

[alie123]

Hi All

I'm wondering if anyone knows if it's possible to be able to alter the information you drill down into depending upon what field in a group header/footer you select?

For example I have a period total field in a group footer and a year-to-date field as well. I want to be able to view just the period transactions if I click on the period total field, and all transactions if I click on the year-to-date field.

I'm using CR8.5. I'm assuming that there is some way of doing it, probably by passing a variable when you click on the variable. But I can't see any event procedures to do this.

Any help appreciated.

Alie

 

[Turkbear]

Hi,
A drill-down is controlled by the Group, and,IIRC,it is a 1 to 1 relationship..a Group can only drill down to one place-

There may be a way using subreports, but I'm not sure..

 

[lbass]

You could create on-demand subreports with the detail for each summary. Link each to the main report on the group field, and place them in the group footer. Then go to format subreport->subreport->check "on demand"->subreport caption->x+2 and enter:

totext(sum({table.amt},{table.groupfield}),2)
//text version of your summary

Then go to the font tab and make sure the font matches your main report font, uncheck underline, and change the font color to black. This way the summary will appear exactly as a normal summary. (Or leave it blue if you like to make sure users understand it is a link.)

-LB