Re: Export report as PDF

From: SA (~fake.address_at_nspm.com)
Date: 03/31/04 

Date: Wed, 31 Mar 2004 09:57:39 -0500

Cheryl:

>From our experience, its not necessarily true that setting the report to
landscape in design will it output a landscape PDF with PDFWriter (or
distiller or other drivers for that matter) when the report printed from a
preview or simply sent to print. Even if the report is set to landscape in
design, unless PDFWriter is set to the be the specific printer for the
report, the report can revert to portrait when its printed from preview and
from time to time when its simply printed out. (its a driver issue.)

Thats' one reason that our PDF and Mail Library for Access provides the
ability to set report orientation and paper size when outputting a pdf from
an Access report as in:

 Dim objPDF as New PDFClass
 With objPDF
    .ReportName = "My Landscape Report"
    .OutputFile = "c:\some dir\some file.pdf
    .AdvancedRptProp True, 2 'Set to landscape orientation
    .PDFEngine = 1 'PDFWriter
    .PrintImage
End With

HTH 

-- 
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg
"Cheryl Fischer" <cherylfischer@NOSPAMmsn.com> wrote in message
news:u0pPlTxFEHA.740@tk2msftngp13.phx.gbl...
> If the Access report is designed with its Page Setup properties for
> landscape, it will be written to a PDF file in landscape.   At least that
is
> how PDF995 does it for me.
>
> --
>
> Cheryl Fischer, MVP Microsoft Access
> Law/Sys Associates, Houston, TX
>
>
> "Ben" <anonymous@discussions.microsoft.com> wrote in message
> news:55F4F811-C6E2-4BF2-9B78-9E62A0008EF2@microsoft.com...
> > Thank you.
> >
> > I do have PDF writer.  I was able to save it as PDF in Portrait
> orientation.  But when I tried to save a report to PDF as Landscape, the
> report does not look right at all.  Is there an easy way to fix this,
> besides click on View and select Rotate View Clockwise in Adobe Reader?
> >
> > Thank you!
> >
> >      ----- Cheryl Fischer wrote: -----
> >
> >      The easiest way to do this is locate and download one of the many
> available
> >      PDF drivers.  (I use PDF995 available from:
 http://www.pdf995.com )
> Do a
> >      Google search on PDF drivers to see others.
> >
> >      These drivers install as if they were printers and you can select
the
> PDF
> >      driver when the report is open in Preview by selecting File|Print
> from the
> >      menu.
> >
> >      --
> >
> >      Cheryl Fischer, MVP Microsoft Access
> >      Law/Sys Associates, Houston, TX
> >
> >
> >      "Ben" <anonymous@discussions.microsoft.com> wrote in message
> >      news:AB448CDA-CF07-45C7-9F88-B9B7401F9C34@microsoft.com...
> >      > I need to export reports as PDF files, but I do not know how.
Can
> someone
> >      please help me?
> >
> >
> >
>
>

Relevant Pages

  • Re: Report formatting Disappears on Some Items when Output to PDF in Code
    ... Now use my code to putput your Report to PDF. ... It does print in Snapshot format - all perfectly. ... I set my default settings on my printer (Legal and Landscape were the ...
    (comp.databases.ms-access)
  • Re: Report formatting Disappears on Some Items when Output to PDF in Code
    ... Now use my code to putput your Report to PDF. ... I set my default settings on my printer (Legal and Landscape were the ...
    (comp.databases.ms-access)
  • Re: Export report as PDF
    ... driver I mentioned. ... its not necessarily true that setting the report to ... > landscape in design will it output a landscape PDF with PDFWriter (or ... > Thats' one reason that our PDF and Mail Library for Access provides the ...
    (microsoft.public.access.externaldata)
  • Re: Creating a program that appears like a printer driver...
    ... access to the drivers SDK, ... > also purchased a system called FaxPress, ... > Crystal Report document, run it, get the image (export to pdf would be my ...
    (microsoft.public.vb.general.discussion)
  • Re: Export report as PDF
    ... landscape, it will be written to a PDF file in landscape. ... But when I tried to save a report to PDF as Landscape, ... > Google search on PDF drivers to see others. ...
    (microsoft.public.access.externaldata)
Loading