Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Virginia
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Columns in reports

    I am working on a report with 5 subreports. One of the sub reports is a 2 column report. If I print the subreport by itself, it has 2 columns as designed, but if I print the entire report, the it prints the first column and then puts the second column on a new page. Any suggestions as to the cause? I need a quick response!

    Thanks!

  2. #2
    New Lounger
    Join Date
    Dec 2000
    Location
    Rockhampton, Queensland, Australia
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Columns in reports

    The number of columns is set under page setup. If the parent report is set to one column the all subreports are also set to one column.

    I know of no way around this, as I attempted to do the same recently.

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

    Re: Columns in reports

    However, it is possible to have a report header than spans the full width of a multi-column report. Maybe you should think about putting your other subreports in the report's header and put your multicolumn data into the report's detail section instead of in a subreport. If you download the <A target="_blank" HREF=http://support.microsoft.com/support/kb/articles/Q231/8/51.ASP>RptSmp00.exe</A> from the Microsoft site, you'll see some examples of fairly exotic report solutions.
    Charlotte

  4. #4
    New Lounger
    Join Date
    Dec 2000
    Location
    Rockhampton, Queensland, Australia
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Columns in reports

    Thanks Charlotte, that's what I regard as clever thinking.

Posting Permissions

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