Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 08-20-2019, 05:15 AM   #1
HangoutGuy
Newly Registered User
 
Join Date: Aug 2019
Posts: 28
Thanks: 18
Thanked 0 Times in 0 Posts
HangoutGuy is on a distinguished road
Repeats in report view not showing up when the report is exported as a PDF

Hi all,

I'm having a slight issue with a report that I would like to be able to save as a PDF.

When I run the report in report view, everything looks just how I want it. For instance an Employee is listed with their location and their projects they work on. If they work on more than one project a new line is added underneath the employee and lists only information that was not listed in the line before it (i.e. the location and employee name is not repeated).

Now when I export this report to a PDF via a macro, the form changes up slightly. For instance if there is one employee in location 1 and the next employee on the form is also from location 1, the name of the location will not be repeated on the line for the second employee. This does happen in report view, just not in PDF.

I'm just really confused as to why the report view would do what I want but the exported version. Some guidance would be much appreciated!

Thanks.

HangoutGuy is offline   Reply With Quote
Old 08-20-2019, 06:22 AM   #2
arnelgp
error reading drive A:
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 8,569
Thanks: 68
Thanked 2,745 Times in 2,630 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Repeats in report view not showing up when the report is exported as a PDF

do you have same result on Report View and Print Preview?
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Old 08-20-2019, 06:24 AM   #3
HangoutGuy
Newly Registered User
 
Join Date: Aug 2019
Posts: 28
Thanks: 18
Thanked 0 Times in 0 Posts
HangoutGuy is on a distinguished road
Re: Repeats in report view not showing up when the report is exported as a PDF

Yes, but I seem to have figured it out after playing around with Group & Sort settings.

HangoutGuy is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Results of DLookup not showing in Report View, but are visible in Print Preview gwunta General 6 09-17-2019 12:51 PM
data showing in report view not in print preview willigsu Reports 9 01-14-2016 09:58 AM
Report repeats 35 times DennisDown Reports 10 09-30-2015 11:38 PM
Lines/borders in Access report not showing when exported to Word LynnEsther Reports 3 07-01-2009 05:19 PM
Report field borders not showing when exported to word Rai Reports 3 04-07-2006 01:25 PM




All times are GMT -8. The time now is 10:25 AM.


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