View Single Post
  #9 (permalink)  
Old June 9th, 2008, 13:53
cspadola cspadola is offline
Member
 
Join Date: Feb 2008
Posts: 31
Thanks: 8
Thanked 0 Times in 0 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
cspadola is on a distinguished road
Re: Issue Running Report in OTM - too much data

Hi Prabhakar, thanks for these instructions.

I must be doing something wrong somewhere. I have changed the :P_FILE section as you suggested and changed this to 'report.xls'; The report was already designed to be exported to Excel as a CSV. I compile with no errors and save it on our server. If I run the report manually, it works fine. But when I run it through the scheduler, it still gets saved as a PDF. When I check the htdocs folder, I see the report I just ran in there but it is PDF. I went in and commented out all the AFTERPFORM pertaining to PDF and XML hyperlink and left the Excel hyperlink as is. Still no luck.

When you say "Design the report to produce an XLS/CSV output", am I not doing that already? Or is there a setting I must make so that it skips the HTML results and goes straight to export to Excel?

Thanks
Reply With Quote