March 9, 2007 at 10:42 am
I'm looking to apply conditional font color formatting via vb code you call in a RS report, so I don't have to set the color property for each cell indivually. For example, I have one report with a LOT of columns and rows of formulas. I want to show negative numbers in red. Plus, in some cases a formula will return N/A in which case I want to show it in gray instead of black. I would think there is a simple vb code looping structure that would do this. I don't do a lot of vb coding, just basic.
Anyone have a good example. Is there a good site that focuses on good practical examples of vb code you incorporate into RS reports?
Thanks
smv929
March 12, 2007 at 8:00 am
This was removed by the editor as SPAM
March 14, 2007 at 6:14 pm
Basically put, in the Color property box of the control you want to control put ...
=IIF(IIF(Fields!yourFieldName.Value="N/A","Gray",IIF(Fields!yourFieldName.Value<0,"Red","Black"))
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMarch 19, 2007 at 5:35 pm
Look at this thread: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=150&messageid=351344
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply