General information
Category:
Reports & Report designer
David,
Try temporarily changing the report expression to
IIF(qtyorder > 996,"G","LE") + " " + ALLTRIM(STR(qtyorder))
just to make sure that the report is looking at the value you think it is.
Jonathan
>Tonight is my night for total frustration with the Report Designer (I see why Crystal Reports has been recommended to me).
>
>I have a numeric field called qtyorder. If I use the simple value qtyorder as the expression for a control, its value prints correctly. However, on the same line of the detail band if I have a control whose expression is IIF(qtyorder > 996,"G","LE") it ALWAYS!!! prints LE !!! even if the value is greater than 996!!!!
>
>What is going on!!
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only