This is a question that I think is more a problem with SSRS than anything else. I have created a select statement that contains a lot of calculated values that are then grouped for a report and I would like to check for nulls and zeros in the denominator and return a 0 if that is found. I DO NOT want to put it in the Report itself but want to do it in the SQL Select statement. Does anyone know if this is possible and how to do it? Using IF THEN, CASE or other expressions does not seem to work!