| Author |
Message |
AndyLeates
Newbie
Joined: 05 Oct 2011
Location: United Kingdom
Online Status: Offline
Posts: 23
|
   Posted: 13 Oct 2011 at 11:34am |
I have double checked everything! Changed test formula as you described, and as you say, all blank rows now report TRUE, everything else FALSE
|
 IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 13 Oct 2011 at 11:39am |
try and change your color formula
if currentfieldvalue="" then color(255,0,0) else color(0,255,64)
what do you get?
|
|
IP Logged |
|
AndyLeates
Newbie
Joined: 05 Oct 2011
Location: United Kingdom
Online Status: Offline
Posts: 23
|
Posted: 13 Oct 2011 at 11:43am |
|
Fields with a number are green, without remain blank / white
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 13 Oct 2011 at 11:47am |
wow. I am stumped. It is acting as if the field is NULL...????
Try adding a bottom border single line to the field?
Does it appear for all records or only the ones that <> ""?
also try an inverted color attempt:
if NOT(currentfieldvalue="") then CrNocolor else CrRed
|
|
IP Logged |
|
AndyLeates
Newbie
Joined: 05 Oct 2011
Location: United Kingdom
Online Status: Offline
Posts: 23
|
Posted: 13 Oct 2011 at 11:59am |
Bottom border NOT present when the field is blank Inverted formula shows all rows with no colour. You've been more than helpful. Go do some real work! Andy
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 13 Oct 2011 at 12:04pm |
Waiting for my ride  ...
try this
change your @PhoneReplacement formula to :
If isnull({UserDetail.DirectLine}) or trim({UserDetail.DirectLine})="" then "No Phone" else {UserDetail.DirectLine}
In your color formula
if currentfieldvalue="No Phone" then crRed else crNocolor
|
|
IP Logged |
|
AndyLeates
Newbie
Joined: 05 Oct 2011
Location: United Kingdom
Online Status: Offline
Posts: 23
|
Posted: 13 Oct 2011 at 12:09pm |
Now that's what I call a workaround! I like your style.... Works perfectly, good enough for me. Thanks for that, hope your ride turns up soon. Andy
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 13 Oct 2011 at 12:15pm |
I still don't know why it was doing that...
if you want to get rid of the work around text make the text color conditional too
if currentfieldvalue="No Phone" then crRed else crBlack
This way the red 'No phone' ink color should disppear in the red background and mimic what you wanted in the first place and actual phone numbers will be black (assuming that is the color you want).
|
|
IP Logged |
|
AndyLeates
Newbie
Joined: 05 Oct 2011
Location: United Kingdom
Online Status: Offline
Posts: 23
|
Posted: 13 Oct 2011 at 12:17pm |
Hah, I just did that! Not so dumb after all... ;-) Thanks again, nearly midnight here, so time to hit the hay.
|
|
IP Logged |
|
|
|
