I don't know ANY users that would even consider reading...

Sorry. I forgot one important bit of info.

When adding the parent group put a check the "Add group header" checkbox.

Interesting I would think you would get

North Facility

____________EmployeeA

____________EmployeeB

____________EmployeeC

Where the Facility is a parent group to the Employee Detail.

Try a slightly different approach:

1. Add your table/tablix

2. Add your employee...

You will probably have to pull the date apart into pieces and then concatentate the pieces as strings using functions like MonthName, Day and Year.

From your description, that is pretty much how I would do it. Getting a crosstab is strange indeed because that is usually the domain of a matrix style table.

I seem to recall reading that 2008R2 would export sub reports to different tabs. I am not sure about it, and I don't have the R2 version to test...

Funny hat day at work.

Woo Hoo! Drinks for everyone!

Good question.....lots of reading first thing in the AM.

Sounds painful, and hard to pronounce.

Table variables don't participate in transactions.....hmmm.....I suppose that makes sense. I definitely learned something today. Thanks.

What a movie.....I saw it at a party many years ago.....everyone thought it was quite humorous. I doubt that was the response the filmmakers had in mind.

Good question, good lively discussion. Thanks.

I keep a code library of problems I have solved, or new approaches to the same old problems. I also keep a portfolio of some of the more interesting...

Training day.