Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: problem with blank field Post Reply Post New Topic
Author Message
mein
Newbie
Newbie
Avatar

Joined: 25 Aug 2009
Location: Germany
Online Status: Offline
Posts: 5
Quote mein Replybullet Topic: problem with blank field
     Posted: 01 Oct 2009 at 8:12pm

i want to display field in my report and return as 0. my report look like this:

item   qty(i)     qty(ii)
A          1             2
B          0             2
C          3         (blank)  
D          4             3
E          0         (blank)
 
i want the blank field is return with 0 and i dont want to display the data if field qty(i) is 0 and qty(ii) is blank
 
 


Edited by mein - 01 Oct 2009 at 8:12pm
IP IP Logged
Jyothi Yepuri
Senior Member
Senior Member


Joined: 11 May 2009
Location: Australia
Online Status: Offline
Posts: 127
Quote Jyothi Yepuri Replybullet Posted: 01 Oct 2009 at 8:30pm
create a formula and use that to display qty ii value

if isnull(qtyii) or qtyii = "" then
0
else
qtyii

HTH,
Jyothi
IP IP Logged
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