Directory, what is a sub-report? Second, by using the subformation combination unrelated report three, the sub-reports of the unlink cannot be linked, display different views of the same data in a single report, one-to-many links --------- ----------------------- First, what is a sub-report? The sub-report is a report in the report. The process of creating sub-reports is similar to the process of creating a regular report. Sub-reports have most of the characteristics of the report, including its own record selection conditions. The only difference between the sub-report and the main report is that the sub-report: is inserted into the main report as an object; it can't stand independently (but you can save the sub-report as the main report). The entire sub-report will be printed in this section in any section of the report. Another sub-report cannot be included. Don't include header or footer.
There are four situations to usually use sub-reports: 1, combine unrelated reports into a single report. See Reports that are not related to the use of sub-reports. 2. Coordinating the data that cannot be linked. Please refer to the data used sub-reports that cannot be linked. 3. Display different views of the same data in a single report. See Different views of the same data in a single report. 4. Perform a pair of more thanks from the fields that have no index on the check field. For more information, see a pair of links.
Note: Use the sub-reports as needed without using a regular field sub-report to increase the performance of the reports that contain sub-reports. -------------------------------- Second, the report by using the sub-reports is sometimes hopeful The unrelated report is combined into a single report. For example, it may be desirable to create a single report to represent: According to the sales representative grouping. Sales according to the project group.
Although two reports handle sales data, there is no real linear relationship between the two reports. You can use sub-reports to combine unrelated reports into a single report like this. Although the report can be based on the same data set, it is not necessary. They can be based on a completely different dataset. Each of these reports is independent; the data in any report does not link data in another report in any way. This is the most easily used subscription option.
For all details, see Combining Two or more unrelated reports. ---------------------------------- Third, the data using the unable to link, as long as the following conditions are met, You can link tables in the report: The link field is a database field. The link field contains similar data. The length of the link field is the same. The link field with the (see) table link has an index (only for the PC database). Link tables have little problem. However, some data in different tables cannot be coordinated in some cases because the data does not meet the link conditions. For example, you cannot connect to the formula field in a single report, or you cannot link two tables that have no indexes. There must be a sub-report at this time. --------------------------------- Four, different views of the same data display the same data in a single report can be used Different views of data are provided in the main report. For example, a summary value may be displayed at the upper part of the report, and the details are displayed in the lower part. This can be done in a variety of different methods. The two easiest ways are: create a summary report into a primary report to create a detailed report into a sub-report. In this method, the detailed sub-report is placed in the Report Footer section. Create a detailed report to a primary report to create a subscriber report. In this method, the summary report is placed in the Report Header.
Link reports and coordination data using the appropriate link field. --------------------------------- Five, a pair of multi-link this tutorial explanation How to use Xtreme.mdb sample database "Customers", "Credit" and "Orders" tables create a to B, A to C report. The Xtreme.mdb database is located in the / program files / crystal decision / crystal reports / samples / chs / database content. Please create the instructions here as the guidelines for the A to B, A to C using your own database files.
Create a to B, A to C link
On the Standards toolbar, click New. On the Crystal Reports library, click "As Blank Report", and then click OK. Expand the Database File folder. Select the Xtreme.mdb database file and expand its "Table" folder. Highlight the Credit table and add it to the "selected table" area. Repeat the previous steps for the "Customer" and "Order" table. After adding all three tables, click the "Link" tab on the Database Expert dialog. If there is a link between these tables by default, click Clear Link. Manually link the Custom Credit ID field in the Credit table to the "Customer ID" field in the other two tables. Click "Sort Link". The "Link Sort" dialog box appears. Select a link and use the up or down arrows to arrange the link in the desired order. Click OK to return to the Link tab of Database Experts. Click "OK" to close the "Database Expert".
The relationship between A to B, A to C is now established in three tables.
