Drill down to chart

Hi,
ASPRunner do not support master-detail relationships between table and chart.

As workaround you can emulate detail link on the Visual Editor tab. Here are some tips:

1. add new column on the Visual Editor tab, add custom link to the chart page for each record.
   
   Here is a sample:
   

2. then check this parameter in the Chart page: Before SQL query event on theEvents tab for your chart and add where clause manually:

Hi Jane,

Part 1 is working i can see that the correct masterkey is choosen.

But part not it is still showing all records.
reg,

Peter

1. add new column on the Visual Editor tab, add custom link to the chart page for each record.
   
   Here is a sample:
   <a href="chartname_chart.php?masterkey1={$FieldName_value}">Chart</a>
   
2. then check this parameter in the Chart page: Before SQL query event on the Events tab for your chart and add where clause manually:
   if request.querystring("masterkey1") thenstrWhereClause = whereAdd(strWhereClause,"FieldName=" & request.querystring("masterkey1"))end if

Please publish your project on Demo Account and open a ticket at http://support.xlinesoft.com sending a URL to your pages along with instructions on reproducing this error.

jane,
I created a simple workaround with cookie.