KonaKart Community Forum

Installation / Configuration => Reporting => Topic started by: costis on September 07, 2009, 09:25:24 am

Title: Built-In "Orders in last 30 Days (Chart Only)" BIRT Report in version 4.1.0.0
Post by: costis on September 07, 2009, 09:25:24 am
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. 
Title: Re: Built-In "Orders in last 30 Days (Chart Only)" BIRT Report in version 4.1.0.0
Post by: greg on September 07, 2009, 08:30:13 pm
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...
Title: Re: Built-In "Orders in last 30 Days (Chart Only)" BIRT Report in version 4.1.0.0
Post by: costis on September 07, 2009, 10:06:09 pm
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