FileMaker
Dynamic Charts with ASP.NET
What it Does:
This example produces a JPG chart from FileMaker data. The data is sent to a Web server in the URL. A simple ASP.NET page on the Web server uses that data and the Office Web Components to create the chart, convert it to a JPG image and sends it back to the FileMaker Web Viewer.
Technologies used:
- IIS 6 running on Windows Server 2003
- Office Web Components version 11
- ASP.NET
How it works:
The URL is an unstored calculation so it updates whenever a new chart type is chosen or any of the data is changed.
"http://" & webServer & "/eightfive/Default.aspx?caption=" & chartCaption & "&catcaption=" & categoryCaption & "&valcaption=" & valuesCaption & "&type=" & chartType & "&categories=" & buildArrayString (chartCategories) & "&values=" & buildArrayString(chartData)
where "buildArrayString" is a custom function that uses the new List function:
Substitute ( List ( repeatingField ); "∂"; "|")
"eightfive/Default.aspx" is the location and name of the ASP.NET page on the web server. The remainder of the URL are "named arguments" that the ASP.NET page reads the data from.
The result of this calculation looks like this:
http://db-commerce.com/eightfive/Default.aspx?caption=Some Title&catcaption=months&valcaption=million $&type=line&categories=January|February|March|April|May|June|August&values=100|225|175|205|159|187|131