Expressions
Posted: Thu Nov 15, 2012 11:53 am
Hi,
I want to highlight empty text.
I do next, in text.condition i use expression IIF(Drv=="",true,false), where Drv is variable. Below i choose back color and border All.
In xml it's look like
<Text64 Ref="76" type="Text" isKey="true">
<Border>All;Black;1;Solid;False;4;Black</Border>
<Brush>[255:255:255]</Brush>
<ClientRectangle>164,92,34,4</ClientRectangle>
<Conditions isList="true" count="1">
<value>_x007B_IIF_x0028_Drv_x003D__x003D__x0022__x0022__x002C_true_x002C_false_x0029__x007D_,Black,[230:230:230],Arial_x002C_8,True,False,,_x005B_None_x005D_,All,BackColor_x002C__x0020_Borders</value>
</Conditions>
<Editable>True</Editable>
<Font>Calibri,9</Font>
<Margins>0,0,0,0</Margins>
<Name>Text64</Name>
<Page isRef="2"/>
<Parent isRef="2"/>
<Text>{Drv}</Text>
<TextBrush>Black</TextBrush>
</Text64>
But result is not as i expect. Can you help with
_x007B_IIF_x0028_Drv_x003D__x003D__x0022__x0022__x002C_true_x002C_false_x0029__x007D_,Black,[230:230:230],Arial_x002C_8,True,False,,_x005B_None_x005D_,All, BackColor_x002C__x0020_Borders
I want to highlight empty text.
I do next, in text.condition i use expression IIF(Drv=="",true,false), where Drv is variable. Below i choose back color and border All.
In xml it's look like
<Text64 Ref="76" type="Text" isKey="true">
<Border>All;Black;1;Solid;False;4;Black</Border>
<Brush>[255:255:255]</Brush>
<ClientRectangle>164,92,34,4</ClientRectangle>
<Conditions isList="true" count="1">
<value>_x007B_IIF_x0028_Drv_x003D__x003D__x0022__x0022__x002C_true_x002C_false_x0029__x007D_,Black,[230:230:230],Arial_x002C_8,True,False,,_x005B_None_x005D_,All,BackColor_x002C__x0020_Borders</value>
</Conditions>
<Editable>True</Editable>
<Font>Calibri,9</Font>
<Margins>0,0,0,0</Margins>
<Name>Text64</Name>
<Page isRef="2"/>
<Parent isRef="2"/>
<Text>{Drv}</Text>
<TextBrush>Black</TextBrush>
</Text64>
But result is not as i expect. Can you help with
_x007B_IIF_x0028_Drv_x003D__x003D__x0022__x0022__x002C_true_x002C_false_x0029__x007D_,Black,[230:230:230],Arial_x002C_8,True,False,,_x005B_None_x005D_,All, BackColor_x002C__x0020_Borders