I need to convert 16 Access reports and 2 subreports to Crystal Report and write a [url removed, login to view] form to pass the parameters to the reports.
This is a new bid I am doing as my first bid didn't go thru.
All reports are currently using an Access 2000 database both for the forms/reports and the data.
You can find all the reports (16) in Access design mode and the form (1) in the document attached to this bid. Labels are in French. The subreports (2) are used in 4 reports. The forms contains combo boxes (fed from a database) and text fields to be used as parameters.
The difficulty is that from the form, parameters are to be passed to the reports, all parameters are not necessarily used.
In the Access report I am calling visual basic modules to fill up some data. You will have to find a workaround for this. I am also preparing the underlying query for the subreports before previewing the reports. If you're a Crystal Report specialist you'll probably know how to do that.
I would like to have the data access from the reports to be put in a data access layer. In the [url removed, login to view] part I am writing we have written all the data access in classes. I don't know if this can be done with Crystal Report. Please tell if it's possible or not I would like to.
Be responsible when bidding: don't say that it can be done in 1 day, don't commit yourself if you feel the time frame is too short.
Bid ONLY if you feel very confortable with Crystal Report (especially with passing thru parameters), SQL Server 2000, Access, [url removed, login to view] 2003, and if you are not scared to see French for field's names and labels.
I will provide the Access database and the SQL Server database in SQL Server 2000 format.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. This means one form to trigger the reports and the reports.
2) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).
[url removed, login to view] 2003 form the form
Crystal Report coming with [url removed, login to view] for the forms
SQL Server 2000 database for the data
Also the old application runs in Access 2000