Results 1 to 3 of 3
  1. #1
    susendy is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jul 2013
    Location
    New york
    Posts
    2

    reports

    I have 2 reports with different page settings that I would like to print in one double sided document. I tried to join the 2 reports by adding one as a subreport however I'd noticed that even though the 2 reports have different page settings once I add the subreport to the main report the subreport setting automatically change to the same settings as the main report.



    Can someone give me an idea of how to join the two reports but keeping the 2 different report settings.

    Thanks so much in advance

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    49,479
    Can't. Main report controls pagination.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Clayton is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jul 2013
    Posts
    6
    Download a free pdf printer, print the two reports, combine them (pdfcreator from Sourceforge lets you "wait and collect documents"). Then you can 'print' the document into one pdf. Then you can print that pdf double-sided.

    What specifically changes in the subreports page settings that you don't want to change? Have you tried making sure "Show Page Header and Page Footer" is set to "Yes" on subreport control in the main report?

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

Similar Threads

  1. 3 Reports into 1
    By kmims44 in forum Reports
    Replies: 2
    Last Post: 06-19-2012, 12:34 PM
  2. Convert Client Reports to Web Reports
    By need_help12 in forum Reports
    Replies: 0
    Last Post: 05-08-2012, 08:22 AM
  3. Get all reports
    By nkuebelbeck in forum Programming
    Replies: 13
    Last Post: 06-27-2011, 12:30 PM
  4. Reports w/ sub-reports very slow to open
    By vaikz in forum Reports
    Replies: 2
    Last Post: 02-27-2011, 08:41 AM
  5. Access Reports drop sub-reports
    By Kevin Ellis in forum Reports
    Replies: 0
    Last Post: 11-19-2010, 03:28 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