Home Subreports
New Blog Posts: Merging Reports - Part 1 and Part 2

Columns & Grouping with subreports

edited November 2002 in Subreports
What I have is a multi-column report, with a group with a nested subgroup,
and a subreport that prints in the outer group's footer. The report can be
2, 4, or 6 columns depending on a setting within the report that is set
before the report's first pass. The layout is such:

Group1 Header
Group 2 Header
Detail Band
Group 2 Footer
Group 1 Footer (Contains 3 subreports, of which only 1 is enabled at a time,
depending on the number of columns the report has. Each subreport has it's
titleband.NewPage property set to true so the subreport will start on the
next page)

If I set the Detail Band's column traversal to left to right, the report
prints exactly as desired. However, if I change the column traversal to top
to bottom, it attempts to put the subreport in the next column instead of
putting the subreport on the next page as desired (even though the
subreport's tileband.newpage = true) and prints an extra page at the end of
the report.

If I remember correctly, this column traversal problem is a known issue with
RB 6.03 (which I am using, no hope of upgrading soon). Does anybody know
the work around?

thx,
Jan

Comments

  • edited November 2002
    Use the new page setting on the group instead of the title band new page
    property. You might have to create another group on the key linking field to
    get this behavior where the group breaks once for each detail dataset.


    Cheers,

    Jim Bennett
    Digital Metaphors

  • edited November 2002
    Thx, Jim. I was able to get around the extra page by making the subreport a
    section. Now I have traversal set TopToBottom and- when I change the main
    report's columns from 2 to 4 or 6, I get these results:

    2 columns: prints ok
    4 columns: one page of the main group (near middle of report) is just blank-
    it appears skipped
    6 columns: all data is printed, but subreport data is placed in the last
    column of the group despite trying to add a blank title band to the
    subreport and setting titleband.newpage to true (to force the subreport to a
    new page). The reason I tried the titleband.newpage is that the subreport
    lives in the main group's footer, and the main group already has pagebreak
    set to true. I don't want a page break for the inner group.

    I should note that if I change the traversal back to LeftToRight, the report
    works great- unfortunately this won't work for us. So, if I could fix the
    problem with the missing page in the 4 column, and getting the subreport to
    print on a new page for the 6 column, I would be set. Do you have any ideas
    what I might do?

    thx,
    Jan

  • edited November 2002
    The problem in 6.03 was with left to right traversal of subreports with
    columns in them. Can you test using RB 7? Download the trial edition to
    test to see if the problem goes away. If the problem doesn't go away, then
    please send a simple working demo project to support@digital-metaphors.com
    and we'll take a look at it in RB 7.


    Cheers,

    Jim Bennett
    Digital Metaphors

This discussion has been closed.