Experience in the use of Crystal Reports (Crystal report 4.6) in VB6

Crystal Report My first contact with the Crystal Report was in March 2001 when my colleague Comrade Yin Xiaoxiang began contacting the Crystal Report.

Crystal Reports (Crystal report 4.6) support only the database in the ACCESS97 format, so set the table and table in the Access2000 format first

System, and then convert the table to 97 format,
After the 97 database is transferred in the Crystal Report, the relationship between the tables is automatically found in links.

Crystal Report in the VB installation disk has been brought. Path: Common\tools\vb\crysrept\crystl32. Exe
Serial Number: 1231467890
After installation, run path: \program Files\Microsoft Visual Studio\common\crw32.exe

The reason for using the Crystal Report in VB6 is that it supports the binary field (BLOB binary large object)
Use the Crystal Report steps:
First into the VB menu bar: add-in--Report Designer automatically into the Crystal Report, design a good report, stored as a report file,

such as Sql.rpt
The introduction of parts in VB Project Crystal 4.6

If it is an Access database, activate the code:
Crystalreport1.discardsaveddata = True ' automatically refreshes data from the database
Crystalreport1.reportfilename = App.Path & "\mdb.rpt"
Crystalreport1.windowstate = crptmaximized
Crystalreport1.action = 1
If it is a SQL Server 2000 database, activate the code:
Crystalreport1.connect = "ODBC;DNS=SQL_DB1; Uid= "& Text4.text &"; Pwd= "& Text5.text &

";D sq=db1" ' ODBC connection to SQL Server server
Crystalreport1.discardsaveddata = True ' automatically refreshes data from the database
Crystalreport1.reportfilename = App.Path & "\sql.rpt"
Crystalreport1.windowstate = crptmaximized
Crystalreport1.action = 1

Important:
A. If you want to maximize the paper display when you need a report preview, you need to set it in Crystal Report Designer: File--report Options-preview

Pages Start with--full Size
B. If you only need to display the detail section, right-click on the left side of the other section of the Report Designer's design interface, and then eject the shortcut

Menu selected:
Hide section
C. If you want to print one record at a page, right-click on the detail typeface under the design interface of Report Designer, and in the format section

Selected in
New Page After
D. If the detail section requires a character field to be automatically folded to display, double-click the field to select:
Print on multiple lines
E.detail a partial numeric display format, double-click the field to eject the display formatting options
F. No Crystal Reports have been found with the function of column printing, BCB quickreport. Text