• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 297
  • Last Modified:

Report printing question

I have a report which when previewed on screen looks fine.  The report has calculated fields that sum values from three different subreports.  But when I print the report to a printer, the calculated fields display as #Name?

What's up with that?

--Steve
0
SteveL13
Asked:
SteveL13
  • 3
  • 2
1 Solution
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
How are you printing to the printer? By that, I mean do you open the report in Preview mode, then print? Or do you select the report in the Nav Pane and "open" it? Or are you using code?
0
 
suribaba801Commented:
I think the dialogue form is being closed from the 'Preview' command button (on the form) after the command to preview the report, so the data is not available if you wanted to print the report
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I'm not quite clear on how the comment you accepted is relevant to the solution. You did not mention a dialog form, or how the data is being sourced.

Could you please clarify?
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
SteveL13Author Commented:
I had this line of code after the code to open the report.  When I commented it out it worked fine.

DoCmd.Close acForm, "FrmTimeCardEntryHeader"
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
But you didn't provide us with the code, or the database, so we could not know how you're opening the report, or how the data is sourced.

In other words - how did the comment you selected tie in with the details of this question?

I've asked the Moderators to review.
0
 
SteveL13Author Commented:
I am truly sorry if I've done something wrong in regard to this question I posted.  When ID 39842025 was posted it led me to the solution.  

Again, if I have offended anyone with my awarding the accepted solution I apologize.

--Steve
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now