export to csv from datareport

[unixisgood]

Hi,
I would like to export a report as csv format which i have created with datareport function in VB 6.0. Is there a way to add export as csv option to datareport utility or do you know any free utility that i can use with VB?

Thanks

 

[Swi]

Not that I know of but if you are populating your datareport with a recordset you could export the recordset as a delimited file. Here is an example:

http://www.freevbcode.com/ShowCode.asp?ID=2073

Swi

 

[SBerthold]

There is also the ExportReport method of the DataReport:

DataReport.ExportReport rptKeyText

and it supposedly works asynchronously (your application doesn't have to wait until the exporting is completed)

You could give it a try. I do not know how well it always works. I can imagine it uses a registry setting to determine the default schema used (delimiter, character set, formats for dates and numbers, etc.)

The GetString method used in the link above is an easy method, although with limited capabilities, but in case you are trying to export many many records, you should limit the number of records it returns at one time, using a loop until all records are processed.

 

[unixisgood]

Hi SBerthold ,
Thanks for answer but doesn`t Datareport exports to only text or html files? I need to export as excel or csv format.

 

[SBerthold]

I do not know how the text file looks. It was just an idea. I guess I was assuming as CSV, but probably am wrong. Give it a simple try. I only had played with the DataReport years ago and it doesn't work on my system any longer.