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!

How to find out current worksheet in a Interactive Report

663227Nov 20 2008 — edited Apr 20 2009
Hi,
I am trying to write my own pl/sql procedure to export Interactive Report into excel and email to an alias. I kind of figured out how to create excel file
using XML and also know how to send that by email. My problem is there can be multiple worksheets in a Interactive report and I need to export only the current worksheet. How will I know what is my current worksheet. I am sure there is some substitution variable or other mechanism to do this. Please help.

Note : I can find my report ID by looking at #REGION_ID# substituion string and from there I need to find out the current worksheet ID number.
Any help on this is highly appreciated.

Thanks
Karthik
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 18 2009
Added on Nov 20 2008
7 comments
1,107 views