MS Word has a font property "Small Caps" that makes the first letter of a word a Font size or two larger than each following letter. I'm wondering if this is possible in SSRS. I didn't see the option under any of the Font Properties and I'm thinking writing an expression wouldn't be too difficult but I'm not sure if you are allowed to mix font size in a single text box or field? Along the same lines I'm wondering if I can make part of a sentence bold or different colors in the same text box or field? What do you think?

Hi, For SSRS 2008 check the Rich Text functionlity , link below. http://road-blogs.blogspot.com/2010/04/rich-text-in-ssrs-2008.html There is no direct way to make bold some parts of the text within a text box in 2005 ,either you can make bold for the whole text or not. But you need to get this putting several text boxes only and you need to handle the formatting issues as well. Or else try to write some functions in C# and put that code for the text box ,in this way you may achieve. Regards, PS

Hi Daniel_DeHaven, According to your description, you would like to know if “Small Caps” function is supported in SSRS 2008 R2, and is mix font size in a textbox allowed in SSRS R2, right. Please correct me if my understanding is wrong. For the first question, I am afraid that Small Caps is not supported in SSRS, and I suggest you submit a feedback at http://connect.microsoft.com/SQLServer/Feedback and hope Microsoft improve this feature in the next service pack or product release. To the second question, you can mix fonts and colors, add bold and italic styles, and use paragraph styles such as alignment and hanging indents. You can format an entire text box or you can format specific text, numbers, expressions, or fields within the text box. When a simple or complex expression is defined inside a text box, the resulting UI representation of this expression is known as a placeholder. You can define colors, fonts, actions, and other behavior on any number of placeholders or sections of text within a single text box. For more details about it, please see the following article, Formatting Text and Importing HTML: http://msdn.microsoft.com/en-us/library/cc645967(v=SQL.100).aspx Thanks, Eileen

Eileen, Thanks for the links and insight. I wasn't sure about mixing fonts and text sizes in on text box, it’s a little embarrassing that I didn't just try it out before writing, but I'm glad to know that I can. With that ability at my disposal I can get over the Small Caps feature and mix the font size manually since I only have to do it on sub-headers on a few reports. The primary reason I needed the ability to do this is because the SSRS reports are going to replace existing reporting and the consumers wanted exact replicas of the existing reports. This was the only piece that I hadn't been able to completely mimic. Thanks for your help!