User manual BUSINESS OBJECTS CRYSTAL REPORTS 10 TECHNICAL REFERENCE GUIDE

[. . . ] Crystal ReportsTM 10 Technical Reference Guide Business Objects, SA. North American Corporate Headquarters 3030 Orchard Parkway San Jose, CA 95134 Copyright © 2004 Business Objects SA. No part of this documentation may be stored in a retrieval system, transmitted or reproduced in any way, except in accordance with the terms of the applicable software license agreement. This documentation contains proprietary information of Business Objects SA. , and/or its suppliers. Trademark Acknowledgements The Business Objects logo, BusinessObjects, Crystal Reports, and Crystal Enterprise are trademarks or registered trademarks of Business Objects SA in the United States and/or other countries. [. . . ] Set oSubReportObject = oSection. ImportSubreport(App. Path & "\Orders. rpt", 0, 0) ' Open the subreport. Set oSubreport = oSubReportObject. OpenSubreport ' Get the "CustomerID" field in the "Customer" table ' from the main report. Set oMainDBFieldObject = oReport. Database. Tables. Item(1). Fields. Item(1) ' Get the "CustomerID" field in the "Orders" table ' from the subreport. Set oSubDBFieldObject = oSubreport. Database. Tables. Item(1). Fields. Item(3) ' Link the main report and the subreport. Set oSubreportLinks = oSubReportObject. Links Set oSubreportLink = oSubreportLinks. Add(oMainDBFieldObject, oSubDBFieldObject) ' Set the report source of the viewer and view the report. CRViewer1. ReportSource = oReport CRViewer1. ViewReport End Sub How to re-import a subreport and link to a main report This example links a subreport and a main report using the Add Method (SubreportLinks Collection) and then re-imports the subreport using the ReImportSubreport Method (SubreportObject Object). CrystalReport1 is connected to the xtreme. mdb database found in the \Program Files\Crystal 248 Crystal Reports Technical Reference Guide 2 Report Designer Component Object Model Decisions\Crystal Reports 10\Samples\En\Databases folder. A second report is created off the same data source in Crystal Reports using the Orders table. The report is saved in the sample application directory as Orders. rpt. The report "Orders. rpt" is then imported into CrystalReport1 through the Designer's user interface at design time. See "Inserting subreports" in Crystal Reports Online Help (crw. chm) for more information. See License Manager Help (License. hlp) for more information. ' Create a new instance of the main report. Dim oReport As New CrystalReport1 ' Declare the variables needed for adding ' the subreport links and reimporting the subreport. Dim oSubreport As CRAXDRT. Report Dim oSection As CRAXDRT. Section Dim oReportObjects As CRAXDRT. ReportObjects Dim oSubreportObject As CRAXDRT. SubreportObject Dim oSubrpt As CRAXDRT. Report Dim oReportObject As Object Dim bSubreport As Boolean Dim bReimported As Boolean Private Sub Form_Load() ' Search for all the report objects in each section. For Each oSection In oReport. Sections Set oReportObjects = oSection. ReportObjects For Each oReportObject In oReportObjects If oReportObject. Kind = crSubreportObject Then Set oSubreportObject = oReportObject Set oSubrpt = oSubreportObject. OpenSubreport bSubreport = True Exit For End If Next If bSubreport Then Exit For Next ' Link the "Customer ID" field from the Customer ' table in the main report to the "Customer ID" field ' from the Orders table in the subreport. oSubreportObject. Links. Add "{Customer. Customer ID}", "{Orders. Customer ID}" ' Import the subreport once again so that any changes ' are reflected in the main report. oSubreportObject. ReimportSubreport bReimported ' If bReimported is True the subreport imported successfully. ' If bReimported is False the subreport failed to import. Crystal Reports Technical Reference Guide 249 Examples If bReimported Then MsgBox "Subreport imported successfully. " Else MsgBox "Subreport failed to import. " Exit Sub End If ' Set the report source of the viewer and view the report. CRViewer1. ReportSource = oReport CRViewer1. ViewReport End Sub How to add and delete table links This example Demonstrates how to display information on a table link in a report using the properties of the TableLink Object, how to delete a table link using the Delete Method (TableLinks Collection), and finally how to add a table link using the Add Method (TableLinks Collection). CrystalReport1 is connected to the xtreme. mdb database found in the \Program Files\Crystal Decisions\Crystal Reports 10\Samples\En\Databases folder. See License Manager Help (License. hlp) for more information. ' Create a new instance of the main report. Dim oReport As New CrystalReport1 ' Declare the variables needed for adding ' the table links. [. . . ] 7, 8 T tables error in C . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 427 technical support . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7, 8 TermForJob. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 437 see also User-Defined Functions, programming in C TestConnectivity method . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . [. . . ]