<div>
try something like this...<br />
<br />
=IIF(Fields!ConstituentNam<wbr />e.Value=&quot;S<wbr />#&quot;,Format(<wbr />Fields!Con<wbr />stituentNa<wbr />me.Value,&quot;<wbr />###&quot;,Forma<wbr />t(Fields!C<wbr />onstituent<wbr />Name.Value<wbr />,&quot;###.##&quot; ))<br />
<br />

</div>


try something like this...

=IIF(Fields!ConstituentName.Value="S#",Format(Fields!ConstituentName.Value,"###",Format(Fields!ConstituentName.Value,"###.##" ))



<div>
I tried that and I'm getting an error<br />
<br />
Too many arguments to 'Public Function Format (Expression As Object, [Style As String = &quot;&quot;] ) As string. 
</div>


I tried that and I'm getting an error

Too many arguments to 'Public Function Format (Expression As Object, [Style As String = ""] ) As string.

<div>
Following format code worked:<br />
<br />
=IIF(Fields!ConstituentNam<wbr />e.Value=&quot;n<wbr />0&quot;,&quot;g&quot;,&quot;F&quot;<wbr />)
</div>


Following format code worked:

=IIF(Fields!ConstituentName.Value="n0","g","F")

<div>
<div class="content wysiwyg-content">
In SQL 2005, I have a report with a matrix. The report displays information grouped by a column called constituents. By defual the value data is displayed in a number format with 2 decimals, which is fine for every column except for 1. I want that column to be displayed with no decimals.<br />
<br />
I've tried going into the matrix box properties for that field and on the format tab under the format code I put the following two expressions in:<br />
<br />
=IIF(Fields!ConstituentNam<wbr />e.Value=&quot;S<wbr />#&quot;,&quot;g&quot;,&quot;F&quot;<wbr />)<br />
<br />
=IIF(Fields!ConstituentNam<wbr />e.Value=&quot;S<wbr />#&quot;,&quot;d0&quot;,&quot;F<wbr />&quot;)<br />
<br />
When I run the report, the S# column is still showing with 2 decimals, how can I get that column to display without decimals and keep every other column at 2 decimals?<br />
<br />

</div>
</div>


In SQL 2005, I have a report with a matrix. The report displays information grouped by a column called constituents. By defual the value data is displayed in a number format with 2 decimals, which is fine for every column except for 1. I want that column to be displayed with no decimals.

I've tried going into the matrix box properties for that field and on the format tab under the format code I put the following two expressions in:

=IIF(Fields!ConstituentName.Value="S#","g","F")

=IIF(Fields!ConstituentName.Value="S#","d0","F")

When I run the report, the S# column is still showing with 2 decimals, how can I get that column to display without decimals and keep every other column at 2 decimals?



SSRS 2005 Format colum based on name

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.

Microsoft SQL Server 2005

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.