I work for a company that deals in property management. Every month, we have a financial report that runs that gathers various pieces of information and formats onto a report. Each report is for one site, and there are over a 100 sites in total.
In addition to the paper copies that the DB produces, which for information is Access 2003 front end on a SQL2K back end, What I have been asked to look into is the possibility of this information being loaded into an Excel Spreadsheet. Each Report's data appearing on a unique worksheet that is named as per a variable that is generated by the report generation process.
So for every month, I would click a button and an empty Spreadsheet would be created, the first report would run and the data dumped into a worksheet named for arguments sake 'Apple', then the next report would run and the result would be dumped into a new worksheet called 'Banana' in the same spreadsheet and so on and so forth.
One saving grace I guess is that the amount of fields on each report is consistant from month to month site to site. It is only the information contained within that changes.
Can someone point me in a direction or give me some pointers here on what I can be learning or steering towards
Thanks
In addition to the paper copies that the DB produces, which for information is Access 2003 front end on a SQL2K back end, What I have been asked to look into is the possibility of this information being loaded into an Excel Spreadsheet. Each Report's data appearing on a unique worksheet that is named as per a variable that is generated by the report generation process.
So for every month, I would click a button and an empty Spreadsheet would be created, the first report would run and the data dumped into a worksheet named for arguments sake 'Apple', then the next report would run and the result would be dumped into a new worksheet called 'Banana' in the same spreadsheet and so on and so forth.
One saving grace I guess is that the amount of fields on each report is consistant from month to month site to site. It is only the information contained within that changes.
Can someone point me in a direction or give me some pointers here on what I can be learning or steering towards
Thanks
