Hi,
We have data in a MS SQL database that our client wishes to access for
analysis purposes. They would like to view the data in an Excel spreadsheet
that they can download over the web. The spreadsheet contains two pages:
Page 1) Raw data, Page 2) Pivot Table based on raw data. The user should be
able to specify filter parameters for the data returned such as start date,
end date, facility code, etc. Our current environment includes MS IIS
running ColdFusion to dynamically create and serve pages over the web.
The big question is: Can we dynamically create the Excel spreadsheet, given
the required input parameters, on the server? And if so, what are the steps
to do this? Does any one have any helpful tips of how best to go about
solving this situation?
Thanks!!!
--
Kevin Epp
Bookmarks