Integration with Excel 2003
Integration with Excel 2003
A Microsoft Office Excel 2003 spreadsheet solution provides FabriKam employees and managers with a summary report of completed expense reports previously assigned to them. The spreadsheet automatically identifies the user by Windows login name and returns data that is only relevant for the user. The spreadsheet displays the data in a PivotTable dynamic view so that the user can change the report layout and summarize data in various ways.
The key components of this reporting solution include a stored procedure in the Finance database and a Microsoft Office Excel 2003 spreadsheet template. In the following subsections, these key components will be explained through the use of screen shots and code examples.