Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Odd/Even

Status
Not open for further replies.

bld21

Technical User
Mar 1, 2010
49
US
I am using crystal reports 2008. I have a report that includes a 9 digit account number field. What I would like to do is to create 2 separate groups, one containing the odd numbered accounts and one containing the even numbered accounts.

Is there any possible way to do this?

Thanks,
Bruce D.
 
Try:
create a formula @Even/odd using
if remainder
({table.Accountnumber},2) = 0 then "Even"
else "odd"

afterwards drag and drop your account no under this group
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top