Based on some logic how to highlight each column with different colors
-
Hi,
I have 2 columns in my report. And based on the formula, (colA*colB)/colA , the values in the column B has to be highlighted with Green, Red, Yellow etc. Like if the value derived from the formula is < 25, then highlight col A with color 'Green'
If the derived value is between 25 and 50 , then 'Yellow.
Else 'Red'
Please let me know how to achieve this in SSRS.
Alicia Rose
-
You can use nested IIF's or a Switch in the expression for background color on the control. Switch would work like this:
=Switch((colA*colB)/colA =25, "Yellow")Of course I believe that your formula will always return the value of colB so you could just base the background on the value in colB.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question -
My client wanted alternating column colors in a Matrix Report. I used the following on the Column Headings and cells: =switch(Fields!FundingActivity.Value="Integrated", "Salmon",Fields!FundingActivity.Value="Total", "SkyBlue",Fields!FundingActivity.Value="Funded Only", "SkyBlue")
The Values: Integrated, Total and Funded Only are the 3 values found in the Fields!FundingActivity.Value columns on the across axis.
It worked, she was happy, life is good.
-
Hi.
In my opinion, you can have a try of RAQ Report. As I know, it can set different colors for different rows or columns easily. The only thing users need to do is setting in related dialog box.
An example of rows is shown below:
Regards,
becklery.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply