Crystal 10 Question - May seem very basic, but I can't figure it out 1

[sclark415]

Crystal 10, Enterprise 10 - SQL Server

I have to start each change of group data on a new piece of paper. My groups change via formula:

if right({xxx.new_policy_number},2)="00" then "00 Policies"
else
if right({xxx.new_policy_number},2)= "01" then "01 Policies"
else
if right({xxx.new_policy_number},2)= "02" then "02 Policies"

I can't seem to figure this out. Can you help me please?
I am thanking you in advance for your assistance!

 

[kskid]

Assuming you have it grouped by your formula, simply right click on the Group footer located on the left side of the Report designer and click on new page after.

Cheers,

-Larry

 

[sclark415]

wichitakid - Thank you very much - I appreciate your help.