Report in PDF with images

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.

Re: Report in PDF with images

"Contralto" wrote in message
news:1193124979.993997.174960@e9g2000prf.googlegroups.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.

Re: Report in PDF with images

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

Re: Report in PDF with images

Contralto wrote:

>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/

Re: Report in PDF with images

On Oct 24, 1:18 pm, "Tony Toews [MVP]" wrote:
> Contralto wrote:
> >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.