Microsoft KB Archive/113562

PRA: Report Section with Subreport Not Included In Output File PSS ID Number: Q113562 Article last modified on 08-01-1994

2.00

WINDOWS

= SYMPTOMS =

When you use the Output To command to output a report to a file, any section of a report that includes a subreport is not included in the output file.

= CAUSE =

It is by design that when you use the Output To command to output a report to a file, subreports are not included in the output file. However, the presence of a subreport in any section of a report prevents the entire section from being included in the output file.

= RESOLUTION =

Remove the subreport from the report section and output the report again.

= STATUS =

Microsoft has confirmed this to be a problem in Microsoft Access version 2.0. We are researching this problem, and will post new information here in the Microsoft Knowledge Base as it becomes available.

= MORE INFORMATION =

Steps to Reproduce Problem

 * 1) Open the sample database NWIND.MDB.
 * 2) Preview the report Sales By Year.
 * 3) In the Sales By Year Dialog form, enter “6/1/91” (without quotation marks) for the beginning date, and enter “6/30/91” (without quotation marks) for the ending date. Choose OK.
 * 4) Note that one page is displayed, with a page header section, group header section, detail section, and page footer section.
 * 5) From the File menu, choose Output To.
 * 6) In the Select Format box, select Rich Text Format (*.rtf), and then choose OK.
 * 7) Choose OK to accept the default filename (sales_by.rtf) for the output file.
 * 8) When you are alerted that the subreport will not be included, choose OK.
 * 9) Open the SALES_BY.RTF file in any editor (such as Microsoft Word for Windows, or Microsoft Write) that can open a Rich Text format file. Note that the entire group header section is missing from the file, because the group header section of the Sales By Year report contains a subreport.

NOTE: The height of the detail section in the Sales By Year report is set to 0.1667 inches to add space between detail records. Setting the height of the detail section to 0.1563 inches will avoid double spacing in the output file.

Additional reference words: 2.00 KBCategory: KBSubcategory: RptSub

=
================================================================

Copyright Microsoft Corporation 1994.