Solved

Force data to print all one page - export as pdf

Posted on 2012-12-26
12
1,202 Views
Last Modified: 2013-01-02
I have created a Access 2007 report to generate an org chart and export it as a pdf.  Is there a way to force the report to display all data on 1 page, like you can shrink to fit in some programs.

My current page format is set to Tabloid, using Columns with narrow margins between columns, yet some of my data pours over to another page.  That is understandable but I am looking for a way to force the report to shrink to fit when I am exporting it to a PDF?

Any suggestions?

K
0
Comment
Question by:Karen Schaefer
  • 4
  • 4
  • 2
  • +2
12 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 38721945
1. Shrink the Report (and the associated controls) to fit in the paper size you need.
Or
2. Use a larger size paper

Let's see what other experts may post...
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 38722023
an "ugly" suggestion would be to do whatever you had to to display the report fully, (raise your screen resolution, increase the paper size), then make a screenshot of it.
Possible crop the screenshot, then save as a PDF...
0
 

Author Comment

by:Karen Schaefer
ID: 38722035
I need to output either to PDF or Excel - I would prefer not to export to excel because I would have to deal with columns and rows - to match the employee with the Unit/Manager for the Org Chart.

I have already tried all the previous suggestions and I run into problems of text wrapping wrong or truncating data.  I played with the number of Columns on a page and the column sizes, since the different units can vary in number of Orgs & employees it is hard to capture all the possibilities.

I was hoping for a shrink to fit method for exporting the report out to a PDF, since it would need to happen prior to the actual saving of the PDF.  Here is my current line of code to generate the output PDF.

           DoCmd.OutputTo acOutputReport, "rptOrgChart_template", acFormatPDF, nrptName, True, , 0, acExportQualityScreen
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 38722059
last ditch effort...

Try contacting the developer(s) of this product
http://www.peterssoftware.com/ss.htm
...perhaps something custom can be created...?
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 38722090
Can you provide use with a sanitized screen shot of what you are currently getting?  Are you displaying your results in a structure like a treeview, or in a more standardized wiring diagram?

Have you considered using automation to generate a PowerPoint chart?
0
 

Expert Comment

by:smrocco
ID: 38722141
Are you using proyect references or file references?

Did you try looking for all the "xxx.dll" files in the file system, delete them, and re-build all again?
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

Author Comment

by:Karen Schaefer
ID: 38722145
????Are you using proyect references or file references?????? What???

k
0
 

Expert Comment

by:smrocco
ID: 38722149
Sorry I pasted this by error and could not edit before you added your post.
0
 

Author Comment

by:Karen Schaefer
ID: 38722315
Here is my latest attempt I changed the font size to 8, narrowed the space between columns and it almost fits on a tabloid size page.

sample
Sorry I can not post a sample of the data due to personal data in database.

Karen
0
 
LVL 30

Expert Comment

by:hnasr
ID: 38722648
Does that mean you solved the problem?
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
ID: 38722727
Even if you did get this to fit with the 10 columns...
As soon as you need an 11th column, you will be back where you started.

A clarification:
<almost fits on a tabloid size page>
"Tabloid" is the same size as "Ledger".
The difference is the orientation.
Ledger is Landscape and Tabloid (AKA: "Newspaper") is Portrait.
So your paper size there is actually Ledger.

So unless you are willing to move up to a Continuous Sheet feed "Plotter", ...Ledger is the biggest paper most printer drivers will support...

You can see the Wikipedia link for more info on paper sized above Ledger.
http://en.wikipedia.org/wiki/Paper_size

Hope this helps

Jeff
0
 

Author Closing Comment

by:Karen Schaefer
ID: 38738047
Thanks for the great assist as always
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
HasData 9 37
Run Time Error 3075 15 45
Run Time Error 3071 26 39
MS access report - how to make a heading be zero when no data exists 17 37
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
A theme is a collection of property settings that allow you to define the look of pages and controls, and then apply the look consistently across pages in an application. Themes can be made up of a set of elements: skins, style sheets, images, and o…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

920 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

15 Experts available now in Live!

Get 1:1 Help Now