I used this yesterday for a matrix, and it worked fine:

http://business-intelligence.kdejonge.net/alternating-backgroundcolor-in-tablix-for-rows-of-a-group

Hope it works for you!

See if you can get Safari Books Online...great help to us!

Hello everyone!

I created a test schema with:

1. Parent/main table

2. Child/details table

3. Item/Activities table

I did this because all data coming into the database is in one of three...

Thanks for the reply!

I really don't see the parent table, listing the "goals", getting more than 200 rows....1000 in a year or two.

It's an important reporting database, but won't get...

Thanks for the reply!

I'm concerned about scalability, and if they decide they wanna throw in more levels of detail all of a sudden.

What do you think about:

create table Category

(CategoryId int...