Results 1 to 5 of 5
  1. #1
    RickK is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2014
    Posts
    16

    Exporting Chart report to PDF

    I have a single report that generates two separate charts from two separate queries. When I export it to PDF file , it places one chart on page one and the other chart on page two in the PDF. How do I keep the two charts locked to the same page in the export?

    Thanks
    Rick

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    8,797
    Create a 3rd report that uses the other 2 reports as Sub reports.
    now explore this report to 1 PDF.

    docmd.output report.....acFormatPDF

  3. #3
    RickK is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2014
    Posts
    16
    Quote Originally Posted by ranman256 View Post
    Create a 3rd report that uses the other 2 reports as Sub reports.
    now explore this report to 1 PDF.

    docmd.output report.....acFormatPDF

    I only have one report . I am placing two charts on one report already. but when I export it to PDF it places each chart on its own page and I need them on the same page.

  4. #4
    RickK is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2014
    Posts
    16
    Quote Originally Posted by ranman256 View Post
    Create a 3rd report that uses the other 2 reports as Sub reports.
    now explore this report to 1 PDF.

    docmd.output report.....acFormatPDF

    But just for fun, how do I place the two reports into one report as you spoke of?

  5. #5
    RickK is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2014
    Posts
    16
    Never mind , i figured it out.

    Thanks

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Chart grouping in a report
    By james28 in forum Reports
    Replies: 8
    Last Post: 03-01-2014, 10:33 PM
  2. Replies: 7
    Last Post: 02-18-2014, 03:36 PM
  3. Replies: 10
    Last Post: 08-29-2013, 09:21 PM
  4. Adding a chart to a report
    By Bigmix in forum Reports
    Replies: 7
    Last Post: 02-14-2012, 08:47 AM
  5. Exporting a chart to Excel?
    By hraup in forum Access
    Replies: 0
    Last Post: 08-31-2006, 12:21 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums