Print Page | Close Window

between function

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=13134
Printed Date: 25 Apr 2024 at 11:50pm


Topic: between function
Posted By: directred
Subject: between function
Date Posted: 05 May 2011 at 10:20am
Hi,
 
I wonder if anyone could tell me the syntax for between numbers.
 
An example would be;
 
1 F
2 F
3 F
4 G
5 G
6 G
7 H
8 H
9 H
10 H
 
If number 2 is selected then F is displayed. If no 6 is selected then G is displayed.
 
Is there a between function or would I be better using a CASE statement?
 
 
 


Replies:
Posted By: DBlank
Date Posted: 05 May 2011 at 10:32am
if field in 1 to 3 then 'F' else
if field in 4 to 6 then 'G' else
if field in ...


Print Page | Close Window