<div>
Do you have mapping of Receipt Number to Color ??<br><br><br>
</div>


<div>
Thanks for your comments<br><br>No I do not have anything specific to map it.<br><br>I tried something like this, but not what I want&nbsp;<br><br><pre><code class="code-1 nolinks" id="code-20-43283241-1"><span>=IIf(Fields!receiptno.Value = Previous(Fields!receiptno.Value), Nothing, Fields!receiptno.Value)</span>
</code></pre>
</div>


<div>
How you decide which color for which receipt ??<br><br><br><br>
</div>


ChageRowColor.rdl

<div>
Thanks for your comments.<br><br><blockquote>How you decide which color for which receipt ??</blockquote>I need to check when the next receipt number starts or when the first receipt number ends. Then accordingly change the colour.<br><br>I tried with this expression, please see screenshot<br><br><pre><code class="code-1 nolinks" id="code-20-43283618-1"><span>=IIF(RUNNINGVALUE(Fields!receiptno.Value, COUNTDISTINCT,"detailproductandrawmaterialtransaction") MOD 2 = 0,"Yellow","White")</span>
</code></pre><br><a href="https://filedb.experts-exchange.com/incoming/2021/05_w19/1559339/2021-05-05_09-17-52.gif" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2021/05_w19/1559339/2021-05-05_09-17-52.gif" class="fr-fic fr-dib"></a>
</div>


2021-05-05_09-17-52.gif

Software

Zolf

<div>
I just noticed in the end of the report page 72, the report is not changing colour when the receipt no. changes.<br><br><a href="https://filedb.experts-exchange.com/incoming/2021/05_w19/1559341/2021-05-05_11-41-52.gif" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2021/05_w19/1559341/2021-05-05_11-41-52.gif" class="fr-fic fr-dib"></a>
</div>


2021-05-05_11-41-52.gif

<div>
I have added another expression for the receiptno. this time not in the textbox properties fill BUT in the expression itself of the table column for receipt no<br><pre><code class="code-1 nolinks" id="code-20-43283657-1"><span>=IIf(Fields!receiptno.Value = Previous(Fields!receiptno.Value), Nothing, Fields!receiptno.Value)</span>
</code></pre><br>What it does is it removes the receipt no to repeat itself and just show once. This works properly. see screenshot for exactly the same place where I pointed to the issue above of not changing colour.<br><br><a href="https://filedb.experts-exchange.com/incoming/2021/05_w19/1559343/2021-05-05_12-16-57.gif" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2021/05_w19/1559343/2021-05-05_12-16-57.gif" class="fr-fic fr-dib"></a>
</div>


2021-05-05_12-16-57.gif

<div>
Thanks for your comments. Any solution to this issue??
</div>


<div>
<div class="content wysiwyg-content fr-view">
Hi there,<br><br>I want to change the colour of the rows based on the value of column(receipt no.). How can I do this. Please see screenshot.<br><br><a href="https://filedb.experts-exchange.com/incoming/2021/05_w19/1559243/2021-05-04_12-09-46.gif" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2021/05_w19/1559243/2021-05-04_12-09-46.gif" class="fr-fic fr-dib"></a>
</div>
</div>


2021-05-04_12-09-46.gif


Hi there,
I want to change the colour of the rows based on the value of column(receipt no.). How can I do this. Please see screenshot.

SSRS - Change colour of row based on column value

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

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.

DB Reporting Tools

The Microsoft Server topic includes all of the legacy versions of the operating system, including the Windows NT 3.1, NT 3.5, NT 4.0 and Windows 2000 and Windows Home Server versions.

Microsoft Server OS

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.