hi ，all
I have a requirement to highlight some field value by variables
I create a variable named "level" ,its Expression is:
if([score]>90)
then ('high')
else
then ('low')
and i add two values for level,one is 'high' ,another is 'low'
In crossTab ,I set the conditional style property of the measure field to level variable,when the value is 'high' ,the background color of measure is green,when the value is 'low ',the background color of is red.
I validated the Expresstion and report,they both have no errors
but it doesn't work ? can anybody tell me why?
thanks in advance!
Hi,
Below attached tutorial will help you regarding conditional variables in reports.Please do it and tell if its successful.I made this tutorial for you.
Regards,
In ReportNet, there is a 'feature' wherein the validate option for variable expressions will always return "no errors", whatever you code for the expression.
Try changing your expression to be:
if ([score]>90) then ('high') else ('low')
Does this fix your problem?
Regards,
MF.
to manishtirpude:
thank you very much for your document:)
to MFGF:
I used the code you gived me ,but it doesnot work still
thank you for your enthusiastic help : )
hi,MFGF, your code can work ;) when I used your code I forgot to change the field name ,so.... haha
thank you very much!
Hi,
at my age, enthusiasm is a dim and distant memory! ;)
Glad you got it sorted in the end.
MF.