我可以通过访问TextBox属性在设计时更改文本颜色，但是我想在运行时根据某些条件（与单元格值相关）更改文本颜色。 例如，如果单元格值大于0，则文本颜色为绿色，否则应为红色。
我可以在本地报告中实现这样的目标吗？
I can change the Text color at design time by accessing to TextBox properties, however I would like to change the Text color at run time depending on some condition (relating to the cell value). For example, if the cell value is greater than 0, the text color is green, otherwise it should be red.
Could I achieve such a thing in Local Report?
最满意答案
目前，我知道只有一种方法来引用指定单元格的值是使用单元格所具有的精确表达式，并且我有以下解决方案：
这很简单，只需右键单击文本框，选择TextBox properties ，然后选择Font选项卡，就可以看到有一个Color选择器，你可以在设计时选择你想要的颜色，如果没有，你可以指定它的表达式通过单击颜色组合框右侧的fx按钮来显示颜色。 然后键入以下表达式，我想你想要在值大于0时将其设为绿色，否则其值为红色：
=IIF([The exact current TextBox's expression] > 0, "Green", "Red")默认情况下，颜色表达式仅为Black （没有等号），但要使用更复杂的表达式，您必须先添加等号，否则会出现错误，指出指定的颜色不是有效颜色，加上颜色由表示颜色名称的字符串指定。 要在表达式中指定更多种颜色，可以使用十六进制字符串格式（如在Web中使用），例如#ff0000可以与Red一样工作。
希望能帮助到你！
Currently, I know only a way to refer to a specified cell's value is using the exact expression which the cell has, and with that I have the following solution for you:
It's so simple, just right click your textbox, select TextBox properties, then select Font tab, you can see there is a Color selector, you can select a color you want right at design time, if not, you can specify the expression for its color by clicking on the fx button on the right side of the color combobox. Then type the following expression, I suppose you want to make it Green when its value is greater 0, otherwise its value is Red:
=IIF([The exact current TextBox's expression] > 0, "Green", "Red")By default, the color expression is only Black (without the equal sign), but to use more complex expression, you have to add the equal sign first, otherwise there will be an error saying that the specified color is not a valid color, plus the color is specified by a string representing color name. To specify more various color in an expression, you can use the hex string format for color (as used in web), e.g #ff0000 can work the same as Red.
Hope it helps!
更多推荐
发布评论