new string field in CSV table problem
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=22464
Printed Date: 04 May 2024 at 11:34am
Topic: new string field in CSV table problem
Posted By: Macavity
Subject: new string field in CSV table problem
Date Posted: 27 Sep 2017 at 8:15am
Hi,
Crystal reports 9 :
A new field has been added to a CSV table.
When testing on this field :
is not equal to "X"
is not like "*X*"
or suppress if field = "X"
returns a blank report.
This field is blank in all records, so it should show the complete table.
What does work is isnull(field).
What is wrong with this field, it shows type string
|
Replies:
Posted By: DBlank
Date Posted: 27 Sep 2017 at 9:31am
I think if you alter any of your other formula options to 'use default values for nulls' they would work as you expect.
If the report is not set up on how to handle a null it will not evaluate the formula and skip or omit that row if it is part of the select criteria.
|
Posted By: kevlray
Date Posted: 27 Sep 2017 at 10:20am
|
Also with string fields, checking for Len(field) = 0 instead of Nulls works pretty good.
|
Posted By: Macavity
Date Posted: 28 Sep 2017 at 4:03am
That didn't help, but I figured it out, it's a memo field.
I created a formula left(field,1) that changed it to a string that can be used in selections
|
|