Solved

Report printing question

Posted on 2014-02-07
6
286 Views
Last Modified: 2014-02-08
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
Comment
Question by:SteveL13
  • 3
  • 2
6 Comments
 
LVL 84
Comment Utility
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
 
LVL 3

Accepted Solution

by:
suribaba801 earned 500 total points
Comment Utility
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
 
LVL 84
Comment Utility
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
Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

 

Author Comment

by:SteveL13
Comment Utility
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
 
LVL 84
Comment Utility
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
 

Author Comment

by:SteveL13
Comment Utility
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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now