Customised Grouping with Drill Through

[keating101]

hey guys

i have a report where i have used customised grouping.
For example the fields superannuation( $20 ) and payroll tax ($10) has been grouped as 'Salary On Costs'

When i run the report i only want to see the customised group of Salary On Costs and the value of the combined fields ($30) - i can get the report up to this stage.

my question is i want to be able to have a drill through on the $dollar value of the customised group (the $30 value) to open up a more detailed report (that will show transactions for both superannuation and payroll tax).
however soon as i create the drill through, i lose the customised grouping of the $dollar value. the report goes back to listing to the two separate values ($10 and $20).

is there any way to get around this problem?

thanks,
Shaun

[RKMI]

Hi Shaun,

Does it have to be a drill thru? Can it be a runtime prompt to show and hide?

Anyways this an approach I would take create a conditional block place the grouped summarized value in other catagory of the variable and set a value ungroup for variable when ?vGroupPrompt?. Leave it on the runtime page and set the default to show other and when you select ungroup it will convert it.

If this doesn't make sense look for show and hide, conditional block, conditional variables examples. Anyways the next step if you still want it be a drill thru rather than a prompt dropdown. So by default let it launch when dropdown is set to other to show the grouped set then when drill is applied link the report to itself but this time pass value 'Ungroup' for the prompt which will look like the report is being drilled. Also to make it look claen you can hide the prompt in the report page. Hope this makes sense.

Thanks,
RK