SAP Crytal Report

How to create Crystal Subreports?. The Complete SAP Crytal Report Developer Course 2023 [Videos].

Subreports allow you to combine unrelated reports into a single report. It is a report within a report. You can combine data that cannot be linked and present different views of the same data in a single report.

Difference between Subreport and main report −

  • It is used as an element in the main report and cannot be used as single report.

  • A Subreport cannot contain other subreports.

  • It can be placed in any report section and the entire subreport will print in that section.

  • It doesnt have page header or page footers sections.

Unlinked Subreports

Unlinked subreports are standalone reports and their data is not linked to data in the main report. An unlinked subreport does not have to use the same data as the main report; it can use the same data source or a different data source entirely. Regardless of the underlying data sources, the reports are treated as unrelated.

Linked Subreports

Linked subreports use data that is coordinated with data in the main report. The program matches up the data in the subreport with data in the main report. If you create a main report with customer information and a subreport with order information and then link them, the program creates a subreport for each customer that includes all their orders.

Subreports can be linked with data-passing links or with subreport filters.

Inserting Subreports

You can insert a new report or an existing report as subreport in a main report. The subreport has similar characteristics as the main report. The data source to be used in subreport must be similar to data source that is used in main report and it must also be located on the same BI repository. You can also choose a different source connection but it should have a field to link to main report.

A subreport cant be inserted into another subreport. A subreport can be placed in any report section and the entire subreport will print in that section. However, a subreport cannot stand on its own. It is always inserted as an element into a main report.

Formatting Subreports

How to Insert a Subreport to a main report?

Go to Insert tab, click Subreport → The program displays an element frame.


Move the cursor to where you want it to appear in the report, and click to place it.

The Insert Subreport dialog box appears → Select create a new report → Type a name for the report in the Report Name text box. (You can also insert an existing subreport).

New Subreport

Use Main Report Data Source
  • The Edit Query page appears

Connect to a new Data Source
  • The Choose a Data Source Connection dialog box appears

  • Select a data source, and then click Next

  • The Edit Query page appears

Choose an option from the Data Connection area, and click "Next". If you choose Use Main Report Data Source it will open Query panel to add objects in the report.

Edit Query Project

If you select connect to a new Data source, it will open New Data source connection window from which you can choose a new data source.

Once you choose new data source, you need to define the relationship between the main report and the subreport.

Subreport Links

Once you click on "Next" it will prompt you to choose a Sub Report type like Detailed, Chart, Total, Custom.

Insert Subreport

Click on finish → it will show in the Structure of the main report. If you click on Page tab it will show the data of Subreport in the main report.

Subreport Reports

To insert an existing report as a subreport

On the Insert tab, click Subreport → The program displays an element frame.

Move the cursor to where you want it to appear in the report, and click to place it.

The Insert Subreport wizard appears → Select Use existing report, and then click Browse.

Existing Subreport

The Open dialog box appears → Select the report that you would like to use, and then click Open → Click Next.

If the report you selected contains parameters, the Data Passing Links page appears.

Set up the appropriate links, and click "Next". The Create Subreport Filters page appears → Create links between your main report and subreport by clicking Add → Click Finish.

The report that you selected is added as a subreport.

To save a subreport as a main report

You can also save a subreport as a main report.

Right click on the subreport frame, and click Save Subreport As → Save As

Save Subreport

Type a new name for the subreport → Click Save.

The subreport is saved as a main report and you can open it and use it.

Edit the properties of a subreport

You can edit the properties of a subreport after you have inserted it into your main report. To format subreports −

Right click on the subreport frame and click Format Subreport.

Format Subreport

The Format dialog box appears → Edit the values.

For example, you can change the name of the subreport, edit the font, size, color, etc.

Click Close.

To combine two unrelated reports

Create the report you want to be printed first as the main report.

Create a new subreport.

Place the subreport into the Report Footer and it will print immediately after the main report.

Report Footers

Creating an on-demand subreport

On-demand subreports can be especially useful when you want to create a report that contains multiple subreports.

The difference between regular subreports and on-demand subreports is that the actual data of an on-demand subreport is not read from the data source until the user isolates it. This way only data for on-demand subreports that are actually viewed will be retrieved from the data source. This makes the subreports much more manageable.

To create an on-demand subreport: Place an ordinary subreport in your main report. Right click on the subreport, and click Format Subreport. Click the Subreport option, and select On Demand.

Subreport on Demand

See All

Comments (370 Comments)

Submit Your Comment

See All Posts

Related Posts

SAP Crytal Report / Blog

What is Crystal Reports ?

SAP Crystal Reports is a Business Intelligence tool which is used to generate reports from both SAP and non-SAP data sources. It enables end users to generate reports that includes exceptional visualizations and implement new business requirements into reports to reduce dependency on IT and Report developers.
7-Feb-2022 /17 /370

SAP Crytal Report / Blog

What is GUI Navigation in Crystal Reports?

Crystal Reports for enterprise provides an interface that enables you to quickly and easily create, format, and publish effective reports. The menu bar provides full range of features available in Crystal Reports for Enterprise as shown in the following image.
7-Feb-2022 /17 /370

SAP Crytal Report / Blog

What is Options in Crystal Reports?

Report Options is one of the most commonly used feature in Crystal Report Designer, when you need to access/modify the values of Report Options of a Crystal report at runtime in a Crystal Reports .NET application.
7-Feb-2022 /17 /370