Drill thru on Multiple columns

[Steve]

I have a Crosstab in which I have 2 columns (Qty, Revenue).

The objective is to create drill-thrus on both of these columns but when I click on any value in the Quantity column, it should drill thru to one report. When I click on Revenue, it should drill thru to another report.

Is there a way of doing this? When I unlock the object and create drill thru, it creates drill thru on both the columns. I want a seperate drill thru on each one of those columns.

[kattaviz]

Hi,

I don't think you can have separate drill-throughs for columns in a Crosstab.

The work around is to have an intermediate report where users have to choose b/w the Qty-Target and Revenue-Target reports. Based on the selection in this reprot you can navigate to the corresponding report.

HTH

[Naven]

Hi,

If your crosstab structure is very simple/basic , then you can use a list object, drag and drop your columns and make some structure changes to the list so that it resembles a crosstab. This will facilitate you to define drill throughs on two different columns.

[Ramesh Sanka]

In that situvation  you can apply drillthrough on individual headers like Quanity & Revenue. If you applied the drillthrough on factcells it consider only one.

Regards,
Ramesh

[PRIT AMRIT]

Hi Steve,

Have u got a resolution for your issue?

Thanks
Prit

[Steve]

Hi Prit -

I found 2 ways but chose the 2nd way as it makes more sense from a maintenance perspective.

1> Since there were 3 columns in the Crosstab, all 3 measures, I created a table with 3 columns and 1 row, make copies of the Crosstab and put it in all 3 table columns. After this, hide
the last 2 columns from the 1st table, hide 1st and 3rd column from 2nd table, hide 1st two
columns from 3rd table column. That way the query remains the same but 3 crosstabs. I had to set height for the rows so that all 3 crosstabs remain in alignment. This way I could perform
multiple drill thrus on all 3 crosstabs.

2> Create only one drill thru from the Crosstab and put all 3 drill thru detail reports in
one report but on different pages of the report. That way all 3 reports come out on the
same spreadsheet in Excel but in different tabs.

I chose the 2nd way as it requires less maintenance and easy to modify when required next.