Reporting/Charts in Excel + Alternative Methodologies

P

pauloconnor

Member
Hi all,

I have been asked to develop some reports - basically trend analyis for sales etc. over a number of years (Graphs, Charts etc).

Doing some initial tests and am looking at exporting the data to Excel via OLE. What I am finding is that I can generate the data pretty quicky, the delay is actually in the Export to Excel.

I would be interested in hearing from anyone who is using Excel for the presentation of large data sets and also would love to hear any alternative methodologies used with Progress.

Cheers,
Paul
 
Hi Paul,

Directly writing data to excel using com is known to be a very slow operation. First it will help already a lot if you write the data in excel before making it visible. The quickest method however is to write the data into an csv file and then import it into excel.
 
RKR,

Thanks for that - outputting to a CSV file and importing is something I tend to do myself if I am querying the system but the users want the facility to export the contents of any browse to Excel hence the use of OLE..
 
You must log in or register to reply here.
Back
Top