| 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 |