Environment: VB6.0, Crystal Reports 9.0 uses Crystal Reports in a project to summarize some experiences and lessons. Take a piece of hand to make a document. The document includes a document, a document. The single and documents may be a couple of relationships. And they exist in two tables, and associate with field FID. The incoming parameter FID can be dynamically displayed, showing different results. First, open Crystal Reports, do a good job of a document RPT. There are many ways to make a report, such as: use its graphical tool to create a connection between several tables, then try the field you want to display to the report; or call a written stored process; or Edit Command directly. Then, the field you want to display is reached. However, there is often a report here, and the reports made by graphical tools are often not corresponding because of the fields when they pass the DataSource in VB, and some data cannot be displayed. So it is recommended to use Commrital Reports to use Command to edit SQL statements to create documents. This SQL statement COPY is then generated in the VB code, generating a new result set and assigns a new data source to the RPT file. This guarantees the correspondence between the fields. Suppose the document header information is stored in the table quotation, and the document is stored in the table quotationentry. The list of information needs to be displayed in the header information, the document number fbillno, the document date fbillno, the date fbildate, the single-person FBILLER ...; the document needs to be displayed, including product code Fnumber, product style FStyle, product size FSize, product color fcolor ... two table related fields FID. Thus, add SQL statement in the Command of the RPT file "SELECT A. *, B. * From quotation a left join quotationentry b on a.fid = B.fid". Then pull the desired field into the report. In VB, first apply Crystal Reports 9 ActionX Designer Disign and Runtime Library, and add part Crystal Report Viewer Control 9. Add the components just added to the Form. You can call and display it.
