CR10 - Invisible values - can't figure out what they are

[shera4111]

I've got a super-simple report that displays work tickets and department names. Problem is, half the department names are invisible.

No, they aren't null.
No, they aren't blank strings.
No, they aren't a bunch of spaces strung together.

They're INVISIBLE.
(And no, I'm not crazy)

As a last-ditch resort to figure out what they were, I tried the old programmer's standby - I created this formula:
"X" + {MyTable.Department} + "X"
and stuck it on the report.

They're still INVISIBLE!!! I don't even get "XX" which I would have thought I'd get at a minimum.

Anyone seen this? Better yet, anyone fixed this? Is there some 'suppress values when blank' option?

shera4111

 

[synapsevampire]

Yes, you're crazy

OK, so ghosts aside, what you want to learn is what's in the field.

Here's a few things to try:

len(trim({MyTable.Department}))

If zero, try:

trim({MyTable.Department}) = ""

If true, then they are indeed blanks, adjust your formula to:

"X" & trim({MyTable.Department}) & "X"

You should also post the data type within the database, it could be something that isn't supported and we'll have to cheat it.

If one or more, try:

asc(left(trim({MyTable.Department}),1))

This will tell you the ASCII equivalent of what's in the field.

When asking about data, post your database/connectivity as well.

-k

 

[chelseatech]

Also check it's not wrapping. Format the field as "Can Grow"

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm