SSRS Cell Background be equal to another Cell Background

Question

SSRS Cell Background be equal to another Cell Background

bcarrington-945395

SSC-Addicted

Points: 453
More actions
October 21, 2009 at 2:28 pm

#211322

I am trying to find a way to have a cell background color match that of another cell's background color in an SSRS report. How would I reference the BackgroundColor value for the other cell?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Jack Corbett SSC Guru Points: 184393 More actions · Answer 1

I don't think that SSRS exposes that property. I think the only cell property that is exposed is Value.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

P Jones SSChampion Points: 12355 More actions · Answer 2

I did that this morning by copying the formula exactly from one cell's background expression property to the other! It wasn't worth the effort of trying to do something clever. 🙂

Is there some reason you can't just do that?

bcarrington-945395 SSC-Addicted Points: 453 More actions · Answer 3

Too complex to really say but I have custom code to determine the background for 3 groupings on a matrix report and I wanted the data portion of the matrix to match each groups color scheme.

becklery Hall of Fame Points: 3315 More actions · Answer 4

I am using RAQ Report. With it, users can set the background color of cell easily. The only thing you need to do is setting it in the properties bar at the right side of the report IDE.

The screenshot of the report IDE is shown below:

RAQ Report: Web-based Excel-like Java reporting tool[/url]