<div>
This is not SSRS functionality, it's T-SQL functionality. <br />
Rewrite the Stored Procedure / source SQL in your dataset to ensure that at least one row is returned. <br />
<br />
So .. show us the T-SQL that is behind the data set.
</div>


This is not SSRS functionality, it's T-SQL functionality.
Rewrite the Stored Procedure / source SQL in your dataset to ensure that at least one row is returned.

So .. show us the T-SQL that is behind the data set.

<div>
Can't show you you the actual code by let's say the T-SQL was <br />
<br />
SELECT * FROM Employee WHERE Rating = '6'<br />
<br />
If that doesn't return anything how would i have it return a empty row?
</div>


Can't show you you the actual code by let's say the T-SQL was

SELECT * FROM Employee WHERE Rating = '6'

If that doesn't return anything how would i have it return a empty row?

<div>
Jim - that solved my issue. Thanks.
</div>


<div>
<div class="content wysiwyg-content">
The dataset being used by a particular query make not always return a record. It no records are returned i want a blank row added. &nbsp;How could i do that?
</div>
</div>


The dataset being used by a particular query make not always return a record. It no records are returned i want a blank row added.  How could i do that?

leave a 1 blank row if a dataset returns no records

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.