View Single Post
  #6 (permalink)  
Old June 6th, 2008, 15:24
sprabhakar sprabhakar is offline
Junior Member
 
Join Date: Dec 2006
Posts: 17
Thanks: 1
Thanked 2 Times in 2 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
sprabhakar is on a distinguished road
Send a message via AIM to sprabhakar
Re: Issue Running Report in OTM - too much data

The way I would go ahead and resolve this would be as given below but this again depends on your environment setup.

1. Create a report that generates the output in XLS format with a specific output report file name.
2. Schedule the report.
3. The scheduled report get stored on the report server in the rptapache/htdocs directory.
4. Have a custom script to pick up the file and send it to the required email address.

We have implemented this for a few customers with success.

Regards,
Prabhakar
__________________
MavenWire

www.MavenWire.com
Reply With Quote