Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 298
  • 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
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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