By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,077 Members | 2,160 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,077 IT Pros & Developers. It's quick & easy.

Report in PDF with images

P: n/a
Hi, I can convert my report to Adobe PDF, but the photos are very
poor. They were taken as RAW images and I've tried saving them at
different resolutions as JPEGs, but it doesn't seem to make much
difference in the PDF output. I have about 500 images in the 200ish
page report (unless I split it into several smaller ones).

Each photo should be about 6-8cm on the longest side. Any
recommendations on what res to use would be most appreciated. The
photos are all in a different drive from the database and the report
picks them up and compiles the finished product.

Oct 23 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a

"Contralto" <Al**********@gmail.comwrote in message
news:11**********************@e9g2000prf.googlegro ups.com...
Hi, I can convert my report to Adobe PDF, but the photos are very
poor. They were taken as RAW images and I've tried saving them at
different resolutions as JPEGs, but it doesn't seem to make much
difference in the PDF output. I have about 500 images in the 200ish
page report (unless I split it into several smaller ones).

Each photo should be about 6-8cm on the longest side. Any
recommendations on what res to use would be most appreciated. The
photos are all in a different drive from the database and the report
picks them up and compiles the finished product.
I have had good luck with images in reports, using the techniques described
in the articles referenced below. I do not recall, in recent years, saving
reports with images via Adobe Acrobat, but I would guess that is where your
problem lies... Acrobat, or other PDF-saving software, and its
use/implementation of graphics.

The sample imaging databases at http://accdevel.tripod.com illustrate three
approaches to handling images in Access, and the download includes an
article discussing considerations in choosing an approach. Two of the
approaches do not use OLE Objects and, thus, avoid the database bloat, and
some other problems, associated with images in OLE Objects.

If you are printing the images in reports, to avoid memory leakage, you
should also see MVP Stephen Lebans' http://www.lebans.com/printfailures.htm.
PrintFailure.zip is an Access97 MDB containing a report that fails during
the Access formatting process prior to being spooled to the Printer Driver.
This MDB also contains code showing how to convert the contents of the Image
control to a Bitmap file prior to printing. This helps alleviate the "Out of
Memory" error that can popup when printing image intensive reports.
Oct 23 '07 #2

P: n/a
Thanks Larry,

I am getting the impression that the problem lies in converting from
an Access report to PDF. The report is fine in Access - good clear
images - but once it converts it's terrible.

The problem is I have to distribute this - preferably electronically
to people who don't have either Access or my database structure. I
may have to resort to printing it out straight from Access, on
hundreds of pages.
Cheers,

Robyn

Oct 24 '07 #3

P: n/a
Contralto <Al**********@gmail.comwrote:
>I am getting the impression that the problem lies in converting from
an Access report to PDF. The report is fine in Access - good clear
images - but once it converts it's terrible.
It could also be the DPI resolution specified in your current PDF writer software
whatever that might be.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Oct 24 '07 #4

P: n/a
On Oct 24, 1:18 pm, "Tony Toews [MVP]" <tto...@telusplanet.netwrote:
Contralto <AltoProfu...@gmail.comwrote:
I am getting the impression that the problem lies in converting from
an Access report to PDF. The report is fine in Access - good clear
images - but once it converts it's terrible.

It could also be the DPI resolution specified in your current PDF writer software
whatever that might be.

Tony
--
Hm, that's a thought. I'll start digging into Acrobat and see what I
can learn.

Oct 24 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.