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

Source: Internet
Author: User
Tags odbc odbc connection odbc connection to sql server access database visual studio
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


Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.