Columns & Grouping with subreports

rbuser

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

digitalmetaphors

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

rbuser

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

digitalmetaphors

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