running total of null value in a string field

[mirror152]

I'm working in CR 11, SQL server database.

I'm trying to find out if employees are entering a required field in client's service record. Its a free text field so when they don't enter anything the field is empty.

I've tried to add a formula to the running total in a couple of ways.

isnull({command.client_strenghts})

and

command.client_strenghts = ""

In either case, the running total returns a value of zero.

 

[rob11nj]

You could try creating a formula field like so:

if isnull({table.field}) then 1 else 0

If you throw that new formula field in your details section you should be able to get the total count of rows where that entry is null by summing this field in your running total.

 

[Madawc]

Create a formula field to work out just what is there, put it in a test detail line below the regular one. E.g.

if isnull({command.client_strenghts})
then "Null found"
else if {command.client_strenghts} = ""
then "Space found"
else
"Found (" & {command.client_strenghts} & ")"

If you tried the two tests and both got zero, then you must have some non-printing character.


Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10