Absolute basics for making a Dynamic chart

i have set the chart in the wizard to point to a table in my database which is indexed using an ID.

How do I pass this ID to the chart? I use this code to call the chart:-

<td><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0" width="940" height="300">
<param name="movie" value="DynamicWebCharts/open-flash-chart.swf?data=DynamicWebCharts/Data/protected2_dataparser1.asp?<%=Request.QueryString()%>" />
<param name="quality" value="high" />
<embed src="DynamicWebCharts/open-flash-chart.swf?data=DynamicWebCharts/Data/protected2_dataparser1.asp?<%=Request.QueryString()%>" quality="high" pluginspage="http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="940" height="300"></embed>
</object></td>

The chart should only display data related to this unique ID.

We have set the wizard to Filter on the ID, equals - then "entered Value" (as opposed to Session Variable or URL Param) and ID.

Is this the correct way to set the wizard up do get the chart to display all the data associated with the ID?

What is the difference between entered values, param values and session values?

Finally can I say that Yes!, we are new to all this stuff - so please be gentle with your answers !!!!

did you add this part to code manually "<%=Request.QueryString( )%>"? this is not correct.


Do you want to filter the chart on a specific value only? or do you want to be able to different values in?

if you want to be able to pass differant values in, then you did not set the filtering up right.

If you want to pass different values in set the filter up as:
ID, equals
QueryString, <Enter name of the querystring variable to use>


where e<Enter name of the querystring variable to use> is the querystring variable name.

For example, if you call the page as "myPage.asp?id=3" the qurystring to use is "id"

set the filtering up as:
ID, equals
QueryString, id

thanks very much, it works.

Is it also possible to pass more than one variable to the chart?

E.g. on an overview page a loop creates two charts, one should now display ID=1 data, the other ID=2.

Thanks very much for the help.

yes, you can pass multiple variables using differant querystrings:

myPage.asp?id=3&id2=6


you will need to go into advanced view to add the aditional perameters to the recordset, check on how the first one is created, to get an idea of how to the create the second for the id2 querystring

thanks very much, I will try that.

you're welcome.