Data Reports Querys

I have 11 reports created using CR 4.6. the one that comes with Visual Basic 6. I will refer to the Data Environment as DE, to crystal reports as CR, to command objects as cmd, SQL statements as SQLS. My proyect consists of creating a new vb proyect, adding a DE to the proyect, create the connection to the database I provided and then create all the command objects necessary to create the reports I created in Crystal Reports 4.6. After the coder provides me with the DE I will create the reports myself with the Data Reports designer that comes with Visual Basic 6. I need that the coder knows how to solve any problem involving the opening of reports in CR because when the reports location change error messages appear while trying to open each report, I need that the coder knows how to solve those problems. The reports location will change because the coder will install the reports in his computer. So the coder needs to know how to set the location of the database and how to verify the database using CR. When you open each report using CR, please check each one if it haves a selection formula. To check this please do the following inside CR: * Clic the Report Menu * Clic Edit Selection Formula * Clic Group For each report do the steps described above because if a report has a selection formula you need to know it because it has to be included in SQL format when you create the SQLS so that they filter the data according to the selection formula. The selection formulas are very simple so don't worry. In summary, I need that you create all the structure for the 11 reports using the DE so that when I am going to create my reports I just configure the DataSource property to the DE and the DataMember property to the command that needs to be used, part of this bid request is that you send me a Word document telling me which values I have to assign to DataSource propery and DataMember property for each report. Please create all the cmd so that I only need to put the fields in each report. I will take care of finding out in which section I have to put each field but I need that the coder who replies to this bid request be a very experiencied programmer that knows how to use very well the DE. Please download attachement, it contains the 11 reports, the database and Crystal Reports 4.6. A requirement for this bid request is that you have read all my bid request in detail and understood all the information.

## Deliverables

The Visual Basic 6 proyect with the dataenvironment, with the connection and all the required commands that will help me create the reports that were created in Crystal Reports 4.6

## Platform

Windows XP Windows 98 Windows 2000

Engineering Microsoft Access MySQL PHP Software Architecture Software Testing Visual Basic

Project ID: #3305248

About the project