There are different Excel options to export the data of a Crystal Report. This format does export most of the formatting, however, it does not merge cells, and each element is added to only one cell. This format can also export certain summaries as Excel functions. This exporting format is an enhancement on the existing Microsoft Excel Workbook Data-Only exporting type.
|Published (Last):||20 September 2013|
|PDF File Size:||12.3 Mb|
|ePub File Size:||5.12 Mb|
|Price:||Free* [*Free Regsitration Required]|
You might, for example, have customer data in a primary report and then use subreports to show the orders for each customer. In such cases, you will need to coordinate the data in the primary report with the data in the subreport so that the orders in each subreport match up with the correct customer.
To do this, you need to specify a field that is common to both the subreport and the primary report. With the Subreport Links dialog box, you create a link between the two common fields. Crystal Reports uses the link to match up records from the primary report to those in the subreport.
To link a subreport to the data in the primary report If you are creating a new subreport or importing an existing report as a subreport, from the Insert menu, click Subreport. Choose or create a report and click the Link tab. The Subreport Links dialog box appears.
Choose the subreport you want to link from the For subreport list if it is not already selected. Select the field you want used as a link field in the primary containing report from the Available Fields list. Repeat steps 3 and 4 for each additional link, as desired. If nothing is specified here, the subreport will adopt the organization of the primary report. Click OK. When you run the report, the program will coordinate the data in the primary report with the data in the subreport.
Note: The field type of the Containing Report field determines which subreport fields are visible. Linking a subreport to the main report without modifying the selection formula Crystal Reports uses a parameter field mechanism for linking subreports to main reports. When linking a main report field that is not a parameter field to a subreport field, the program: Automatically creates a parameter field to complete the link.
Modifies the subreport record selection formula to select those records in which the subreport field is equal to the parameter field value. At times, you may wish to use a linked parameter field in a subreport without using it as part of the selection formula for the subreport. For instance, you may want the main report to pass in a summary value that can be used in calculations by the subreport, or you may want the main report to pass in the title of the subreport.
When you link a field in the main report to a parameter field that you have created in the subreport, the program: Checks the link you have specified. Does not create any additional parameter fields. Does not modify the subreport record selection formula. To link a subreport to a main report without modifying the selection formula Create a parameter field in the subreport.
Link a field in the main report to that parameter field. Combining unrelated reports by using subreports At times, you may wish to combine unrelated reports into a single report. For example, you may want to create a single report that presents: Sales grouped by sales representative. Sales grouped by item. While both reports deal with sales data, there is no real linear relationship between the reports.
Subreports can be used to combine unrelated reports into a single report like this. While the reports could be based on the same data set, they do not have to be. They could each be based on entirely different data sets. Each of these reports is free-standing; the data in any of the reports is not linked in any way to data in another report. This is the easiest of the subreport options to work with. To combine two unrelated reports Create the report you want printed first as the primary report.
Import an existing report for use as a subreport or create a new subreport. Place the subreport into the Report Footer and it will print immediately after the primary report. To combine three or more unrelated reports Create the report you want printed first as the primary report.
Import or create each of the other reports you want to use as subreports. Use the Section Expert to insert enough Report Footer sections to match the number of subreports that you are using. For example, if you want to use three subreports, insert two new Report Footer sections so that you have a total of three Report Footer sections. In Report Footer A, place the subreport you want printed immediately after the primary report.
In Report Footer B, place the subreport you want printed next, and so forth. The primary report will print first and then the subreports in the order that you placed them in the report.
Note: Subreports can be placed side-by-side in the same Report Footer section. They will print next to each other at the end of the report. Place the subreports into the Report Footer sections and they will print sequentially after the primary report. Using subreports with unlinkable data Tables can be linked in a report as long as the following criteria are met: The link fields are both database fields.
The link fields contain similar data. The link fields are the same length. The link field in the link to lookup table is indexed PC databases only. Linking tables is rarely a problem. However, there are some circumstances in which you cannot coordinate data from different tables because the data does not meet the linking criteria.
For example, linking to or from a formula field, or linking two unindexed tables cannot be done in a single report. Subreports must be used. While the return value is a valid Social Security Number, the fact that it comes from a formula prevents you from using the field to link to a Social Security Number field in another table.
You can report on and coordinate the values in the two tables, however, by using a subreport. Place the subreport where you want it to appear in the primary report.
Want to know more? Bookmark the permalink. Post navigation.
When I export an On demand subreport to a pdf format, cannot open subreport
Tozilkree I need a solution to this as well. All data from the main report is forced left unless there is data from the sub in front of it. I am using CR Exporting to Excel with subreports. I think my solution is inevitablly cryztal to come from the sql that generates the data for these reports, by forcing it to return the same number of rows for all three sub-reports instead of null values where data may not exist in one. All your sub reports must be linked to a common field in order to line up correctly. This page was generated in 0.
Crystal Reports - Data Export To Excel
When we want to show some additional information about the data in the Crystal Reports , we use the subreports to show the details. Subreports we show within the main Crystal Reports and also we can show it as On-Demand report , that means we put an Hyper link in the row, and when user click that hyper link then will get the subreport. This section we are showing the subreport within the Crystal Reports. That is for each row there is a subreoprt for the details. All Crystal Reports programming samples in this tutorials is based on the following database crystaldb. Please take a look at the database structure before you start this tutorial - Click here to see Database Structure.