Q: Subreports

To limit the information displayed in a subreport:

1. Set up criteria in the subreport which will filter the information in the subreport to show only the required records. For example, records for a particular customer.

2. Pass a value from the primary report to the subreport criterion; for example, the customer reference.

   See Subreport criteria.

Select the subreport, then choose Report > Criteria. The Manage Criteria window appears. Check the listed criteria for one that is suitable.

Otherwise, you can add new criteria by clicking New Criteria.

To pass a value from the primary report to the subreport criterion, see Subreport criteria.

You can set a static filter in the subreport, but criteria are more useful when dealing with subreports as you can match the information in the subreport to the information in the primary report.

Try to ensure that each report (including subreports) results in a single database query. If you have a subreport on each row of the primary report, this will result in one database query for the primary report, plus one query per row for the subreport; which will be slower than not using subreports.

No. A subreport can't contain another subreport.

A subreport is embedded in a primary report. Also, a subreport can't contain another subreport.

On the primary report click the embedded subreport. Small squares appear as a border around the subreport. Move your cursor over these squares and drag the borders to the size you want.

No. Subreports that are contained in your report are not exported to Excel.