<div>
Thanks!!! It works! &nbsp;I asked a stupid question .
</div>


Thanks!!! It works!  I asked a stupid question .

<div>
Far better to ask us suckers for points stupid questions, as we'll cheerfully answer them, then to ask your co-workers and have them wonder why you're asking stupid questions.<br />
<br />
Thanks for the grade. &nbsp;Good luck with your report. &nbsp;-Jim
</div>


Far better to ask us suckers for points stupid questions, as we'll cheerfully answer them, then to ask your co-workers and have them wonder why you're asking stupid questions.

Thanks for the grade.  Good luck with your report.  -Jim

<div>
<div class="content wysiwyg-content">
Hi Experts, <br />
<br />
In my ssrs table, I want to add the alternating background color expression. I tried 2 different expressions, but get the error message.<br />
In my report, there is no parameter setting. Thanks!!<br />
<br />
&quot;The BackgroundColor expression for the text box ‘DealerId’ contains an error: [BC30455] Argument not specified for parameter 'TruePart' of 'Public Function IIf(Expression As Boolean, TruePart As Object, FalsePart As Object) As Object'.&quot;<br />
<br />
<br />
<b>The 2 kinds of expression I tried </b><br />
=iif(RowNumber(Nothing) MOD2, &quot;Silver&quot;,&quot;White&quot;)<br />
<br />
=iif(RowNumber(Nothing) MOD2=1, &quot;Silver&quot;,nothing)
</div>
</div>


Hi Experts, 

In my ssrs table, I want to add the alternating background color expression. I tried 2 different expressions, but get the error message.
In my report, there is no parameter setting. Thanks!!

"The BackgroundColor expression for the text box ‘DealerId’ contains an error: [BC30455] Argument not specified for parameter 'TruePart' of 'Public Function IIf(Expression As Boolean, TruePart As Object, FalsePart As Object) As Object'."


The 2 kinds of expression I tried 
=iif(RowNumber(Nothing) MOD2, "Silver","White")

=iif(RowNumber(Nothing) MOD2=1, "Silver",nothing)

Table Alternating Color error SSRS

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.

SSRS

Microsoft SQL Server 2008 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. Major improvements include the  Always On technologies and support for unstructured data types.