Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Seattle, Washington, USA
    Posts
    179
    Thanks
    0
    Thanked 0 Times in 0 Posts

    2 column report and subreports (Access 2000 SR1)

    I have a stumper here. I need to print two separate reports at the same time (One group is based on campers and one is based on volunteers) for a roster. I simply created two separate reports and called them rsubCampers and rsubVols and then created a third report called rptRoster and then placed both subreports on the rptRoster without Parent/Child relationship. I placed a page break between two subreports and it works just fine and dandy.

    HOWEVER -- Now, the requirements has changed. Now, we need two column reports to save paper and when I set it up in the rptRoster, the first "section" (Campers) doesn't show two columns because the page break would have messed up the second column, so by default, Access ignores the two-column setup. So, I set up both subreports to show two columns each, but then it doesn't show up in rptRoster as if subreports' formatting get stripped out.

    How in the world do I somehow open one report and tell it to print two separate reports in multicolumn and yet keep both subreports on separate pages? <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23>

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: 2 column report and subreports (Access 2000 SR1)

    Perhaps a simpler solution would be to provide a click-button or a menu on the switchboard to print both reports. That way you can keep them separate and not worry about trying to format each one differently on the subreport. It seems to me you should be able to make it work the way you tried, but at the moment it isn't obvious how. Hopefully someone will have an idea.
    Wendell

Posting Permissions

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