Solved

How to Identify the Value of a Database Field in Crystal Reports that is an Integer as Even or Odd Number?

Posted on 2011-09-04
2
419 Views
Last Modified: 2012-05-12
Hello Experts,

Is there a function or formula in Crystal Reports that can identify the value of a database field that is an integer, as an even or an odd number ?
My goal is to put all records with an odd 'case number' on the left side of my report and all the records with an even 'case number' on the right.  I am using two subreports to display the case number data in a group section.

Thank you.
~Chopp
0
Comment
Question by:Chopp
2 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 36482055
Try this

OddNumber

{CaseNumberField} Mod 2 = 1

EvenNumber

{CaseNumberField} Mod 2 = 0

MOD gives the remainder when divided by in this case 2

mlmcc

0
 

Author Closing Comment

by:Chopp
ID: 36482105
Thank you very much!  That works perfectly for my report.
Have a great evening.
~Chopp
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now