Reply |
| alice johnson replied to Kaleem Khan at 05-Jul-08 01:20 |
create Crystal Report in Visual Basic 6.0 ,Follow this steps:
1. Start a new project in Visual Basic 6.0.
2. Go to the Project Menu, choose More Active X Components, Data
Environment. This takes you into the data environment.
3. Go to properties of the DataEnvironment1 and change the name to
Xtremedb.
4. Underneath the Xtremedb environment there is another icon that says
Connection1, right mouse click and pick properties. This pulls up the data
link properties dialog box.
5. Choose Microsoft OLE DB Provider for ODBC Drivers.
6. Click on the next button.
7. Choose your datasource from the dropdown box that is labeled use data
source name.
8. Press the OK button.
9. Right mouse click on the Connection1 again but this time choose Add
Command.
10. Right mouse click on the Command1 icon and pick properties.
11. For Command Name Type Employee, keep the Connection as the same.
12. For Source of Data:
Database Object – choose table
Object Name – Employee
Choose OK
Create the report
1. Open the Crystal Reports designer.
2. Under the File Menu, New, Custom Report, SQL/ODBC. This will pull up
the Logonserver dialog box.
3. Pick Active Data [ADO], then OK.
4. This pulls up the Select Data Source dialog box, select your datasource
from the dropdown box then press the Next button
5. Fill in your UserName and Password if needed then press the Finish button
6. The Choose SQL table dialog box comes up, pick ADO
7. This allows you to insert the fields on to the report.
8. Once you have placed all of the desired fields on the report, Save it as
Adotest.rpt
Hope this will help you
You can also refer thsi LInks for reference
http://training.nic.in/courseware/VB%20Files/presentations/Reports.pdf
http://resources.businessobjects.com/support/communitycs/TechnicalPapers/cr_ocx_dataenvir.pdf?recDnlReq=Record&dnlPath=cr_ocx_dataenvir.pdf
Happy coding takecare |
|