VFP9 multiple detail bands

[Villi Bernaroli]

A co-worker is trying to create a multiple detail band report with VFP9, one
of our first tests on VFP9, and he's facing an issue. I'm sorry I'm not
working on that because it's an interesting subject.
He needs a page where two very different structures must live together, so
he's trying to create a structure like this one:

Groupheader 1
Header 1
Detail 1
Footer 1
Groupfooter1
Groupheader 2
Header 2
Detail 2
Footer 2
Groupfooter2

But he is getting something like this:

Groupheader 1
Groupheader 2
Header 1
Detail 1
Footer 1
Header 2
Detail 2
Footer 2
Groupfooter2
Groupfooter1

It looks like he can't use a different grouping for the 2 detail bands, is
there a way to obtain that?
He also says he could otherwise use a form-feed in a special point and it
would work anyway for him, but we don't know of a way to issue a "form-feed"
in a VFP graphic (as opposed to text only) report.
Is there a way for this?

[Bernhard Sander]

Hi Villi,

Post by Villi Bernaroli
A co-worker is trying to create a multiple detail band report with VFP9, one
of our first tests on VFP9, and he's facing an issue. I'm sorry I'm not
working on that because it's an interesting subject.
He needs a page where two very different structures must live together, so
Groupheader 1
Header 1
Detail 1
Footer 1
Groupfooter1
Groupheader 2
Header 2
Detail 2
Footer 2
Groupfooter2
Groupheader 1
Groupheader 2
Header 1
Detail 1
Footer 1
Header 2
Detail 2
Footer 2
Groupfooter2
Groupfooter1

With VFP9 you can not set a group beside another, only nest one group into the
other. But maybe you could arrange the data so that the result looks like your
co-worker wants. Some ideas to this: grouping on same group expressions,
grouping on special expressions that only give one row and the like. It looks a
little strange, but with such tricks, one can achieve interesting results.

For the page break: groups may start on a new page, so add some extra grouping
only for the purpose to manage page breaks.

Regards
Bernhard Sander

[Villi Bernaroli]

Post by Bernhard Sander
With VFP9 you can not set a group beside another, only nest one group
into the other. But maybe you could arrange the data so that the
result looks like your co-worker wants. Some ideas to this: grouping
on same group expressions, grouping on special expressions that only
give one row and the like. It looks a little strange, but with such
tricks, one can achieve interesting results.

Interesting, I'll report to my co-worker

Post by Bernhard Sander
For the page break: groups may start on a new page, so add some extra
grouping only for the purpose to manage page breaks.

That's exactly what he was trying to do, but he'd have to group in a way the
report writer doesn't allow: a group beside another. He says that the "start
on new page" check of the detail bands does not accomplish things as he
would like.