Home » Developer & Programmer » Reports & Discoverer » Export Discoverer Report to Excel
Export Discoverer Report to Excel [message #157447] Thu, 02 February 2006 08:15 Go to next message
vitap
Messages: 10
Registered: January 2006
Junior Member
Hi
I run a discoverer report and after execute a try to export it to Excel. The report has a lot of records and the process was trying 20 minutes, after 20 min it's looks like system not responding and I stop it.
Can anyone suggest any help?
Thanks,
Re: Export Discoverer Report to Excel [message #157536 is a reply to message #157447] Fri, 03 February 2006 01:15 Go to previous message
skooman
Messages: 913
Registered: March 2005
Location: Netherlands
Senior Member
Hi Vitap,

You can try if commandline export is faster. Create a (DOS) batfile with the following contents (see documentation for details):

<disco user exe file, full path> /connect <username/password@instance> /opendb "<workbookname>" /export csv <filename.csv>

The result is a csv file which you can open in Excel.

Succes!

Regards,
Sabine
Previous Topic: Rollback
Next Topic: lis
Goto Forum:
  


Current Time: Fri Jun 28 01:33:44 CDT 2024