Page 1 of 2 12 LastLast
Results 1 to 15 of 19
  1. #1
    Star Lounger
    Join Date
    Aug 2002
    Location
    Des Moines, Iowa, USA
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Exporting Access report to PDF format (XP)

    I have some reports which need to be sent out to several individuals. I have been told to export the reports to a PDF format. Access doesn't have PDF within its export options. Does anyone know of a product that will do this, or better yet, a method of accomplishing this without a third party tool??

    I realize that a report can be exported as a snapshot and viewed. I do not know if the snapshot can be updated or not, thus the reason for the question. In addition, those were the orders brought down from on high. Any help again, is greatly appreciated!!

  2. #2
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Altnau, Thurgau, Switzerland
    Posts
    447
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Exporting Access report to PDF format (XP)

    My understanding of a snapshot is that it is a snapshot not something that can be modified. To export in PDF you will need some third party tool.
    An alternative is to do your reporting in something other than Access such as Crystal Reports. That does have a PDF export built in (for the latest version). This option is not the simple way to go for a currently existing app.

  3. #3
    Star Lounger
    Join Date
    Aug 2002
    Location
    Des Moines, Iowa, USA
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Exporting Access report to PDF format (XP)

    I was unsure about the snapshot, having never worked with it. I assumed it was not updatable, and your response makes me feel better about using it.

    Just as your response came in, I learned that Crystal Reports would work. Either way, I'm treading into new territory. After speaking with the brass, I was given the OK for the snapshot, so I'll give it a try. Thank you for your response. I sense by your response that even though Crystal will work, it won't be as good a solution as the snapshots. That helps me out a bunch!! <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>

  4. #4
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Exporting Access report to PDF format (XP)

    Also know that if using the Snapshot viewer, the recipients of the files may not be able to open the snapshot if the software is not installed. (Which, BTW, you can download for free from the Microsoft Web Site) We use Snapshot files all of the time and find that they work quite well since they maintain the graphic format of the files.

    Good Luck
    Regards,

    Gary
    (It's been a while!)

  5. #5
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Exporting Access report to PDF format (XP)

    If you have Adobe Acrobat software installed you can "save" (print) Access report as .PDF file by opening report in Print Preview, select Print... from File menu, then select Acrobat PDFWriter or Acrobat Distiller from Printer list. (Distiller sometimes provides better results if report has a lot of graphics.) At work we use Acrobat to distribute Access reports to "customers" as .PDF files, as .PDF is considered somewhat of a "universal" format. The snapshot format was not considered a viable option, as most users don't have the viewer installed, and it would be too burdensome to expect them to install the software. Reports saved and optimized as .PDF files are also smaller in size than comparable .SNP snapshot files, and can be annotated with highlighting, comments, bookmarks, etc in Acrobat.

    HTH

  6. #6
    Star Lounger
    Join Date
    Aug 2002
    Location
    Des Moines, Iowa, USA
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Exporting Access report to PDF format (XP)

    You bring up some interesting points. Are you just using Acrobat, or is there a third-party tool being used within Access to create the PDF, then view using Acrobat?

  7. #7
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Exporting Access report to PDF format (XP)

    I'm using Acrobat 5.0. There's no add-in required, you "print" the report using one of the Adobe Acrobat print drivers just as you would with any other type of document that you print to .PDF. You have to have the Acrobat software installed to create a .PDF file. I've heard of 3rd-party tools that allow you to save a document in .PDF format without having Acrobat installed, but I've never had the need to use any of these and therefore cannot attest to the quality (or lack of same) of the documents produced by these tools, or whether they would work with Access reports.

    HTH

  8. #8
    Star Lounger
    Join Date
    Aug 2002
    Location
    Des Moines, Iowa, USA
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Exporting Access report to PDF format (XP)

    Using Acrobat is a possibility. Currently, I am searching third party tools to find something that will as seamlessly as possible, make an Access report into a PDF. If that falls through, these ideas give me some options to use as a plan B. I'll need to weigh the pros and cons of Acrobat vs. snapshots. Thank you so much for your time!!!

  9. #9
    4 Star Lounger
    Join Date
    Jan 2002
    Location
    Brookings, South Dakota, USA
    Posts
    449
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Exporting Access report to PDF format (XP)

    Hi Mark,
    Please excuse me for breaking in on this thread, but I *have_to* use Adobe to email our department's billing to other departments as we (SDSU) are a mixed shop, as it were. The reason is/was that I couldn't find an Access snapshot viewer for the MacIntosh machines on campus. Did I just not look hard enough or isn't there one?
    btw, I have no probems at all using Adobe and am able to generate and attach the .pdf files to emails through code, but am curious if there is a MAC snapviewer.
    Thank you.

    gdr
    <IMG SRC=http://www.wopr.com/w3tuserpics/gdrezek_sig.jpg>
    "Those who dance are considered insane by those who can't hear the music" - George Carlin

  10. #10
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Exporting Access report to PDF format (XP)

    Hi Steve

    Check out www.DanePrairie.com for Wind2PDF $35 for win2k as described in Smart Access 12/2002

    Post back the solution you end up using

    HTH

    John

  11. #11
    Star Lounger
    Join Date
    Aug 2002
    Location
    Des Moines, Iowa, USA
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Exporting Access report to PDF format (XP)

    Thank you. I will check out DanePrairie.com and study their product.

    Currently, I have found in VBxtras.com a tool called SumIT report tool. It is supposed to be able to report on data from Access, Oracle, Sybase, SQL Server, Vision, FAME, and other OLEDB data sources. From it's description, it saves reports in a Report Definition File (RDF), that can then generate report output in HTML, PDF, and Excel format. There is a demo version available which I am about to try out. Sounds promising, but then again, don't all products??

  12. #12
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Exporting Access report to PDF format (XP)

    I confess to total ignorance in all matters Mac-related, I've never so much as used one. Every PC I've ever used was running one version or other of Windows or MS-DOS (penguins notwithstanding).... Regardless, according to MSKB Article 172348 ACC97: Report Snapshots and Microsoft Snapshot Viewer:
    <hr>You can distribute Snpvw80.exe to anyone who has Microsoft Windows 95, Microsoft Windows 98, Microsoft Windows NT 4.0, or Microsoft Windows 2000. The Snapshot View control (Snapview.ocx) requires Service Pack 5 or later if you are using Microsoft Windows NT version 3.51.<hr>
    This tends to imply the answer is NO for Snapshots on Macs.... (I assume the above also applies to Snapshot Viewer 9.0 (A2K) and 10.0 (AXP)). I checked the Snapshot Viewer Help file as well but could find no reference whatsoever to installation or use on a platform other than Windows.

    HTH

  13. #13
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Exporting Access report to PDF format (XP)

    Since there is no Access for the Mac, it is not realistic to expect a snapshot viewer for the Mac. Sorry. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Charlotte

  14. #14
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Exporting Access report to PDF format (XP)

    There are a number of third party tools you can use to create a PDF file, but the result won't be as secure as the Access snapshot format. Some of them are free or extremely low cost, so if all you want to do is print the report to a PDF format try a product like pdf995.
    Charlotte

  15. #15
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Altnau, Thurgau, Switzerland
    Posts
    447
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Exporting Access report to PDF format (XP)

    Crystal is an excellent product but you have to buy it. The snapshot format comes with Access and the viewer is free and small (ca 64KB) to download. Should the recipient of a pdf file not have a viewer then the adobe viewer is many MB to download.

    Also Crystal does not take an Access report and convert it to pdf. The report needs to be designed in Crystal and then called from Access hence a lot of work for existing reports.

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •