Thank you so much, this works perfectly!!
I support 3 environments, sql 2000, sql2005 and sql 2008.
This report will reside in our sql 2000 server for about 6 months and then it will be migrated over to 2008.
Until we migrate, is there a way to do this in sql 2000?
Again, thank you.