Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    May 2002
    Location
    Dubai, UAE, United Arab Emirates
    Posts
    105
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Subreports with Columns (XP Sp2)

    G'day All

    I have a subreport (inside a report) which is supposed to layout it's data in two columns (down then right, as set up in File Pages Setup Columns of the subreport). When I run the subreport outside the main report, I get the two columns whether I have them set down and right or right and down. No Problem.

    However when I run it inside the main report, it refuses to wrap into the second column when I have it set down and right, instead generating a new page. If I set the columns in the sub report to right and down it works fine.

    Width of the subreport inside the main report is adequate. I've played with Grouping and Keep Together properties of the various sections of the reports without success.

    Any sugegstions ?

    Regards Ken Pascoe

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Subreports with Columns (XP Sp2)

    This is a known problem, see ACC2000: Only a Single Column Is Printed in a Subreport with Multiple Columns. Subreports stretch vertically to fit in the available records, so when the subreport is set for printing Down, then Right, it never gets around to creating a second column. Setting it to print Across, then Down is the only workaround given.

  3. #3
    2 Star Lounger
    Join Date
    Jul 2002
    Location
    Sacramento, CA
    Posts
    193
    Thanks
    3
    Thanked 1 Time in 1 Post

    Re: Subreports with Columns (XP Sp2)

    Is there any new information on this? I have the need to do down and not across in the sub report in Access 2002 SP2.

    Thanks,
    Marty

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Subreports with Columns (XP Sp2)

    No, subreports simply don't work like that. It hasn't changed in Access 2002 and 2003 and I don't expect it to change in a next version either.

  5. #5
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    Richland, Washington, USA
    Posts
    407
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Subreports with Columns (XP Sp2)

    I was wrestling with this problem last week and came up with a solution that may help in some situations. The challenge is to get a multiple column down-then-across subreport to work -- as noted in this thread, unless you specify across-then-down, you don't get the multiple columns -- if the content extends past the end of the page, you get one column on the first page and a continuation (still one column) on the second page, etc.). However, things work more as you would expect if you specify across-then-down for the subreport multiple column page layout. Unfortunately, this format often doesn't work for multiple column report content.

    I have found that if you set the Can Grow property to No for the subreport control on the parent report and size the control to fill the physical size of the page (this can be a significant limitation), then the subreport will show multiple columns in the down-then-across format. The significant limitation is that if you have more subreport content than what fits in this fixed-height subreport control, the excess will not be visible. Nonetheless, this may be helpful if you know your content will not exceed one page (with multiple columns).

Posting Permissions

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