BI Publisher 11g - Drill down question
Hi,
I have BI Publisher Desktop installed on my computer, and i need to generate a report with 2 tabs :
1rst tab : Tabular report, filtered by report parameters (detail)
2nd tab : Dynamic crosstab with two dimensions.(aggregate)
At the intersection of columns and rows, on the cell context, i want to make a hyperlink to filter the first tab with the current cell value.
(like as Excel dynamic crosstab).
How to do that ?
- make a hyperlink which filter the first tab
or
- make a hyperlink which make a call to a detail report .
I don't know how to get the value of column and row and pass it to the second report(and pass the reports parameters).