Revenue Report - exporting

[Green Monkey]

Hi,

Just wondering if there is any way to export the Revenue Report to excel or something similar? I am about to upgrade an old site to the latest version of Virtuemart but before I do I would like to know if this is possible?

Many thanks,
Amanda

[AH]

No there is not

But you could connect to the database using the mysql odbc connector then create a report using excel and mysql

http://dev.mysql.com/doc/refman/5.0/en/connector-odbc-configuration-dsn-windows.html

excel data connections

http://office.microsoft.com/en-us/excel-help/overview-of-connecting-to-importing-data-HP010342748.aspx#BMunderstanding_data_connections

and

http://office.microsoft.com/en-us/excel-help/overview-of-connecting-to-importing-data-HP010342748.aspx