I am using an application with MS Access as a front end and SQL server 2000 at the back-end. presently MSI am using MS excel is bien gused as a reporting tool to create charts in a spread sheet.?
I need to switch these charts ( reports) into crystal XI. I will provide database, sql statements and stored procedures. we can do it in phases 4 reports per week .
## Deliverables
Attached is a file that will give you little idea what I am trying to acheive.
?
this is an applicatoin that runs in MS Access ( as front-end) and backend is SQL server 2000. For reporting tool client is using MS excel.
?
on reporting fom page, you will see MS Acess form called: DavidOff, this is used to trigger excel and print reports there.
?
there is also one excel spreadhseet in the attachment, that is what is created as a report, within this spreadsheet you will see worksheets with names [R13], [R26] etc.............. these are report name and are saved as charts.
?
if you go to VBA code of this spreadsheet, module: Ouverture . this one has sql query statements for all these reports and parameters. we will only copy and paste these and use them in crystal reports. tables are already set up. it is just a matter of recreating these reports in crystals XI. these are simple reports.
?
I will send you database in a separate file, as it is too big to come in this email.