Advertisement

05.12.2008 at 08:44AM PDT, ID: 23394911
[x]
Attachment Details

Conditional Formatting Columns in a Matrix

Asked by Fester7572 in SQL Server 2005, SQL Query Syntax

Tags: SQL Reporting Services, 2005 Reporting Services

I have a matrix that I am trying to add conditional formatting too.
I have already got the matrix to turn certain cells red if the month is now or later.
I now need to get values to go bold if they are higher than the value for the same period in the previous column.
I have attached a spreadsheet with what I am trying to achieve if it helps make it clearer.
The formula I have so far in the details area to set the font colour to red is:
=IIf(Fields!Year.Value=Year(Now()) AND Fields!MonthNo.Value >= Month(now()),"RED","Black")
How do I now get it to look at the value in the previous column to see if it is greater than it?
Any help is greatly appreciated as I am relatively new to this.
ThanksStart Free Trial
Attachments:
 
Book4.xls (15 KB) (File Type Details) 
Matrix Layout
 
[+][-]05.12.2008 at 09:55AM PDT, ID: 21548587

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.12.2008 at 11:01AM PDT, ID: 21549159

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.12.2008 at 11:45AM PDT, ID: 21549496

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.13.2008 at 01:18AM PDT, ID: 21553084

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.13.2008 at 02:20AM PDT, ID: 21553330

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.13.2008 at 02:36AM PDT, ID: 21553395

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.13.2008 at 02:40AM PDT, ID: 21553416

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.13.2008 at 12:34PM PDT, ID: 21558525

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.13.2008 at 12:44PM PDT, ID: 21558603

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.15.2008 at 12:48PM PDT, ID: 21577330

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.16.2008 at 03:12AM PDT, ID: 21581433

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.17.2008 at 06:30AM PDT, ID: 21589265

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.17.2008 at 09:09AM PDT, ID: 21589871

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: SQL Server 2005, SQL Query Syntax
Tags: SQL Reporting Services, 2005 Reporting Services
Sign Up Now!
Solution Provided By: mark_wills
Participating Experts: 1
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628