Announcement

Collapse
No announcement yet.

Calling the Same Report to Export to Excel

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Prasad Chandane
    replied
    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-

    Leave a comment:


  • Lakshmi
    started a topic Calling the Same Report to Export to Excel

    Calling the Same Report to Export to Excel

    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
Working...
X