<div>
Russell,<br />
<br />
I thought that would work but it didn't. &nbsp;I think SSRS looks to both sides of the equation and it still errors out on the sum even though it isn't being used.
</div>


Russell,

I thought that would work but it didn't.  I think SSRS looks to both sides of the equation and it still errors out on the sum even though it isn't being used.

<div>
You mean the entire data set is empty / doesn't exist? You might then need to force the query to always return some sort of value:<br />

<pre><code id="code-20-41504515-1">IF EXISTS(SELECT 1 FROM YourTable WHERE [SomeField] = 'SomeValue')
SELECT [PERCENT_BOOKED]
FROM YourTable
ELSE
SELECT 0.00 AS [PERCENT_BOOKED]</code></pre>
Many people don't know that you can use more than just a standard select query in the query block on a report. I even have one that does updates before returning a value (hidden parameters passed in through the URL).
</div>


You mean the entire data set is empty / doesn't exist? You might then need to force the query to always return some sort of value:


IF EXISTS(SELECT 1 FROM YourTable WHERE [SomeField] = 'SomeValue')
SELECT [PERCENT_BOOKED]
FROM YourTable
ELSE
SELECT 0.00 AS [PERCENT_BOOKED]

Many people don't know that you can use more than just a standard select query in the query block on a report. I even have one that does updates before returning a value (hidden parameters passed in through the URL).

<div>
<div class="content wysiwyg-content">
When my dataset does not return any records and i do a sum i get and error. &nbsp;How do i fix this?<br />
<br />
=Sum(Fields!PERCENT_BOOKED<wbr />.Value)
</div>
</div>


When my dataset does not return any records and i do a sum i get and error.  How do i fix this?

=Sum(Fields!PERCENT_BOOKED.Value)

sum returns and error if there are no rows

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.