No announcement yet.

Calling the Same Report to Export to Excel

  • Filter
  • Time
  • Show
Clear All
new posts

  • Calling the Same Report to Export to Excel

    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/'||_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 ,

  • #2
    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

    Let's connect on LinkedIn
    Mobile: +91 973 049 6886
    E-mail: [email protected]

    If my post was helpful, then click on the Like button