This topic is locked

Custom Chart

11/16/2011 5:13:10 PM
PHPRunner General questions
S
stiven author

Hello,
I was wondering if there is a way to adjust the criteria for a chart on the list page.. for example the chart displays the monthly total sales for every casket.. but since there are several caskets, is there a way to put a drop down on the list page so that the user can select the casket he wants to display the info.. what i mean is in the drop down menu, lets say there are casket1, casket2, casket3 if the user selects casket1 then monthly report for casket1 is shown and if he selects casket2 then monthly report for casket2 is shown, and so on.. is this possible?
thanks so much for your help

C
cgphp 11/17/2011

When the user selects an item in the dropdown list, refresh the page and add a where clause in the "Before SQL query" event of the chart page with the POST of the dropdown item.