Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Blank or Null Values Post Reply Post New Topic
Author Message
ashline
Newbie
Newbie


Joined: 22 May 2010
Online Status: Offline
Posts: 15
Quote ashline Replybullet Topic: Blank or Null Values
    Posted: 22 May 2010 at 11:42am
Ive been running google searches all morning and havnt been able to find a solution to my problem.
 
I have two linked tables, one of which has a column called type.  In the table that has the type there is two possible values WO or SR.  So when both tables are put together and imported into Excell the type column has either WO, SR or its blank.  Now I am not sure if in Ecxel an empty field is NULL or blank but I would like to figure out a way to have the report show IN.
 
In all the searches I have found some formulas but I am not sure if I have been placing them in the correct spot.  At first I thought that Display String under the format editor on the Common tab was what I needed but I didnt get it to do what I wanted.  I was able to get it to rename the WO and SR values but I cant seem to modify the blank or Null value.
 
Any help would be great!
IP IP Logged
Emir_W
Senior Member
Senior Member
Avatar

Joined: 25 Apr 2010
Online Status: Offline
Posts: 228
Quote Emir_W Replybullet Posted: 22 May 2010 at 7:56pm
you can use a Stored Procedure (SP) for the link and result then let CR use this SP and do the format in the report.
 
in your SP you can use xx=isnull(xvar,'IN') or you can use other statement (like when..case..end).
 
 
hope it help.
Emir W
IP IP Logged
ashline
Newbie
Newbie


Joined: 22 May 2010
Online Status: Offline
Posts: 15
Quote ashline Replybullet Posted: 31 May 2010 at 1:51pm

Are you talking about creating something on the database?  If so I don’t have the kind of access I only have ready only.

 

The problem is I have a field that is either blank or has a value of "request".  Now I can use the select expert and have it show me all records that are equal to request but I need it to show me all records that are not equal to request or have the blank value.

 

Of course I have tried using the does not equal but it returns no records at all.
IP IP Logged
ashline
Newbie
Newbie


Joined: 22 May 2010
Online Status: Offline
Posts: 15
Quote ashline Replybullet Posted: 31 May 2010 at 4:42pm
I got it!!!!!!!
 
I used this formula in the select expert
 
IsNull({Incident.Incident Type}) or {Incident.Incident Type} <> "Request"
 
You have to do the IsNull first.
 
The Credit for the infro is
 
 
IP IP Logged
Emir_W
Senior Member
Senior Member
Avatar

Joined: 25 Apr 2010
Online Status: Offline
Posts: 228
Quote Emir_W Replybullet Posted: 31 May 2010 at 10:57pm

very good.

at least 'isNull' command is the light to solve it.
 
Thanks for sharing.
 
 
;)
 
Emir W
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.031 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.