Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Equal to [blank] in CR XI Post Reply Post New Topic
Author Message
dep825
Newbie
Newbie


Joined: 14 May 2007
Location: United States
Online Status: Offline
Posts: 2
Quote dep825 Replybullet Topic: Equal to [blank] in CR XI
    Posted: 14 May 2007 at 11:44am
1) This may be a stupid question (I am a newbie)...but I am trying filter out any records that have a date in it....In an Excel Filter, I would tell Excel to show the record only if the field = [blank]..ie show the record if the field is empty. In english the statement would be IF the fieldname is blank, show the record;  If it is not blank (it has something in it), then EXCLUDE this record.
 
Many database programs use "" to mean "blank"...but CRXI doesn't like that. I can find no explanation on how to create this statment in CRXI. There certainly is no such selection in the Select Expert that I can see. Nothing on-line that I could find.
 
Do I have to create a formula? Is there another way to express this? Is there a listing of syntax that CRXI likes?
 
2) Gridlines: In an Excel report, I can format a report with "gridlines" to make long rows easier to read. I can not see how to do that in CRXI. Is there a way?
 
DEP
IP IP Logged
GuestX
Newbie
Newbie


Joined: 17 May 2007
Online Status: Offline
Posts: 12
Quote GuestX Replybullet Posted: 18 May 2007 at 8:10am
Im not sure if i know what you want but:
*isnull(  place some value here )   //no value
*not isnull( place some value here )  //not empty
*string <> ""

For second part: stretch textfield to big as you want? Or select text object/
right click/format text/common/can grow.


Edited by GuestX - 18 May 2007 at 8:33am
IP IP Logged
dep825
Newbie
Newbie


Joined: 14 May 2007
Location: United States
Online Status: Offline
Posts: 2
Quote dep825 Replybullet Posted: 18 May 2007 at 8:25am
thanks...will try
DEP
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.