Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rating: Thread Rating: 3 votes, 5.00 average. Display Modes
Old 04-24-2013, 09:08 AM   #1
IAccess
Newly Registered User
 
Join Date: Apr 2013
Location: California
Posts: 8
Thanks: 1
Thanked 0 Times in 0 Posts
IAccess is on a distinguished road
Question Exporting Report to PDF blank fields on some computers only

Hi all,

I have a report (Access 2007) with subreports that is being exported to pdf. It all works fine on PC except for on a virtualbox and a laptop. When the user exports the report to pdf, it leaves some subreports blank! If the report is opened in the DB it pulls data as it should and all looks fine.

In the report, the missing data is from 4 subreports in the same top section of the report where a 5th subreport also resides. Subreport 5 is displayed OK. There is no dynamic formatting nor filtering in the reports.

These two machines had to have the 2007 Microsoft Office Add-in: Microsoft Save as PDF installed for the PDF export to work at all. Both machines are up-to-date on the latest windows updates. The virtual box runs XP while the laptop runs Windows 7.

This is the strangest error I have ever encountered as it only partially fails and it cannot be replicated on a regular PC. Any help is greatly appreciated.

J.D.

IAccess is offline   Reply With Quote
Old 04-25-2013, 01:49 PM   #2
Estuardo
Newly Registered User
 
Join Date: May 2003
Location: Portugal
Posts: 134
Thanks: 3
Thanked 15 Times in 12 Posts
Estuardo
Re: Exporting Report to PDF blank fields on some computers only

G' evening J.D.,
Let me ask you something. Can you print your report without problems? install a pdf printer and see if the problem persist. If so the problem is with your add-in.
G'd luck
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Creative Tools for Creative Developers
Estuardo is offline   Reply With Quote
Old 04-26-2013, 01:19 PM   #3
IAccess
Newly Registered User
 
Join Date: Apr 2013
Location: California
Posts: 8
Thanks: 1
Thanked 0 Times in 0 Posts
IAccess is on a distinguished road
Re: Exporting Report to PDF blank fields on some computers only

Thanks Estuardo,

We tried printing it hard copy and it is the same problem. Actually the blank problem is visible in "print preview" but not in "view" and only for this report section. We did manage to get the print preview to work if the sub report is opened by itself but not when it is by itself as a sub report. This suggests some issue with report internal refreshing before print or possibly fonts. We tried changing fonts but that didn't help. Strangely all works perfectly fine on all other computers tested.



J.D.

Naturally it had to be the boss' computer that doesn't work.

IAccess is offline   Reply With Quote
Old 04-26-2013, 05:32 PM   #4
Estuardo
Newly Registered User
 
Join Date: May 2003
Location: Portugal
Posts: 134
Thanks: 3
Thanked 15 Times in 12 Posts
Estuardo
Re: Exporting Report to PDF blank fields on some computers only

Can you refresh the report's datasource? have you tried open-close-open? The fonts are the less likely because the MS Office suite replace those fonts that does not exist in the host.
All machines have the same OS and same MF Office version?
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Creative Tools for Creative Developers
Estuardo is offline   Reply With Quote
Old 05-22-2013, 12:22 PM   #5
IAccess
Newly Registered User
 
Join Date: Apr 2013
Location: California
Posts: 8
Thanks: 1
Thanked 0 Times in 0 Posts
IAccess is on a distinguished road
Re: Exporting Report to PDF blank fields on some computers only

Still no solution to why this is happening. We tried adding 3 buttons for the same report. Printing & Output doesn't work while Viewing works just fine.

Methods
Output:
DoCmd.OutputTo acOutputReport, sReportName, acFormatPDF, sFilePath, False

Print:
DoCmd.OpenReport sReportName, acViewNormal

View:
DoCmd.OpenReport sReportName, acViewReport


IAccess is offline   Reply With Quote
Reply

Tags
blank , export , field , pdf , report

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Filter multiple fields in a report with a form and allow blank fields to be returned manderson_zim Modules & VBA 5 04-02-2011 03:08 AM
[SOLVED] Macro to Skip blank report when Exporting Reports fenderdave Macros 2 08-04-2006 02:28 AM
Blank fields on report sammy16 Reports 1 10-19-2004 04:23 PM
Blank fields on report??? Muzicmn Reports 2 01-06-2004 09:22 PM
Exporting Memo Fields From Report to Excel Jason General 5 11-01-2002 02:56 AM




All times are GMT -8. The time now is 01:02 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World