Passing parameters from a hidden series.....

[User (Legacy)]

I am trying to chart a pie graph with drill down capabilities that displays

the following:

Legend: PageTitle

Value:  Total

I need to pass the PageID to the target page when clicking on a Pie slice. I

have written a SQL statement for this that generates the following

recordset:

PageTitle                      Total         PageID

jeb topic1                        5               1

jeb topic2                        5               2

jeb topic3                        3               3

Dan's Topic 1 edits               1               4

Dan's Topic 2                     3               5

Dan's Topic 3                     3               6

I have written the following ASP code to display the chart:

' ******************************** Chart FX Stuff

******************************

Set objChart = Server.CreateObject("ChartFX.WebServer")

objChart.AdoResultset objRs

objChart.Gallery = PIE

objChart.Chart3D = False

objChart.LegendBox = True

objChart.LegendBoxObj.Docked = 258

objChart.Border = 1

objChart.ShowTips = True

objChart.TipMask = "Handbook: %l (%p%%)"

objChart.ImgMap = CHART_MAP_TITLETIP

objChart.URL(0) = "target.asp"

objChart.URLOptions = CHART_URL_JUMP Or CHART_URL_GLOBAL Or CHART_URL_PARAM

objChart.URLParamMask = "ContentID=%v1&SectionID=" & intSectionID

objChart.DataType(0) = CDT_LABEL

objChart.DataType(1) = CDT_VALUE

objChart.DataType(2) = CDT_VALUE

objChart.Series(1).Visible = False

imgChart = objChart.GetHtmlTag(400,300,"Image")

'

****************************************************************************

****

What I am attempting to do with this code is to use the PageID as a second

series but hide that series so that a second pie chart does not get

displayed. However, I am trying to reference this series in the URLParamMask

and this is not working. I seem to get the "Total" value being passed as

opposed to the PageID. Is there a way to pass the PageID without explicitly

displaying it in the Pie Chart?

Thanks

Rahim

Rahim Hirani

Software Developer

saltmine

THE POWER OF ONLINE SOLUTIONS

www.saltmine.co.uk

Atelier House

64 Pratt Street

London NW1 0LF

PH: +44 (0) 20 7959 0650 (switchboard)

PH: +44 (0) 77 2005 0044 (mobile)

FAX: +44 (0) 20 7959 0651 (FAX)