• 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)

2006-07-28 (first published: )

3,801 reads

Blogs

VMware & SQL Server 823-824 alerts

By

We’ve been tracking a weird state with SQL Server virtual machines on VMware and...

Daily Coping 18 May 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Storage Field Day 23 – SIOS

By

I am thrilled to have been a part of this year’s Storage Field Day...

Read the latest Blogs

Forums

Quick Question on 2019 to older version?

By oogibah

A client of ours is upgrading their database to SQL Server 2019. The edition...

Mapping network drive to SSMS

By pols

Hi, I need to perform backup and save it in network drive. I have...

Extended Events to capture the queries run against the changed tracking tables.

By SQL_Hunt

Hello Group, Do you have any available extended events to capture the queries run...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers