Hi,
- SQL Server 2005
- SSRS
I need to capture and deal with error handling in my report. It seems that some of the formula you would use in Excel - it not recognised in SSRS - i.e. IF(ISERROR(formula,"",formula)) ----->
=IIF(ISERROR((XXX.Value/YYY.Value),"",(XXX.Value/YYY.Value))
The report has these 3 errors which I dont know how to hande.
- #Error
- Infinity
- NaN
Thanks
David
- SQL Server 2005
- SSRS
I need to capture and deal with error handling in my report. It seems that some of the formula you would use in Excel - it not recognised in SSRS - i.e. IF(ISERROR(formula,"",formula)) ----->
=IIF(ISERROR((XXX.Value/YYY.Value),"",(XXX.Value/YYY.Value))
The report has these 3 errors which I dont know how to hande.
- #Error
- Infinity
- NaN
Thanks
David