ms access reports

  • Thread starter Thread starter matt shudy
  • Start date Start date
M

matt shudy

Is there any way to bring in a report from access? I made
a chart of my data, and want to display it on my website.

Thanks,

Matt
 
To dynamically display a chart with live data is a bit
more than what FP will do for you. Do a web search
for "ASP dynamic chart code access database" and you'll
find some sites that will get you a start. Companies
make a living doing just this stuff.

But if you don't need to use live data, create a static
chart. Once you've created a chart, you can save the
graphic as a GIF file and post that to the web.
 
Actually, you can certainly do that with FrontPage. However, it requires
some ASP programming to do it. When I did bar charts with ASP and FrontPage,
I created a table, and inserted different colored 10X10-pixel images aligned
at the bottom of a row of cells. I then set the width of the images to a
fixed width, and the height of the images was set using a server-side script
tag that plugged a variable value obtained from a data source into it.
Something like the following:

<tr>
<td height="200"><img src="red.gif" width="20"
height="<%=RecordSetName("field1"),Value%>"></td>
<td height="200"><img src="blue.gif" width="20"
height="<%=RecordSetName("field2"),Value%>"></td>
<td height="200"><img src="green.gif" width="20"
height="<%=RecordSetName("field3"),Value%>"></td>
</tr>

Of course, you might have to apply some math to the value obtained from your
RecordSet, in order to make the number of pixels in height come out to the
range that you want it to, but that's just a matter of adding a math
function to do the conversion.

--
HTH,

Kevin Spencer
..Net Developer
Microsoft MVP
http://www.takempis.com
Big things are made up
of lots of little things
 
Back
Top