Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.
Course Of The Month
Become a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Force data to print all one page - export as pdf
Posted on 2012-12-26
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
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
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
4-
4
2- +2
12 Comments
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...
Or
2. Use a larger size paper
Let's see what other experts may post...
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...
Possible crop the screenshot, then save as a PDF...
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
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
last ditch effort...
Try contacting the developer(s) of this product
http://www.peterssoftware.com/ss.htm
...perhaps something custom can be created...?
Try contacting the developer(s) of this product
http://www.peterssoftware.com/ss.htm
...perhaps something custom can be created...?
Active today
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?
Have you considered using automation to generate a PowerPoint chart?
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?
Did you try looking for all the "xxx.dll" files in the file system, delete them, and re-build all again?
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.
Sorry I can not post a sample of the data due to personal data in database.
Karen
Sorry I can not post a sample of the data due to personal data in database.
Karen
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
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
Featured Post
We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month5 days, 16 hours left to enroll
Earn Certification
Administering Microsoft SQL Server 2012 Databases (Exam 70-462)
$79.00$71.10
627 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.