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?
IP Logged