Charts Fail with Path image
I am trying to create a simple pie chart with dynamic data from a SQL server database. I have IIS 6, configured the site to use ASP Vbscript and tested the database connection using simple dynamic text statement. This is a link to a test page:
FASTU.asp
As you can see the database is responding to the simple query with a table of values. The pie chart I want should show the portion of students from each college, such as 20% CLAS, 40% COE and 40% CAP, for an example.
I used the most simple approach I could think of, and I still just get the path to the dataparser.asp! These are the settings I used in the wizard:
Chart Tab:
Only edit to default values on this tab is the change to Type: Pie
Data Tab:
Edits to default values are --
Choose dynamic
Choose connection, data source from the drop-downs
X Label: set to "College" from the drop-down
Group by: set to Value
Y Value: set to "unique" (a unique integer identifier) from the drop-down
Calculation set to Count
No other edits are made in the wizard.
I have installed, uninstalled, reinstalled, deleted WinCache.dat.
Can you help me to understand what I need to do?
Thanks!
Sue