otmfaqForumsBlogsRegister
FAQMembers ListCalendarToday's PostsSearch

 Subscribe Blogs:RSS
 Subscribe Forums:RSS
OTMFAQ Home
OTMFAQ Blogs
OTMFAQ Forums
OTMFAQ Tutorials

OTM SIG
MavenWire


Reports / FTI and Other Analytics Integrating OTM / G-Log with Oracle Reports, FTI (OBIEE) and creating custom reports / analytics.

Reply
 
Submit Tools LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old August 27th, 2008, 10:20
Junior Member
  
Join Date: Nov 2007
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
Lakshmi is on a distinguished road
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=CAC HE&desformat=delimited&mimetype=application/vnd.ms-excel&p_gl_user='||_report_user||'&p_within_repo rt=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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

« Oracle 9iAS Release 1 for OTM/GC3 4.5 | Adding Header From Oracle Report To Excel Sheet »


Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding Header From Oracle Report To Excel Sheet prashant_prash Reports / FTI and Other Analytics 6 August 27th, 2008 10:54
Export to CSV muthaharotm Reports / FTI and Other Analytics 1 January 31st, 2008 14:26
Export to Excel moshe Reports / FTI and Other Analytics 1 December 19th, 2007 16:03
Exporting reports to excel in OTM 5.0 geetika Reports / FTI and Other Analytics 0 September 21st, 2007 06:15
Error while exporting matrix report to Excel soujanya Reports / FTI and Other Analytics 0 August 16th, 2007 15:36



All times are GMT. The time now is 02:41.
Copyright © 2008, Open Book Solutions LLC. All rights reserved.

Sponsored by MavenWire - MavenWire.com


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37