Drilldown with parameters

[User (Legacy)]

Hi there,

I am looping through data to build the pie chart (see below) but do not

understand the documentation when it comes to adding Parameters to the URL.

The lines below (marked by *) are the lines where I loop through my

recordset to populate the parameters, but only one (the first in the loop)

URL is created and used by  all sections on the pie chart. I tried moving

the chart.URL(0) into the loop and replaced it with chart.URL(YCounter-1)

but then no links were created at all. Any assistance would be much

appreciated.

      chart.OpenDataEx COD_VALUES,1,3

       for YCounter = 1 to benefit.rows

       benefit.row = YCounter

        If benefit.Value("BEN-USED") <> "0.00" then

          Chart.Value(Ycounter-1)  = benefit.Value("BEN-USED")

        End If

       next

      chart.CloseData COD_VALUES

         chart.URL(0) = "/claims.asp"

         chart.URLOptions = CHART_URL_JUMP Or CHART_URL_GLOBAL Or

CHART_URL_PARAM

 *            for YCounter = 1 to benefit.rows

 *                benefit.row = YCounter

 *                 If benefit.Value("BEN-USED") <> "0.00" then

 *                 chart.URLParamMask =

"desc="&trim(benefit.Value("BN-DESC"))&"&Value="&benefit.Value("BEN-USED")

 *                End If

 *             next

          chart.ImgTags = "BORDER=0"

[Software FX]

Please see previous post for a small sample of how to pass parameters with

drill downs.

JT

Software FX

Tech. Support

"Bruce" <bruce@nha.co.za> wrote in message

news:5Aa7870LDHA.3140@webserver1.softwarefx.com...

> Hi there,

>

> I am looping through data to build the pie chart (see below) but do not

> understand the documentation when it comes to adding Parameters to the

URL.

> The lines below (marked by *) are the lines where I loop through my

> recordset to populate the parameters, but only one (the first in the loop)

> URL is created and used by  all sections on the pie chart. I tried moving

> the chart.URL(0) into the loop and replaced it with chart.URL(YCounter-1)

> but then no links were created at all. Any assistance would be much

> appreciated.

>

>

>       chart.OpenDataEx COD_VALUES,1,3

>        for YCounter = 1 to benefit.rows

>        benefit.row = YCounter

>         If benefit.Value("BEN-USED") <> "0.00" then

>           Chart.Value(Ycounter-1)  = benefit.Value("BEN-USED")

>         End If

>        next

>       chart.CloseData COD_VALUES

>

>

>          chart.URL(0) = "/claims.asp"

>          chart.URLOptions = CHART_URL_JUMP Or CHART_URL_GLOBAL Or

> CHART_URL_PARAM

>  *            for YCounter = 1 to benefit.rows

>  *                benefit.row = YCounter

>  *                 If benefit.Value("BEN-USED") <> "0.00" then

>  *                 chart.URLParamMask =

> "desc="&trim(benefit.Value("BN-DESC"))&"&Value="&benefit.Value("BEN-USED")

>  *                End If

>  *             next

>           chart.ImgTags = "BORDER=0"

>

>