<div>
<div class="content wysiwyg-content">
I'm looking for a way to alternate the background color of a group header in reporting services. &nbsp;I'm currently using this code to alternate the detail rows to create a &quot;green bar&quot; effect, but it doesn't work in the group header because its still counting the number of rows, instead of the group headers.<br />

<pre><code id="code-100130">=iif(rownumber(nothing) mod 2 = 1, &quot;AliceBlue&quot;, &quot;White&quot;)
</code></pre>
</div>
</div>


I'm looking for a way to alternate the background color of a group header in reporting services.  I'm currently using this code to alternate the detail rows to create a "green bar" effect, but it doesn't work in the group header because its still counting the number of rows, instead of the group headers.

Alternating background color of group header in MS Reporting Services

I&#39;m looking for a way to alternate the background color of a group header in reporting services.  I&#39;m currently using this code to alternate the detail rows to create a &quot;green bar&quot; effect, but it doesn&#39;t work in the group header because its still counting the number of rows, instead of the group headers.

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.