Chart Data filter

[ebinnasir]

Hello,

Hope all are fine.

I am working on a chart where data are coming from a mysql view. In the view there are 5 fields like customer_name, challan_no, challan_date, quantity. Sum of quantity value is showing as graph. I want to add a filter getting data from view. I want to sum of quantity value where challan_date = curdate() or Month(curdate()). I don not see any options to make this filter from chart options. I think i can do this filter from chart_rendered server event.

Can anyone suggest me how to make this filter for getting data from mysql view?

Regards

Emran

[arbei]

Chart data is same as report data, if you are not just showing the chart, you may add Extended Search to the report. You cannot use Chart_Rendered to filter data, the server event is only for rendering chart.

[mobhar]

You may try Page_Selecting server event to filter data.