Calling the Same Report to Export to Excel

[Lakshmi]

Hi,
I am trying to export a report with 2 ames and the first frames contains the summary and the 2nd contains the details.
I want this report to excel only the detailed part by calling the same rdf file to export as specified below

p_xls_hyperlink := _report_call||'?'||_rep_userid||'&server='||_reports_server|| '&report='||_report_physical_name||'&destype=CACHE&desformat=d elimited&mimetype=application/vnd.ms-excel&p_gl_user='||_report_user||'&p_within_report=Y' ||'&p_rep_userid='||_rep_userid'&P_END_DATE='||:P_END_DATE ||'&P_SOURCE_LOCATION='||:P_SOURCE_LOCATION;

While I export to excel is ther any option to get only the frame 2 in the excel without frame 1 data n details

Thanks ,
Lakshmmi

[Prasad Chandane]

Re: Calling the Same Report to Export to Excel

Hi Lakshmi,

Which version of OTM are you using?

In OTM you can configure the report as per below steps,

1. Create 2 SQL Templates - Summary and Details Queries separately
2. Create 2 Format Templates - RTF is a simple way to create them
3. Mention parameters which are needed while extracting report from OTM
4. Choose parameters and use Format as 'Excel'
5. You can also schedule the report as per your convenient time with Excel format

Thank you


-Prasad-