ACC2: Subreport/Report Section Missing with Output To Command
ID: Q112752
|
The information in this article applies to:
SYMPTOMS
Advanced: Requires expert coding, interoperability, and multiuser skills.
When you use the Output To command to create an output file for a report
that contains a subreport, the output file is missing not only the
subreport, but also the entire report section in which you placed the
subreport.
CAUSE
The Output To command does not process a subreport contained in a report
(or a subform contained in a form). Moreover, if you use the Output To
command with a report that contains a subreport, neither the subreport nor
the report section in which you placed it are included in the output file.
RESOLUTION
To work around the problem, use one of the following methods:
- If you have the Generic/Text Only printer driver installed, you can use
the Print command to create an output file. To do so, choose Print from
the File menu. In the Print dialog box, select the Print To File check
box, and then choose the Setup button. In the Specific Printer box,
select Generic/Text. When you click the OK button to print the report,
the subreport data is included in the output file.
- You can open a subreport as a separate report, and then use the Output
To command to create a separate output file.
- You can remove the subreport from the report before you use the Output
To command.
STATUS
Microsoft has confirmed this to be a problem in Microsoft Access version
2.0. This problem no longer occurs in Microsoft Access version 7.0.
MORE INFORMATION
Steps to Reproduce Problem
- Open the sample database NWIND.MDB.
- Preview the Sales By Year report.
- In the Sales By Year dialog form, type 6/1/91
for the beginning date, type 6/30/91 for the
ending date, and then choose the OK button. Note that the
page that is displayed has a page header section, a group header
section, a detail section, and a page footer section.
- From the File menu, choose Output To.
- In the Select Format box, select Rich Text Format (*.rtf), and then
choose OK.
- Choose OK to accept the default filename (sales_by.rtf) for the
output file.
- When you are alerted that the subreport will not be processed, choose
OK.
- 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.
REFERENCES
For more information about the Output To command, search for "Output To,"
and then "Output To Command (File Menu)" using the Microsoft Access Help
menu.
Additional query words:
outputto
Keywords : kbinterop RptSub RptProb
Version : 2.0
Platform : WINDOWS
Issue type : kbbug