SAP Reports 2011, WIN, INTL, NUL 7090310 User Manual
Product codes
7090310
22.1.1.1 Unlinked
Unlinked subreports are free-standing; their data is not in any way coordinated with the data of the
primary report.
primary report.
In unlinked subreports, there is no attempt to match up the records in one report with records in the
other. An unlinked subreport does not have to use the same data as the primary report; it can use the
same data source or a different data source entirely. In addition, the subreport is not limited to reporting
on a single table. An unlinked subreport can be based on a single table or on multiple tables. Regardless
of the underlying data sources, the reports are treated as unrelated.
other. An unlinked subreport does not have to use the same data as the primary report; it can use the
same data source or a different data source entirely. In addition, the subreport is not limited to reporting
on a single table. An unlinked subreport can be based on a single table or on multiple tables. Regardless
of the underlying data sources, the reports are treated as unrelated.
22.1.1.2 Linked
Linked subreports are just the opposite; their data is coordinated. The program matches up the records
in the subreport with records in the primary report. If you create a primary report with customer information
and a subreport with order information and link them, the program creates a subreport for each customer
and includes in that subreport all the orders for that customer.
in the subreport with records in the primary report. If you create a primary report with customer information
and a subreport with order information and link them, the program creates a subreport for each customer
and includes in that subreport all the orders for that customer.
22.1.1.3 Database links vs. subreports in one-to-many situations
When two tables in a report have a one-to-many relationship, the program retrieves the data in different
ways depending on:
ways depending on:
•
Data source.
•
Index situation.
•
Record selection criteria.
•
Whether you are creating a single report based on linked tables or a primary report that contains a
subreport.
subreport.
When you are considering whether to use a subreport or linked tables, you need to understand the
ramifications of each. These issues are discussed fully in
ramifications of each. These issues are discussed fully in
.
As a general rule, if you have indexed tables, linked indexed fields, or range limiting record selection
criteria based on the indexed fields, the program needs to read the same number of records whether
you are linking tables in a single report or using subreports. Since each subreport is run as a separate
report, linked tables may have a performance advantage. See
criteria based on the indexed fields, the program needs to read the same number of records whether
you are linking tables in a single report or using subreports. Since each subreport is run as a separate
report, linked tables may have a performance advantage. See
2011-05-16
492
Subreports