<div>
<div class="content wysiwyg-content">
Hello~<br />
<br />
In my SQL Server reporting table I want to show a 0 placeholder if no data is returned. &nbsp;I currently have the following syntax: &nbsp;=Format((Fields!Done.Value<wbr />),&quot;##,###&quot;<wbr />) <br />
<br />
Thanks!<br />
<br />

</div>
</div>


Hello~

In my SQL Server reporting table I want to show a 0 placeholder if no data is returned.  I currently have the following syntax:  =Format((Fields!Done.Value),"##,###") 

Thanks!



SQL reporting table zero placeholder

Hello~

In my SQL Server reporting table I want to show a 0 placeholder if no data is returned.  I currently have the following syntax:  =Format((Fields!Done.Value),&quot;##,###&quot;) 

Thanks!



Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.