Built-In "Orders in last 30 Days (Chart Only)" BIRT Report in version 4.1.0.0

[costis]

In KonaKart 4.1.0.0 only:

The "Orders in last 30 Days (Chart Only)" BIRT report shows 0 Orders constantly.
There must be an SQL bug, at least for the MySQL-query-else.

All other reports work correctly. 

[greg]

Not sure what the problem is... my one works fine.   Are you sure you have orders in the period?   I don't think it counts orders on the current day - only yesterday and the past 30 days.

You can see the query that is being used by looking at the BIRT report...

[costis]

Thank you very much Greg!
That was it!
The day just changed and the orders showed up as yesterdays orders.
I could not find an error in the report script. 
I mistakenly thought it would display today's sales too.

Greetings & Thanx for your excellent service!
Costis