Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Colour co-ordinating increasing/decreasing values on a matrix report Expand / Collapse
Author
Message
Posted Wednesday, January 30, 2013 10:02 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 4:43 AM
Points: 115, Visits: 144
Hi,

I just created a matrix report with consecutive dates running along the y-axis and sales people running down the x-axis.

Is there a way to show if a sales figure has an increase from the previous date as green and red if it has decreased?

Any help welcome.

Thanks,
Eamon
Post #1413700
Posted Tuesday, March 5, 2013 5:51 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 9:07 PM
Points: 466, Visits: 864
In SSRS 2005 I think you would need to have the sales values for different dates returned in the same row in the dataset. So that involves modifying your query possible using PIVOT or something like that.

In newer versions you can refer directly to other cells in the matrix using this:
ReportItems!Textboxname.value

You could create an expression in the format property
something like
=IIf(Fields!Column.Value > ReportItems!TextBoxName.value,"Green",IIf(Fields!Column.Value < ReportItems!TextBoxName.value,"Red","Black"))

The formatting formula would be similar if you have to use the first option, it would just refer to two fields at the same grouping/details level.

Post #1427096
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse