Drilling on a CrossTab Report

:crazy_face: I have a crosstab report with a drilldown on the row headers.
The row header is drillable upto 5 levels down the hierarchy and each level is a separate col in the table (flattened structure).

There are 2 issues I’m facing with the drilldowns :

1.When I click on the drill button on the report to make the report drillable the row headers are disappearing and only the arrows are being displayed ??? I tried setting the repport to drill mode before publishing the report but without any luck.I have been also playing around with the cell formats(wrap text,uncheck the fixed width etc) but without any luck.

2.I’m having a customized hyperlink(on a measure) on the body of the crosstab so that when a user clicks on them it’ll take them to a different report(details).
The problem is the drilldown to different levels…I’m not able to pass this dynamic drillpath values as parameters to the customized hyperlink.Again, I tried using the drillfilter() function but without any luck.

Can anyone let me know if there is any resolution on these issues.


rpyata (BOB member since 2004-07-24)