Ah dang... thanks for the feedback, Yumi. I've gotta remember to read the name of the forum I'm trying to answer the question on. I was thinking pure T-SQL solution which isn't appropriate for this RS case. You did it the right way... letting the service do the formatting after you've nailed the correct value.

I don't use reporting services enough to know why your reports aren't coming out in color, niow. I'd be tempted to just say "check the Windows printer settings" but I'm just not sure.

Hopefully, someone can help with that.