User`s guide

4.
Link the subreport to the primary report by linking the Social Security Number field in the primary
report ({file.SSN}) to the formula that extracts the number in the subreport ({@EXTRACT}). See
Linking a subreport to the main report without modifying the selection formula.
22.6.2 Linking unindexed tables
When using PC (not SQL or ODBC) databases, the link field in the lookup database needs to be indexed
in order to create a valid link. You cannot link the tables in a single report when two tables contain
related data yet neither is indexed on the field which you want to use as a link field, or when the primary
table is indexed but the lookup table is not. You must use subreports if you want to coordinate the data
in both tables.
Note:
It is important to note that linking unindexed tables or linking from an indexed primary table to an
unindexed lookup table may cause inefficient reporting. If your data set is large, this kind of report will
take considerable time to run. Use this technique only if you do not have other options.
22.6.2.1 To link unindexed tables
1.
Create the primary report.
2.
Create (or import) the subreport and insert it into the primary report.
See Inserting subreports.
3.
Use the unindexed fields (or the indexed field in the primary table and the unindexed field in the
lookup table) to link the subreport to the primary report. See Linking a subreport to the data in the
primary report.
22.7 Creating an on-demand subreport
On-demand subreports can be especially useful when you want to create a report that contains multiple
subreports. In this case, you can choose to have these subreports appear only as hyperlinks.
The actual data is not read from the database until the user drills down on the hyperlink. This way only
data for on-demand subreports that are actually viewed will be retrieved from the database. This makes
the subreports much more manageable.
Note:
Data for an on-demand subreport is not saved unless the subreport is actually open in a preview window.
2012-03-14500
Subreports