Oddly enough I've figured out the issue. It's a font issue. As I was using Arial I guess there must be an issue with that particular font and I'd imagine...

So here's a perfect example. If I take this DDL code I created on my own and go into SQL Prompt and select the INDENTED format which should really do...

Hello and thank you for replying to my question.

I get the prompt for Username and password if I try to connect with the http://<computername>/Reports

and I get a...

Thanks so much for the reply. I think we're close but not quite there. This is what I converted what you wrote to based on specs of what I needed:

=IIf...

Thanks so much! That definitely gets me what I need.

Thank you! I definitely was able to find where that custom code was. I actually did use Crystal Converter to generate the report so there's a load of custom code....