<div>
I believe that can be done via Data Driven Colored Text &nbsp;as explained here <a href="https://www.mssqltips.com/sqlservertip/2612/data-driven-colored-text-for-reporting-services-reports/" rel="ugc">https://www.mssqltips.com/sqlservertip/2612/data-driven-colored-text-for-reporting-services-reports/</a>&nbsp;and all needed is to focus on the 
<pre><code id="code-20-43033556-1">=SWITCH(Fields!Pay.Value &lt;= 10, &quot;Red&quot;, Fields!Pay.Value &gt;= 20, &quot;Green&quot;)</code></pre>
 where you need to place your actual date column criteria.
</div>


I believe that can be done via Data Driven Colored Text  as explained here https://www.mssqltips.com/sqlservertip/2612/data-driven-colored-text-for-reporting-services-reports/ [https://www.mssqltips.com/sqlservertip/2612/data-driven-colored-text-for-reporting-services-reports/] and all needed is to focus on the

=SWITCH(Fields!Pay.Value <= 10, "Red", Fields!Pay.Value >= 20, "Green")

where you need to place your actual date column criteria.

<div>
Thanks, but that s nowhere near to what my query should look like :-(<br />
Can you help building the query syntax using dates?<br />
<br />
Something like<br />
=SWITCH(Fields!date.Value &lt;= today-14, &quot;Red&quot;, Fields!date.Value &lt;= today-7, &quot;Green&quot;)<br />
Then if Fields.status stayus03 and date &lt;=
</div>


Thanks, but that s nowhere near to what my query should look like :-(
Can you help building the query syntax using dates?

Something like
=SWITCH(Fields!date.Value <= today-14, "Red", Fields!date.Value <= today-7, "Green")
Then if Fields.status stayus03 and date <=

janhoedt

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I'd need a sql query to color code a date:<br />
Items = status NOT equal to 'Status01', 'Status02'<br />
For all items which have date less then a week =&gt; green<br />
older then a week =&gt; orange<br />
older then 2 weeks =&gt; red<br />
Items which have Status Status03<br />
and have date<br />
older then 2 weeks orange<br />
older then a month red<br />
<br />
Thanks for helping with the approach!<br />
<br />
J
</div>
</div>


Hi,

I'd need a sql query to color code a date:
Items = status NOT equal to 'Status01', 'Status02'
For all items which have date less then a week => green
older then a week => orange
older then 2 weeks => red
Items which have Status Status03
and have date
older then 2 weeks orange
older then a month red

Thanks for helping with the approach!

J

SSRS: color cell complex query

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

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.