Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Formula Help Supressing Post Reply Post New Topic
Author Message
MadManJiggs
Newbie
Newbie
Avatar

Joined: 09 Jun 2008
Online Status: Offline
Posts: 10
Quote MadManJiggs Replybullet Topic: Formula Help Supressing
    Posted: 28 Jan 2009 at 8:39am
I have 2 locations where i can get the tracking number from my database


location 1 and location 2

Currently my formla is

if location1 = " "
then location2
else location1

problem i also have neither of them having a value so if neither of them have a value i want to suppress my results.

How would i go about doing that.

Thanks in advance.
CJ
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 28 Jan 2009 at 9:12am
conditionally suppress the item (right click and select Format field, select the Common tab and clcik on the formula editornext to the Suppress option) or the section (open the section expert select the section it is on like details and click on the formula button next to the Suppress no drill down option)
using the supress formula with
isnull(table.location1field) and isnull(table.location2field)
or if they are empty strings instead of null values
table.location1field="" and table.location2field=""
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.000 seconds.