Use table as data source for chart

Hi,

Is it possible to use a table as a data source for a chart? If a user were to sort the table (actuate viewer), it would update the chart?

I know it is possible to create a 'Chart View' off the back of a table but there are a couple of reasons I don't want to do this:

1. I want to show both the table and the chart at the same time.

2. I'd have to introduce groups into table, I don't want the data to appear grouped just for the sake of the chart.

Ideally, I'd just like to use the table as the data source instead of the *actual* data source, allowing the chart to update as a user filters / sorts the table.

Thanks,
Andy

Find more posts tagged with

Comments

mwilliams

Hi Andy,

So, you're using Actuate BIRT 10? Or just an Actuate viewer with Eclipse BIRT?

andyros

Hi Michael

I'm using Actuate BIRT 10 (Report designer & ActuateJavaComponent).

(btw, thanks for your reply to my previous thread about a 'page per parameter')

Andy

andyros

I have a solution, but I was forced to group the table. The data is now sorted by group firstthen my chosen column, something I didn't really want.

To show both the chart and table at the same time, I created a chart view for the table and then a new chart which points to the chart view of the table as the datasource.

All the table data is there, seems silly that I had to do this. The table could just appear as a datasource..

Andy

johnw

If you put the chart into the header of your table, you would choose "inherit Data from Container" instead of "Use Data From", and you can use the data binding of the table as your date source instead of selecting the data set name. Any sorting on the table should show in the chart.

If thats not what you mean, then there is another solution. For some of my clients, I created a special type of ODA that will use a report document as a data source, so that if a user runs a report with no change in parameters, it will re-use the already retrieved data without needing to re-hit the database. this was done specifically for a dynamic sort solution using the open source BIRT. Something like that might apply here as well.

John