I have a simple pie chart that makes a record selection, counts how many items are in a particular status and creates a pie chart using the counts. When I execute the chart I get an error #1088. It appears that it goes through the initial generation steps (shows a status when building) but then stops with the error.
I'm using PHPrunner 5.0 Build 766
Internet Explorer 7.0
Query:
[codebox]SELECT
job_orders_status_codes.job_status_name AS job_status_chart_name,
COUNT(job_orders_status_codes.job_status_name) AS job_status_count
FROM job_orders
INNER JOIN job_orders_status ON job_orders.pkey = job_orders_status.job_orders_pkey
INNER JOIN job_orders_status_codes ON job_orders_status.job_orders_status_pkey = job_orders_status_codes.pkey
WHERE job_orders_status_codes.job_status_name Not Like "Cancelled" AND job_orders_status_codes.job_status_name Not Like "Closed"
GROUP BY job_orders_status_codes.job_status_name[/codebox]
The query returns the correct results when it run under the results tab.
Data Series1 = job_status_count
Label Field = job_status_chart_name
Anyone had experience with this error coming up on charts?