Values of Row and Column Header in a report
I have a report created with the following SQL Query:
select quarter,
sum(decode(id, 100, rev, null)) A,
sum(decode(id, 90, rev, null)) B,
sum(decode(id, 80, rev, null)) C,
sum(decode(id, 60, rev, null)) D,
sum(decode(id, 40, rev, null)) E,
sum(decode(id, 10, rev, null)) F,
sum(decode(id, 5, rev, null)) G
from (
select quarter, id, sum(rev) rev
from testtable
group by quarter, id)
group by quarter
This will give me a "pivot" style report with the columns A-G and rows containing quarters. The values displayed calculated (sum) depending on the quarter, column they belong to in the testtable.
Now, my idea is to make those values as links so whenever a user clicks on the value he get's another report that shows all the details behind the value. And to accomplish this I need to know the column header and value of the row header in the report. How can I grab those values so I can pass them along to the next report?
Cheers,
Andy