Inconsistent revenue reports

[Mass]

Hello

Default Order Status to create an invoice = Shipped.

I would like to use the Revenue Report to generate a list of products sold per month, so I use the settings:
Order Status: Shipped
Set Interval: Products
Set Period: Set Period
From: 07/01/15
Until: 07/31/15

I then copy the list manually (I haven't found an export function yet) to Excel, to sort by product ID and to generate a list of items sold for the month.
I then noticed some duplicate entries, so I generated another revenue report.

The problem is that I've generated a revenue report 3 different times, and each time the list is different.
Several products are duplicated ie the same Id and the same quantity showing twice on different dates, and
Several products not showing in the previous list, now showing in the new revenue report, and
Several products previously showing, now not showing in the latest revenue report.

I ensure each time that the settings are the same, because I need to generate a monthly product report.
So, my revenue reports are inconsistent and unreliable.
I've now also compared the Product report to a Daily report, and the Order and Product totals for the same month (July) are different.

Is it perhaps the way the date has been formatted or set elsewhere ie MM/dd?
Any help would be appreciated.

Currently using VM3.0.9.4 on Joomla 3.4.3 PHP 5.4.41

[AH]

Do you have knowledge of SQL

It is possible to create your own reports using odbc links direct to the database with MS Excel

You can then write your own sql queries to achieve what you require (and they will are likely to be consistent and accurate)

This and related post should help give you some pointers

http://forum.virtuemart.net/index.php?topic=126048.msg431797#msg431797

[Mass]

Thank you for the SQL recommendations. I managed to Akeeba export the db to a .sql file, but I need more time to research how to access it via Excel.

In the meantime, the following reason, solution and problems were found:
The reason for the inconsistent reports, was due to the manual copying of 5+ pages of the revenue report.
Each subsequent loaded page had duplicate data or missing data.

To show a one page Revenue Report, in Configuration / Templates, the Backend default items per list view was changed to (a higher number than total products sold for that month).
This list now displayed on one page, was copied manually and provided a consistent report (without duplicates).
Once done with copying the report and to avoid script errors, I have to change back to a lower value for the Backend list view.

Problems:
To include the products for the 1st of the month, the start date had to be set for the last date of the previous month.
Sorting for Product Id was not possible (but this can be done in Excel).

[AH]

Thank you for posting the update

I hope you are able to get eh excel reports working

You will not be disappointed