This topic is locked

Output data to graph?

3/24/2004 4:21:55 PM
ASPRunnerPro General questions
Pete M author

Hi,
I wondered if there was a way to output a server dataset to view as a graph.
I know this is not a function of ASPRunner, but does anyone know of a way to achieve this? A simple bar chart is needed.
Thanks
Pete

Sergey Kornilov admin 3/25/2004

If somebody can recommend easy to use free or inexpensive ASP charting component I can add this functionality to ASPRunner.

Pete M author 3/25/2004

Thanks Sergey
I found this tip for Creating html bar graphs in ASP/VBSscript
http://www.pstruh.cz/tips/detpg_html-bar-g...graph-chart.htm
I'll keep looking! <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=1486&image=1&table=forumreplies' class='bbc_emoticon' alt=':D' />

Pete M author 3/25/2004
A
alexander 3/29/2004

I sometimes use a simple "hack" method for graphing data. Take a small color square and give the width, or height depending on which way you want the bars to run, an ASP database value. For example
<img border="0" src="images/theme/graph_bluesquare.bmp" width="<%=5fp_rs("Office")%>" height="10">
For this example, I multiplied the database value by 5 because the record set had such small values that the graph bars needed more length.
Another trick I use is to hyperlink the bars to the dataset, so that you can click the bars to see the values composingh the bar. Here's an example of how to do it:
<form method="POST" action="qry_Office_list.asp" name="frmAdmin" target="_blank">
<input type="hidden" id="action" name="action" value="AdvancedSearch">

<input type="hidden" id="SearchOption" name="SearchOption" value="Equals">

<input type="hidden" id="FieldName" name="FieldName" value="Office">

<input type="hidden" id="NeedsQuotesPRAOffice" name="NeedQuotesOffice" value="True">

<input type="hidden" id="SearchFor" name="SearchFor" value="<%=FP_FieldVal(fp_rs,"Office")%>">
<a href="#" onClick="submit()">

<img border="0" src="images/theme/graph_bluesquare.bmp" width="<%=5
fp_rs("Office")%>" height="10">

</a>

</form>