 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / February 2008Printing Sub Reports in Access
Hi - I have 2 sub reports included in one main report. Two sub reports run on different queries. In the Print Preview of the main report, it is fine. But when i try to print on a printer, it prints a blank page. Please HELP!!!!! Really appreciate your time. Thanks. are you able to sanity check and compare behavior on a different PC/printer?  SignatureNTC > Hi - I have 2 sub reports included in one main report. Two sub reports run on > different queries. [quoted text clipped - 7 lines] > > Thanks. Ya i have tried printing on 2 diff printers and also a Pdf writer. Non works. Any ideas Please!! > are you able to sanity check and compare behavior on a different PC/printer? > [quoted text clipped - 9 lines] > > > > Thanks. you are saying that one of the subreports shows data on screen; but is blank when printed? or are you saying that there is a blank page appended to the end of the report when printed? SignatureNTC > Ya i have tried printing on 2 diff printers and also a Pdf writer. Non works. > [quoted text clipped - 13 lines] > > > > > > Thanks. Both the subreports have data in Print Preview mode. But when i have to print, then it prints a blank page. There is no data printer by the printer ever though i see data in the print prview mode Thanks!! > you are saying that one of the subreports shows data on screen; but is blank > when printed? [quoted text clipped - 19 lines] > > > > > > > > Thanks. no one else has jumped in with another idea....sometimes the MVPers only look at new posts - so you might need to report this one because I don't know. Generally very odd behavior in a report can be caused by the printer driver. You state you tried different printers; but you did not explicitly state you tried different PCs...be sure to try different PCs.... sub reports won't appear if there is no data. but they will not appear on screen either....so if it is not this then generally it would be the printer driver the only other thing I think of is whether someone embedded a little VBA to make those subreports not visible when printed...possibly as a mild security thing...but if you are the author then that isn't viable.... SignatureNTC > Both the subreports have data in Print Preview mode. But when i have to > print, then it prints a blank page. [quoted text clipped - 27 lines] > > > > > > > > > > Thanks. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.