SSRS 2008 – Dealing with division by zero scenarios

by

IIf will always evaluate both results before deciding which one to actually return.

Try

=IIf(Fields!SomeField.Value = 0, 0, Fields!SomeOtherField.Value / IIf(Fields!SomeField.Value = 0, 1, Fields!SomeField.Value))

This will use 1 as the divisor if SomeOtherField.Value = 0, which does not generate an error. The parent IIf will return the correct 0 for the overall expression.

More Related Contents:

  1. How to get rid of blank pages in PDF exported from SSRS
  2. SSRS 2008 R2 – SSRS 2012 – ReportViewer: Reports are blank in Safari and Chrome
  3. Changes to parameter not showing on Report Server after deployment
  4. Reporting Services permissions on SQL Server R2 SSRS
  5. divide by zero/null workaround in SSRS 2008 report
  6. SSRS 2008 R2 – SSRS 2012 – ReportViewer: Reports in Safari/Chrome but works fine in Firefox/Internet Explorer 8… why?
  7. Need help in calculation using two Datasets using Expression SSRS
  8. How do I format date and time on ssrs report?
  9. Optional multi-valued parameters in SSRS
  10. SSRS Conditional Formatting Switch or IIF
  11. Passing Credentials to Sql Report Server 2008
  12. Pivot a table in reporting services?
  13. Programmatically Export SSRS report from sharepoint using ReportService2010.asmx
  14. Access Page number in report body In SSRS

Leave a Comment