May 16, 2006 at 3:06 pm
In a report of invoices grouped by customer I want to put alternatively the colour to the rows of each custumer.
I get to put the colour to the first row of each customer with:
=IIF(Fields!Field1.Value<>Previous(Fields!Field1.Value), "Black", "White")
but I want to put the same color for all the rows of the customer.
Some ideas?
Kind regards.
May 16, 2006 at 3:29 pm
hmm... let me get this straight. You want to use the same color for all rows of a customer. For example: Green for everything belonging to customer A, Blue for everything belonging to customer B, etc?
If so, I would assume Field1.Value is not the customer name, because I would think that using the customer name would at least alternate between black and white for each customer.
So my idea would be to use that code with the customer name, and not Field1. I hope this helps.
May 17, 2006 at 1:21 am
No, the field1 it's the customer's code.
Exactly I want the records of customer 1 in blue, the next customer in black, the next in blue, the next in black, and so on....
May 17, 2006 at 6:15 am
Try this
=iif(RowNumber(Nothing) Mod 2,"White","PeachPuff")
May 17, 2006 at 8:31 am
Ramon,
Assuming that any given customer can have any number of invoices I'd try this.
=Iif(RunningValue(Fields!CustomerID.Value,
countdistinct,nothing) mod 2,"Blue","Black")
Mike
May 17, 2006 at 9:17 am
Thank you very much Mike.
It works fine.
You have a friend in Spain forever....
Ramon.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply