Hi Lowell,

Thanks for taking the time to have a look. I will run some tests for both of these. I prefer creating a temp View and checking the...

Here is a great free tool for rapidly creating SQL Reporting Services Reports. Its quick, easy and will give you fully featured (filtering, sorting, summing and styled) report. Enjoy!

http://www.expressreporting.com

You could use this handy little sproc to write the C# for you - minimise errors!

http://www.codeproject.com/cs/database/CSCodeBuilder.asp

Thats odd.  I had the same problem about an hour ago.  Could'nt work it out.  So I stopped and started the server and it was fine after that?