Drill down in MS Access

[Anoniem]

We use a fusioncharts multi series line chart on an access form.

Is it possible to drill down by adding a link to the "set value" string?

If so, what format should the link be in?

Thanks!

[saptarshi]

Hello,

 

 

 

Welcome to the forum.

 

 

 

The general format for URL encoding is given below:

 

XML Example:

 

<chart caption='Monthly Sales Summary' subcaption='For the year 2006' xAxisName='Month' yAxisName='Sales' numberPrefix='$'>

 

<set label='Jan' value='17400' link='DemoLinkPages/DemoLink1.html'/>

 

<set label='Feb' value='19800' link='DemoLinkPages/DemoLink2.html'/>

 

</chart>

 

 

 

The URLs must all be URL encoded.

 

 

 

For more detail on drilldown please go to the following link:

 

 

 

http://www.fusioncharts.com/docs/

 

 

 

and check out the 'Drill down charts' section on the left hand panel.

 

 

 

Hope this helps.

[Anoniem]

Thank you, but I'm looking for a solution in MS Access.

Is it possible, for the link to contain a (VB) function?

Thanks!