piechart3d problem with piedataset

[toltsch]

I'm using iReport 1.2.7 and have a report with a 3D Pie Chart. I'm using a database query to supply the data for the report.

 

The problem that I'm having is that the query only returns one row and the columns in the row returned contain the information for the pie chart slices.

 

It appears that the key, value and label expressions can only have a single Field or variable entered.

 

My field data for example would be

 

number_orders_open = 10

number_orders_held = 30

number_orders_suspended = 60

 

I was hoping that an array or some sort of object list could be used for each of the key, value and label expressions.

 

Can this sort of thing be done? I've purchased the iReport documentation and it does not show any examples of doing this.

 

Thanks in advance for any help you can give me.

 

Regards,

 

Tim