Auto generate a chart based on inputbox

[Anonymous]

Hi

I have a report using inputboxes where users can type adhoc sql query.

I have can build the query and I use EDX to run it, but the result chart need be built based on any number of fields.

Typically the query would look like this:

select a.itemno,a.itemname,a.itemgroup,b.itemgroupname,a.itemtype,c.itemtypename

from item a

left outer join itemgrouptable b on

a.itemno =b.itemno and

a.itemgroup =b.itemgroup

left outer join itemtypetable c on

a.itemno = c.itemno and

a.itemtype = c.itemtype

How can I get the report to create that chart automatically?

Keep in mind, the select list may vary. Also the source tables may vary.

Sometime 2,4, 20 fields...

Any ideas?

BR

Dan