Hello need help with new pg after

[MrHelpMe]

Hello,

Could someone please tell me how to create a conditional formula that creates new page after a certain group has changed. I have tried to use the formula {MyTable.MyState} <> previous({MyTable.MyState}) as per synapsevampire but this does not work. The previous state does not work on a group. ANy other suggestions. Thanks.

 

[lbass]

Go to format->section->group footer and check &quot;New Page After.&quot; So that you don't have a blank last page, in the x+2 section add: Not OnLastRecord

You referred to a &quot;conditional formula&quot; for a new page, but didn't mention any conditions. If you only want the page break after certain instances of the group, in the same x+2 area enter the conditions, e.g.:

Not (Onlastrecord) and
{group.field} in [abc,def]

This would create a page break after group abc and group def but not after other groups and not after the last group.

-LB

 

[MrHelpMe]

Thanks for your response LBass,

Actually what I need is this. I have grouped my report on product, then account number, then something else. SO basically what I need to do is where the product group changes, I want the report to put a new page for ever different product group name. ie
Computers
Sam
Account 214253
Joe
Account 678365

Golf Bags
Lisa
Account 546372

When the report in this case hits Golf bags it should be displayed on another page. Hope this is clear. Thanks again for the quick response.

 

[lbass]

Go to format->section->Group Footer #1 : Product Group-A and check &quot;New Page After&quot; and then click on the x+2 button and add the formula: Not OnLastRecord

Just make sure you have the right section selected (Group Footer #1) when you click on the &quot;new page after.&quot;

-LB