Avatar of Karen Schaefer
Karen Schaefer
Flag for United States of America asked on

Force data to print all one page - export as pdf

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
Microsoft AccessMicrosoft Development

Avatar of undefined
Last Comment
Karen Schaefer

8/22/2022 - Mon
Jeffrey Coachman

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...
Jeffrey Coachman

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...
Karen Schaefer

ASKER
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
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
Jeffrey Coachman

last ditch effort...

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

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?
smrocco

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?
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Karen Schaefer

ASKER
????Are you using proyect references or file references?????? What???

k
smrocco

Sorry I pasted this by error and could not edit before you added your post.
Karen Schaefer

ASKER
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
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Hamed Nasr

Does that mean you solved the problem?
ASKER CERTIFIED SOLUTION
Jeffrey Coachman

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Karen Schaefer

ASKER
Thanks for the great assist as always