Interactivity between two Charts !!!

Hi All,

I am doing interactivity between two charts,by clicking on first chart value should be change or reflect on second chart.

Consider the example-->Suppose on first bar chart x axis value "state" and y axis value is "creditlimit" ,and second is cylinder chart x axis "customer no" and y axis is "credit limit" .So if i click on first chart then according to state value in second chart customer no and values must change!!!

Can anyone help me to sort out this problem??
It would be great help!!

Thanks!!

Find more posts tagged with

Comments

madhu_2009

Hi Abhay,

For this create a parameter called state in the second chart, and in the query to retrieve the dataset give like this...

select * from tablename where state=?

At the same time in the first report select format chart,then click on y-series,go to interactivity --> Onclick select hyperlink.. there select Drill through.
Browse to your second report and select parameter state,mark as required.

then run your first report.
Hope this will help.. any queries feel free to ask..
Regards,
Madhu