Avatar of vcharles
vcharles
 asked on

Help with changing text color in MS Report (rdlc)

Hi,

How do you set the text color of a text in a textbox in my report when it equals to a particular value of a textbox on my form? I am using VS2010 SP2. Also if the textbox on my form contains BEL, CAN, USA, how do I change the text color of BEL, CAN or USA in my report?  

Victor
.NET ProgrammingSSRSMicrosoft DevelopmentWeb Languages and Standards

Avatar of undefined
Last Comment
Howard Cantrell

8/22/2022 - Mon
lludden

You can put an equation in the color property that will evaluate to the correct color for the condition for that cell or row.
ASKER CERTIFIED SOLUTION
Nico Bontenbal

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
vcharles

ASKER
Hi,

Thanks for your replies.

In the textbox property of my report, if I have an NSN field

How do I modify

Fields!NSN.value = Textbox1.Text


Where Textbox1.text is the value from the form. I imagine I need a parameter to be able to read the value of the text box right?

How do I modify the code for the textbox property of my report to  understand the value of textbox.text on the windows form?

Victor
Surone1

looking at the line of code:
Fields!NSN.value = Textbox1.Text
i suspect you are working in MS Access, is this correct?
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Nico Bontenbal

The original question was about text color. I think the additional question in post ID:38443709 has nothing to do with that. To avoid confusion it might be better to close this question and post a new question about linking page fields to report parameters.
Surone1

yes it does seem to be a new question.
vcharles

ASKER
I am working with XML, will post as a new question.
Thanks.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Howard Cantrell

You have to pass in a parameter form your query to the report.
the report name will be something like...
Parameters!MyName.Value