Question Conditional Formating problem. Should be simple but I can't figure it out.

[Ken B]

Here is the scenario, I have a field on my report that has a value in a Label tag. The Number in the Label is "12".

Now I want my condition in a different field to be simply: If the value in this field is Less than the number in Label33(12) to turn the field yellow.

Sounds simple right... Not so... I can't get the condition to work.

I have tried "expression is" "< [label33]" and I can't get it to work. I have tried several variations on the theme as well.

I am thinking that these conditions can't read Label arguments. If this is the case I have a workaround in mind but this would be the simplest solution for my issue if I can get it to work.

Any ideas from you guys would be appreciated

Any help would be appreciated.

 

[PaulO]

Here is the scenario, I have a field on my report that has a value in a Label tag. The Number in the Label is "12".

Now I want my condition in a different field to be simply: If the value in this field is Less than the number in Label33(12) to turn the field yellow.

Sounds simple right... Not so... I can't get the condition to work.

I have tried "expression is" "< [label33]" and I can't get it to work. I have tried several variations on the theme as well.

I am thinking that these conditions can't read Label arguments. If this is the case I have a workaround in mind but this would be the simplest solution for my issue if I can get it to work.

Any ideas from you guys would be appreciated

Any help would be appreciated.

I'm thinking the most likely issue is that you can't use a label tag in an expression ... is there any way you can replace the label with a text box?

 

[gemma-the-husky]

the expression needs to be this sort of thing ...

[thisfield] < [otherfield]

even if you are dealing with condiitonal formatting for [thisfield]