I tried to add multiple space in the title of my reports like 'A B' but what I got is just 1 space in the middle like 'A B'. Anyone has suggestion?

This message has been edited. Last edited by: hainguyen,

HTML suppresses multiple-spaces to single-spaces. Please elaborate.

Thanks Doug for your hint. I found the solution on this link : http://forums.informationbuild...8331/xsl/print_topic The simple trick is putting &|nbsp; instead of ' '.

Another issue comes up with this solution. Although I can see multiple spaces in HTML, I see &|nbsp; in both PDF and Excel. Stuck again, any suggestion for me?

Instead of using  , use SET SHOWBLANKS = ON

awesome. Thanks Waz.

Please edit your first post in this thread and add [CLOSED] or [SOLVED] to it.