Hello, I need help in this matter:
We have a template of Excel file in which all calculations are already set. User can request a 'report'. Idea is to create a button on our site (SharePoint portal). After clicking on it a new Excel file is generated. This means to get actual data from database (SQL Server 2005 SP2), import them into template, let all calculations to generate proper data and then allow user to see this file.
For now it's enough to publish final Excel file in document library. I am quite new in WSS 3.0 and MOSS 2007 and I need some advice in what can be the best solution.
Looks like a quite complex task for me. Is there some direct way how to accomplish this? Or maybe I need one tool to get data from database and to import this data into Excel file (SSRS?) and other tool to publish it in document library (MOSS7 Excel services?). I heard something about PerformancePoint Server 2007, is this a way to follow?
Thanks forward for any advice!