Report Viewer Expressions

Question

0.00/5 (No votes)

See more:

I'm trying to modify an expression in the RDLC file for a column value. I can't seem to find many examples of how to use 2 expressions together, or I'm not understanding the expression syntax

So I have a column called FPROFIT and I'm using the expression dialog editor.
Line 1 says to state the value from my dataset in which I understand.
But I want to change the color of the text to red if the value is negative.

=Fields!FPROFIT.Value

So this is the example give for it

=IIf(Fields!FPROFIT.Value <=100, "Red", "Black")

Am I suppose to use to lines, line 1 and line 2, or combine them together?

Posted 7-Jul-14 8:50am

jkirkerx

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard Deeming · Accepted Answer · 2014-07-07T10:02:00

I assume you're looking at the documentation on TechNet?
http://technet.microsoft.com/en-us/library/ms156400%28v=sql.100%29.aspx[^]

Your first expression needs to be set as the text of the TextBox. The second expression needs to be set against the Color property of the TextBox.

You need to:

click on the report item you want to modify;
open the properties pane (if it isn't visible);
select the "Color" property in the properties window;
in the drop-down, select the Expression... option;
enter your IIF(...) expression in the "Edit Expression" box;