Reporting Services Mix Regular and Bold Font in a text box

Posted on 2005-04-15
Last Modified: 2013-12-03
I have created a report that simulates a letter. The body of the letter is rendered by a text box with text and carriage returns (VbCrlf). Some, but not all of the text needs to be a bold font. I checked the properties on the text box and you can set the font for the text box but it is an all or nothing proposition. I opened up the .rdl source code and was unable to figure it out. I would like to keep all of the text in this one text box as the letter is formatted correctly. I fear that if I break up the text into 2 or more text boxes it could throw the formatting off. Can anyone help??
Question by:pscit04
    LVL 44

    Accepted Solution

    If the text is rendered in a SIMPLE textbox, then you can only associate ONE font, with the entire textbox.  To be able to have mixed fonts, (or Sizes, or colors of text for that matter), within a 'textbox', you need to utilize a Rich TextBox Control - and that may or may NOT be possible within the context of a report.  Never tried, so can't answer that part.  But in any case, what you need is RICH TEXTBOX CONTROL, and if that is not possible then the formatting you ask about is also not possible.

    LVL 7

    Expert Comment

    Like AW said you can not do this out of the box with SQL RS.  We had to use textbox's back to back and apply whatever style to each box that we wanted.  Its a pain but its a limitation of SQL RS

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Suggested Solutions

    Title # Comments Views Activity
    visual studio and gui 6 31
    either24  challenge 19 73
    static class 3 44
    NotAlone Challenge 20 65
    There is an easy way, in .NET, to centralize the treatment of all unexpected errors. First of all, instead of launching the application directly in a Form, you need first to write a Sub called Main, in a module. Then, set the Startup Object to th…
    This article is meant to give a basic understanding of how to use R Sweave as a way to merge LaTeX and R code seamlessly into one presentable document.
    This video teaches viewers about errors in exception handling.
    The viewer will learn how to use the return statement in functions in C++. The video will also teach the user how to pass data to a function and have the function return data back for further processing.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now