Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Values of Row and Column Header in a report

ATael-OracleAug 15 2007 — edited Aug 28 2007
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 25 2007
Added on Aug 15 2007
7 comments
815 views