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)

2006-07-28 (first published: )

3,679 reads

Blogs

Pluralsight Free April

By

It’s a few days into April, but not too late I hope to mention...

Daily Coping 7 Apr 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...

Reading a SharePoint List with Azure Logic App

By

Sometimes in life you have to do things you really don’t like to do....

Read the latest Blogs

Forums

Understanding and Improving Query Plans

By girac127

Hi everyone. I have a process that is taking a long time to execute...

Daily Coping Tip 7 Apr 2020

By Steve Jones - SSC Editor

Daily Coping Tip: Rediscover your favourite music that really lifts your spirits. My thoughts:...

Developer Edition

By Admingod

I am proposing to the business that we use SQL 2019 Developer in our...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers