Export Discoverer Report to Excel [message #157447] |
Thu, 02 February 2006 08:15 |
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 |
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
|
|
|