Wrox Programmer Forums
|
BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7
This is the forum to discuss the Wrox book Professional SQL ServerReporting Services by Paul Turley, Todd Bryant, James Counihan, George McKee, Dave DuVarney; ISBN: 9780764568787
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 17th, 2005, 01:37 PM
Registered User
 
Join Date: Feb 2005
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Row Color depending on if cell value same as prev

Hello,

Here's what I'm trying to do in psuedocode:

If(cell.value == previous.cell.value)
{
  cell.color = previous.cell.color
}
else
{
 if(previous.cell.color == "White")
   cell.color = "Orange"
 else
   cell.color = "White"
}

I have a table in SRS and I want the row colors of rows with a cell that is equal (I order by this cell) to be grouped as the same color.

I know I can alternate rows by:

=IIf(RowNumber(Nothing) Mod 2, "AliceBlue", "White")

And I know there is a previous function

=IIf(Previous(Fields!MyValue.Value ) = Fields!MyValue.Value,
(HERE'S WHERE I'D NEED TO CHECK THE PREVIOUS COLOR), ??)

Is there any way to access a row's color?

Thanks.






Similar Threads
Thread Thread Starter Forum Replies Last Post
How to get Excel Cell color populate .NET Framework 2.0 2 March 3rd, 2014 04:25 AM
change cell color martin1 Visual Basic 2005 Basics 2 October 4th, 2006 08:55 AM
how changeselected cell color in MSExcell cruz75 Excel VBA 0 August 9th, 2006 03:44 AM
Change Cell Color phungleon HTML Code Clinic 2 April 9th, 2006 12:36 AM
Listview Cell Color leontun Pro VB 6 2 December 15th, 2004 04:14 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.