Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Formula Assistance Needed Post Reply Post New Topic
Author Message
dchapman2224
Newbie
Newbie
Avatar

Joined: 02 Jan 2012
Location: United States
Online Status: Offline
Posts: 1
Quote dchapman2224 Replybullet Topic: Formula Assistance Needed
    Posted: 02 Jan 2012 at 7:48am
I am attempting to create a report that contains a dollar amount for specific range of accounts. Each line of the report needs to be a different range which prevents me from simply using the selection expert. Can someone point me in the right direction for creating a field to display field X if field Y is in the range of A to Z?
IP IP Logged
sgtjim
Newbie
Newbie
Avatar

Joined: 23 Aug 2011
Online Status: Offline
Posts: 32
Quote sgtjim Replybullet Posted: 03 Jan 2012 at 4:59am
Try something like this...

If {Table.Field1} > "Lower Bound" and {Table.Field1} < "Higher Bound"
Then
{Table.Field2} Else "Not In Range"
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.