I modified a report that contains a subreport so that the user can filter by Group. When the user clicks on the Group Name from a Form, the report opens fine and the information displays only data for that group, however, when the user prints the report (either to printer or pdf) the report is unfiltered. Turns out that I had code that resets the subreport's query immediately after print preview. I then recalled that someone had once informed me that the queries are rerun when the report is sent to the printer, even though the preview screen shows the report. This is what was causing the hard copy and pdf of the report to be unfiltered. Once I moved the code to reset the query to the close event of the form, the report printed fine and matched the print preview.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Hard Copy or PDF don't match print preview screen
- Thread starter sxschech
- Start date
Similar threads
- Locked
- Question
