Thanks for the Reply Dhans. We're going with the route of purchasing this crystal report converter called KTL Crystal Converter. It does a good job converting them and...

I did see it, Thanks!!! I am trying to implement it now. I completely forgot about XQueries. Thanks for the refresher and the link. I'm feeling...

Sorry, I'm new to SqlServerCentral and am still getting the hang of things. I put my post in a topic and saw I put it under the wrong topic....

Thanks! I was hoping to avoid Dynamic SQL, but I guess it is something I am just going to have to deal with Thanks Again.

Yes, you are correct, it is a Case "Expression" and not a statement. Also the Dynamic SQL is what I am looking for. I was trying to explain...

I didn't even think about datediff, I was too busy looking at the dateadd function. Thank you so much, this was very helpful. My project Manager and I...