SSRS Expression Divide by Zero Error

by

You can add a function to your report code that handles the divide by zero condition, this makes it a bit easier to implement in multiple cells, e.g.

Public Function Divider (ByVal Dividend As Double, ByVal Divisor As Double)
If IsNothing(Divisor) Or Divisor = 0
  Return 0
Else
  Return Dividend/Divisor
End If
End Function

You can then call this in a cell like so:

=Code.Divider(Fields!FieldA.Value, Fields!FieldB.Value)

More Related Contents:

  1. SSRS multi-value parameter using a stored procedure
  2. Compare SQL Server Reporting Services to Crystal Reports [closed]
  3. SSRS 2008 R2 – SSRS 2012 – ReportViewer: Reports are blank in Safari and Chrome
  4. Does the iif function compute both paths in SSRS or is it short-circuited?
  5. Reporting Services export to Excel with Multiple Worksheets
  6. When to use RDLC over RDL reports?
  7. SSRS 2005 Set SimplePageHeaders on the report instead of the server?
  8. Tablix: Repeat header rows on each page not working – Report Builder 3.0
  9. SSRS 2008 R2 – SSRS 2012 – ReportViewer: Reports in Safari/Chrome but works fine in Firefox/Internet Explorer 8… why?
  10. Need help in calculation using two Datasets using Expression SSRS
  11. SSRS – How to build a simple multi-column report?
  12. SSRS – How to continue data to next column?
  13. SSRS distinct lookupset function
  14. SSRS Conditional Formatting Switch or IIF
  15. How to combine aggregates within a group with aggregates across groups within SSRS
  16. Pivot a table in reporting services?
  17. Access Page number in report body In SSRS
  18. The permissions granted to user ‘ are insufficient for performing this operation. (rsAccessDenied)”}
  19. Passing multiple values for a single parameter in Reporting Services
  20. How to get rid of blank pages in PDF exported from SSRS
  21. Passing parameter via url to sql server reporting service
  22. SSRS 2014 report deploy issue
  23. Fast query runs slow in SSRS
  24. Why does the 2nd T-SQL query run much faster than the first when called by Reporting Services 2005 in a web-app
  25. Could not load file or assembly ‘Microsoft.ReportViewer.Common, Version=11.0.0.0
  26. SSRS report definition is newer than Server
  27. Passing a parameter via URL to SQL Server Reporting Services
  28. how to remove time from datetime
  29. How to get total of top 10 sales in SSRS 2012
  30. Programmatically Export SSRS report from sharepoint using ReportService2010.asmx

Leave a Comment