Hi, I'm trying to get summary data into a chart on a web report. The SQL statement produces something like this in a table:

Numeracy___ 22

I've successfully created a Chart in a Grid (alternate views) so I know it works. To embed it into the report I tried using the 'Table' as a data source, but I got nonsense charts - one for each line of the table (which works fine for a one-to-many but not for my simple table). So I figured the next best thing was to put my own Connection details/SQL statement in the 'Data Source' section of the Graph Data dialogue box - as shown in the attached view.

This throws up the "Data Expression is empty" error message. Can anyone spot the obvious mistake I'm making? Many thanks. Malcolm
Attached Files