We have a classic database reporting setup with SQL Server 2005, ASP .net 2 and IE 6. The reports produced are highly customised and do not neatly fall into datagrid style layouts. Additionally the reports have already been developed to use an excel pivottable embedded in the report to select and layout the data (using GETPIVOTDATA).
We want to make it possible for a user to be able to select a number of parameters from a webpage to filter the data in the report and then make the report available for download.
Can the Office Web Component (OWC) be used to load a copy of the excel template and refresh the pivottable against a stored procedure in SQL?
This works using Excel Automation, however Excel cannot be installed on the webserver; the Office Web Component (OWC) is available. Version 10 is currently installed, although 11 could be installed if necessary.