Hi all, I have been browsing the web for a little while trying to find a resolution to my problem and was hoping someone could point me in the right direction. I have put together a report pulling information form several tables to show how specific fields are performing At the moment i have the report complete and pulling information nicely, but now i need to colour a few field depending on the results they give, i have: = IIF(Fields!<fieldname>.Value=2.8, "Green”, IIF(Fields!< fieldname>.Value= -1.2, "Red", IIF(Fields!< fieldname>.Value -0.1, "Yellow", ""))) this work perfect for the exact values, but i need to have the "2.8" "0.1" "1.2" converted into results pulled from information in the database but not in the report. I have been told that i would need to use parameters but i do not know what i would need to do as the information would need to be like ((field1max*field2max)-(field1min*field2max))/(field3) field 3 needing to be filtered to specify which field 3 portion so set 1 set 2 set 3 for each colours anyone got information on how i could put these equasions into the expression to get results for each colour?

Add another data set to your report load the limits in this database and then use the fields of this dataset in the comparison-------------------------------------------------------- Surender Singh Bhadauria