Advertisement

02.02.2006 at 02:29PM PST, ID: 21721784
[x]
Attachment Details

MS Reporting Services - Matrix Subtotal expression?

Asked by animated405 in SQL Reporting

Tags: reporting, matrix, services, subtotal

Hello,

I have an subtotal at the bottom of a matrix associated with a row group. How can I change the color of the background in the subtotal based of the value that subtotalled inside it without changing the background of another cell in the detail area if the value there matched the same criteria. I tried putting an expression in the detail, and it changes the color in both the detail AND subtotal....I only want to affect the subtotal...

I also tried changing the expression for the background color of the whole row that's created when I added the subtotal

thanks in advance!Start Free Trial
[+][-]02.03.2006 at 04:59AM PST, ID: 15862549

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

Zone: SQL Reporting
Tags: reporting, matrix, services, subtotal
Sign Up Now!
Solution Provided By: simon_kirk
Participating Experts: 1
Solution Grade: A
 
 
[+][-]02.03.2006 at 09:19AM PST, ID: 15865437

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.

 
[+][-]02.03.2006 at 09:46AM PST, ID: 15865690

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.

 
 
Loading Advertisement...
20080716-EE-VQP-32