VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: Green Monkey on July 21, 2013, 04:12:47 AM

Title: Revenue Report - exporting
Post by: Green Monkey on July 21, 2013, 04:12:47 AM
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
Title: Re: Revenue Report - exporting
Post by: AH on July 21, 2013, 11:07:33 AM
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 (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 (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 (http://office.microsoft.com/en-us/excel-help/overview-of-connecting-to-importing-data-HP010342748.aspx)