You were right. I had to change the way the table was being created in the first phase of the data flow. Thanks!

The project is a little ways down the road but I will try that and let you guys know. The install of standard will be on the same machine so...

Would backing up and restoring msdb and master solve some of the loss issues?

Just wanted to thank everyone for their help. I was able to render the report to excel with all the tabs and columns showing.

Thanks for the help! It worked!

"First, add the field to the detail row, then delete the group."

I can't seem to add the field to details through properties or by dragging from the Report Data section...

Also (if you don't mind)

I wanted to create the report with no header so i deleted the header but the space between the first row and the top of...

That is correct. What do i need to do?

Yes that was it!

My last issue with columns repeating down the page.

All columns repeat down the page that same as the results do when I run the report query in...

Thanks for the tip. When I changed the 'Repeat on each page' for the static column I got this error when I tried to preview the report.

The tablix 'Tablix1' has...

Thanks. I found the way to name the worksheet tabs by setting the page break expression.

The problem now is is the column headers do not show on each page...

Now i am trying to get the tab name of each work sheet to display the name of the group for the page break. Any ideas?

I found it here thanks http://technet.microsoft.com/en-us/library/dd207058(v=sql.105)

How do I add the page breaks?

I will remember that next time. I used a conversion chart at this link http://www.bidn.com/blogs/DevinKnight/ssis/1387/ssis-to-sql-server-data-type-translations