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
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.