Last post Jan 10, 2018 01:15 AM by Deepak Panchal
Jan 08, 2018 12:14 PM|Raghu_grdr1|LINK
I have a report done using report viewer in asp.net .
I want a display a color based on Time.
If IN time between 8.00AM to 8.30AM i want to display cell color in Green.
If IN time between 8.30AM to 8.45AM i want to display cell color in Yellow.
If IN time between 8.45AM to 10.30AM i want to display cell color in red.
Jan 08, 2018 12:35 PM|Raghu_grdr1|LINK
I have initially done in Gridview, now i am converting to Report using Report Viewer.
Jan 10, 2018 01:15 AM|Deepak Panchal|LINK
you need to write Expression like below.
=IIF(RowNumber(Nothing) MOD 2, "PaleGreen", "White")
=SWITCH(Fields!Pay.Value <= 10, "Red", Fields!Pay.Value >= 20, "Green")
for detailed steps and information you can refer links below.
Adding Conditional Formatting (Reporting Services)
SQL Reporting "How to" – Conditional Color 1/4: The Basics. Report Expressions & Custom Code
Data Driven Colored Text for Reporting Services Reports