Jump to content
Software FX Community

Drilldown Imagemap on 3D Pie chart


User (Legacy)

Recommended Posts

Hi there,

All examples for drilldown deal only with bar charts - can you have drill

down image maps on pie charts? I am using data to build the pie chart (see

below) but do not understand the documentation when it comes to creating the

imagemaps. I have included the code from the documentation and have edited

to reflect the parameters I would like to pass, but the links are not even

created. 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

'Labels

for YCounter = 1 to benefit.rows

benefit.row = YCounter

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

Chart.KeyLeg(YCounter-1) = benefit.Value("BN-DESC")

End If

next

'Tooltips

for YCounter = 1 to benefit.rows

benefit.row = YCounter

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

Chart.Legend(YCounter-1) = benefit.Value("BN-DESC")

End If

next

chart.PointLabels = True

chart.AllowDrag = False

chart.AllowEdit = False

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

chart.URLOptions = CHART_URL_JUMP Or CHART_URL_GLOBAL Or

CHART_URL_PARAM

chart.URLParamMask =

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

chart.ImgTags = "BORDER=0"

Link to comment
Share on other sites

  • 2 weeks later...

Hello,

Image maps with Pie gallery seem to be working fine. I will recommend that

you download the latest service pack of ChartFX if you continue to have any

problem (http://support.softwarefx.com/cfxie). I have attached a small

sample to demonstrate this functionality.

JT

SoftwareFX

Tech. Support

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

news:IoL$MczLDHA.2808@webserver1.softwarefx.com...

> Hi there,

>

> All examples for drilldown deal only with bar charts - can you have drill

> down image maps on pie charts? I am using data to build the pie chart (see

> below) but do not understand the documentation when it comes to creating

the

> imagemaps. I have included the code from the documentation and have edited

> to reflect the parameters I would like to pass, but the links are not even

> created. 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

>

> 'Labels

> for YCounter = 1 to benefit.rows

> benefit.row = YCounter

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

> Chart.KeyLeg(YCounter-1) = benefit.Value("BN-DESC")

> End If

> next

>

> 'Tooltips

> for YCounter = 1 to benefit.rows

> benefit.row = YCounter

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

> Chart.Legend(YCounter-1) = benefit.Value("BN-DESC")

> End If

> next

>

> chart.PointLabels = True

> chart.AllowDrag = False

> chart.AllowEdit = False

>

>

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

> chart.URLOptions = CHART_URL_JUMP Or CHART_URL_GLOBAL Or

> CHART_URL_PARAM

> chart.URLParamMask =

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

> chart.ImgTags = "BORDER=0"

>

>

Link to comment
Share on other sites

Thanks JT. Are Value and Label the only parameters that can be passed or is

it possible to build in custom parameters? In the loop (in my previous

post), I need to build up different URLs based on certain rules in our

database - the parameters I need to pass bear no relation to the values or

labels of the graph.

Many thanks for your assistance,

Bruce

"SFX Tech Support" <support@softwarefx.com> wrote in message

news:84YnGldNDHA.3180@webserver1.softwarefx.com...

> Hello,

>

> Image maps with Pie gallery seem to be working fine. I will recommend

that

> you download the latest service pack of ChartFX if you continue to have

any

> problem (http://support.softwarefx.com/cfxie). I have attached a small

> sample to demonstrate this functionality.

>

> JT

> SoftwareFX

> Tech. Support

>

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

> news:IoL$MczLDHA.2808@webserver1.softwarefx.com...

> > Hi there,

> >

> > All examples for drilldown deal only with bar charts - can you have

drill

> > down image maps on pie charts? I am using data to build the pie chart

(see

> > below) but do not understand the documentation when it comes to creating

> the

> > imagemaps. I have included the code from the documentation and have

edited

> > to reflect the parameters I would like to pass, but the links are not

even

> > created. 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

> >

> > 'Labels

> > for YCounter = 1 to benefit.rows

> > benefit.row = YCounter

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

> > Chart.KeyLeg(YCounter-1) = benefit.Value("BN-DESC")

> > End If

> > next

> >

> > 'Tooltips

> > for YCounter = 1 to benefit.rows

> > benefit.row = YCounter

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

> > Chart.Legend(YCounter-1) = benefit.Value("BN-DESC")

> > End If

> > next

> >

> > chart.PointLabels = True

> > chart.AllowDrag = False

> > chart.AllowEdit = False

> >

> >

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

> > chart.URLOptions = CHART_URL_JUMP Or CHART_URL_GLOBAL Or

> > CHART_URL_PARAM

> > chart.URLParamMask =

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

> > chart.ImgTags = "BORDER=0"

> >

> >

>

>

>

Link to comment
Share on other sites

Sorry, just in follow up to my posting. I find I am able to use my own

parameters, but the values for the parameters get set once on the first loop

and used for all subsequent pie slices - is it not possible to loop through

the parameters and assign the relevant vlaues to the URL's? This is what I

have attempted to do below.

chart.URLOptions = CHART_URL_JUMP Or CHART_URL_GLOBAL Or CHART_URL_PARAM

URLCount = 0

chart.URL(0) = "/enquiries/claims_new.asp"

for YCounter = 1 to benefit.rows

benefit.row = YCounter

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

(benefit.Value("BN-BEN-USED") = "0.00" AND benefit.Value("BN-SCHEME") <>

"0.00") then

URLCount = URLCount+1

T_DESC = "member=" & member.value("m-member") &

"&Close_Type=" & Close_Type & "&agent=" & agent_code & DQ

chart.URLParamMask = T_DESC

End If

next

chart.ImgTags = "BORDER=0"

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

news:$ViCkyjNDHA.2788@webserver1.softwarefx.com...

> Thanks JT. Are Value and Label the only parameters that can be passed or

is

> it possible to build in custom parameters? In the loop (in my previous

> post), I need to build up different URLs based on certain rules in our

> database - the parameters I need to pass bear no relation to the values or

> labels of the graph.

>

> Many thanks for your assistance,

> Bruce

>

>

> "SFX Tech Support" <support@softwarefx.com> wrote in message

> news:84YnGldNDHA.3180@webserver1.softwarefx.com...

> > Hello,

> >

> > Image maps with Pie gallery seem to be working fine. I will recommend

> that

> > you download the latest service pack of ChartFX if you continue to have

> any

> > problem (http://support.softwarefx.com/cfxie). I have attached a small

> > sample to demonstrate this functionality.

> >

> > JT

> > SoftwareFX

> > Tech. Support

> >

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

> > news:IoL$MczLDHA.2808@webserver1.softwarefx.com...

> > > Hi there,

> > >

> > > All examples for drilldown deal only with bar charts - can you have

> drill

> > > down image maps on pie charts? I am using data to build the pie chart

> (see

> > > below) but do not understand the documentation when it comes to

creating

> > the

> > > imagemaps. I have included the code from the documentation and have

> edited

> > > to reflect the parameters I would like to pass, but the links are not

> even

> > > created. 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

> > >

> > > 'Labels

> > > for YCounter = 1 to benefit.rows

> > > benefit.row = YCounter

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

> > > Chart.KeyLeg(YCounter-1) = benefit.Value("BN-DESC")

> > > End If

> > > next

> > >

> > > 'Tooltips

> > > for YCounter = 1 to benefit.rows

> > > benefit.row = YCounter

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

> > > Chart.Legend(YCounter-1) = benefit.Value("BN-DESC")

> > > End If

> > > next

> > >

> > > chart.PointLabels = True

> > > chart.AllowDrag = False

> > > chart.AllowEdit = False

> > >

> > >

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

> > > chart.URLOptions = CHART_URL_JUMP Or CHART_URL_GLOBAL Or

> > > CHART_URL_PARAM

> > > chart.URLParamMask =

> > >

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

> > > chart.ImgTags = "BORDER=0"

> > >

> > >

> >

> >

> >

>

>

Link to comment
Share on other sites

The URLParamMask is a GLOBAL property, setting it in a loop will just

replace the previous value constantly, only the last setting, the setting at

the time of rendering will matter.

Instead of :

chart.URLOptions = CHART_URL_JUMP Or CHART_URL_GLOBAL Or CHART_URL_PARAM

You can set:

chart.URLOptions = CHART_URL_JUMP Or CHART_URL_BYVALUE

This will allow you to assign a different URL to each point using the Url

property as follows:

chart.URL(0) = "/enquiries/claims_new.asp?<any parameter here>"

chart.URL(1) = "/enquiries/claims_new.asp?<any parameter here>"

...

--

FP

Software FX, Inc.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...