• Interests: My family, Photography, Lego, Origami and paper Planes and of course database technology

Technical Article

Handle Divide by Zero in SQL Reporting Services

Out of the box, Reporting services does not handle divide by zero conditions gracefully. There are plenty of posting on how to use the IIF() function to accomplish this, with some rather horrific looking code. In order to simplify the coding process and make the resulting expressions readable by a mere mortal, I wrote the […]

4.5 (14)

You rated this post out of 5. Change rating

2006-07-28 (first published: )

3,944 reads

Blogs

ERD Your Existing Databases

By

There are several tools out there to make your life easier by creating an...

AI World

By

this month is the big month and a month to remember their are so...

Using Flyway with Feature Flags

By

There is a nice article at Harness.io on their use of feature flags and...

Read the latest Blogs

Forums

The Costs and Rewards of Speaking

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Costs and Rewards of...

Manage Elastic jobs in Azure using Azure Elastic Jobs Manager

By Kunal Rathi

Comments posted to this topic are about the item Manage Elastic jobs in Azure...

Takeaways from Data Grillen 2024

By Tonie Huizer

Comments posted to this topic are about the item Takeaways from Data Grillen 2024

Visit the forum

Question of the Day

Inserting Transaction Marks

When is a transaction mark first inserted into the msdb.dbo.logmarkhistory table?

See possible answers