miles_lesperance (4/11/2014)
That worked!! That expression was written by a previous developer, and I was trying to modify it to get rid of the divide by zero error that would occur. I am rather new at report expressions, and was trying to get a better feel for how they work. They are quite different than SSIS expressions, which I understand to a greater degree.
Yes SSRS expressions are a bit strange sometimes and the real problem is it's IIF processing does not 'short circuit' hence the convoluted solution.
Where can I find that aspect
Not sure what you mean by this. You could checking all your reports for divisions to see if they need changing.
If you mean the string conversion then I would start with the dataset query/procedure to see what it does and see if it could be changed.
Sometimes this is not possible so you may have to live with using CDec.
Far away is close at hand in the images of elsewhere.
Anon.