This sample shows how to create a dashboard where the user chooses from a list of
states, and relevant educational cost data and charts are returned for that state.
The model and data for this sample are contained in a static Excel workbook which
has been provided by Burt Baker at 1693 Analytics,
LLC, but it could just as easily come from a workbook which is dynamically
generated by SpreadsheetGear 2010.
The key steps in the generation of this dashboard are:
- The first time this page is loaded, the BuildStates() method loads the workbook
from disk and populates the listbox of states from the range of cells which have
been given the defined name "ListOfStates".
- The Page_Load() method constructs a URL which will instruct the image rendering
utility what to render.
- The constructed URL is assigned to the Image control on this page.
- The browser generates an HTTP request to the image rendering utility which generates
the dashboard.
|