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.
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
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.
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
Hi Steve,
Have u got a resolution for your issue?
Thanks
Prit
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.