DrillThrough in crosstab to two different report

[KANUL]

I want to give drillthrough in crosstab report to 2 different report from 2 measures in same cross tab report.Is it possible to do that ? As to give the drillthrough , we can only select all the values and give a common drillthrough to 1 report.
Please help.

[sridharansathya]

Hi,

It is possible mate, what you have to do is out of the 2 measures displayed in the crosstab select any one by Column intersection in the properties and DEFINE CONTENTS = 'Yes' .Prior to that copy the same measure you are gonna select in the crosstab and add it as a separate data item in the query item.

Ex : if you are selecting sales ,then copy and paste the data item again as sales 1 in the query item

After applying the DEFINE CONTENTS property to 'YES' drag this new copied data item into the crosstab and associate that data item to the crosstab by checking it in the properties.

Now you can apply drill through to different reports as you wish

do let me know still you face issues ...

Thanks,
Sathya

[KANUL]

Hey thanks Sathya. I tried that and its working .
Thanks a lot.