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

2.00

WINDOWS


---------------------------------------------------------------------
The information in this article applies to:

 - Microsoft Access version 2.0
---------------------------------------------------------------------

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.
