Print Page | Close Window

Equal to [blank] in CR XI

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=660
Printed Date: 28 Apr 2024 at 2:32pm


Topic: Equal to [blank] in CR XI
Posted By: dep825
Subject: Equal to [blank] in CR XI
Date 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


Replies:
Posted By: GuestX
Date 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.

Posted By: dep825
Date Posted: 18 May 2007 at 8:25am
thanks...will try

-------------
DEP


Print Page | Close Window