Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Need formula help Post Reply Post New Topic
Author Message
mavrik
Newbie
Newbie


Joined: 16 Aug 2008
Location: Canada
Online Status: Offline
Posts: 9
Quote mavrik Replybullet Topic: Need formula help
    Posted: 17 Sep 2008 at 12:44pm

Item key

Description

Desc 1

R-1

Rave

Rome

 

Reney

Rottle

 

In the example above, I need a formula when item key is blank to insert desc1, and if item key is not blank insert description

Thanks for the help

IP IP Logged
roxanne_2929
Newbie
Newbie
Avatar

Joined: 17 Sep 2008
Location: United States
Online Status: Offline
Posts: 9
Quote roxanne_2929 Replybullet Posted: 17 Sep 2008 at 2:38pm
One way you could do it is by placing the description field and the desc 1 field on top of each other and using the following formulas to suppress each one:
 
In the suppress formula for description, use-
isnull((table.item_key))
 
for the desc1 field suppress formula would be-
not isnull((table.item_key))
 
Make sure you have the suppress box checked and when the formula is entered, the equation icon will turn red.
 
I have used this technique in my reports. The idea being if the item key had data (not isnull) the desc1 will supress. If the item key does not have data (isnull), then the description will suppress. This way, one or the other will be visible, depending on the condition of the item_key.
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.047 seconds.