EA 11 Chart query

[PHS]

Hi,

I'd like to make a bar chart, using SQL query. When I try to use one of my querys, I got error messsage

Unable to save Chart Data, invalid Custom SQL. The field Series must be used in the select statement

is there any documentation how to write Custom SQL query that can be used in charts ? I couldn't find this.

Regards,
Piotr

[RoyC]

What is your SQL Query? The error message indicates that you have not used the alias Series; this is a mandatory part of the SQL Query statement, as documented in the integrated Help (Reporting > Charts > Standard Chart Data > Custom Query).

Your Query should resemble this:

Select t_object.Status AS Series, t_object.Author AS Groupname from t_object

which produces a chart of elements of each Status, further grouped by element Author.

[PHS]

Thanks a lot ! I should have checked integrated help first