Grouping Report

[HalaszJ]

I have a report that I need to group by a field called mgroup, in that group I have 2 other groups, bank and vault. The report will basically look like this.

mgroup:
This groupd has several fields which basically serves as an email type header, to, from, date...

bank:
This group only server to show the next group

vault:
this group has the details section

What I am trying to do, and have failed miserably for days is this.

I want the report to create a new page everytime mgroup changes, the best i got was the complete report printed several times on the same page. the result should look like this

page header:
mgroup header:
bank header:
vault header:
details section:
vault footer:
bank footer:
mgroup footer:
page footer:

this report must break and force a new page whenever mgroup changes. Any ideas??

Also mgroup is only a fields coming back from the database that has a number in it. I thought this would make it easier to do the grouping, but its still not working.

thanks

 

[vidru]

Right click on your mgroup footer (in the gray area, where it says 'Group Footer1'), click on Format section, click the formula button (x+2) next to 'New Page After', and enter this formula:

[tt]not onlastrecord[/tt]


-dave

 

[HalaszJ]

virdu:

Thanks, i feel so stupid, I had that in one of my sections at one time, just not the right section. My page works like a champ now, thanks again.

J.