How to underline in SSRS using format code

Posted on 2009-04-20
Last Modified: 2012-05-06
I have the following expression which does not work:

=Format("Customer Name", "Underline")

Customer Name is not a field name, it is just text.  I want to underline it, however this expression returns the word Underline.
Question by:BostonMA
    LVL 16

    Accepted Solution

    You'll want to modify the TextDecoration property of that textbox.

    If you want to programatically change it then you'd have eto do something like

    =IIF(Textbox.value="Customer Name",Underline,None)
    LVL 4

    Author Comment

    I need to be able to create the following display in the report:

    Customer Name: Mike Smith

    where 'Customer Name' is underlined.

    I tried to do it as follows

    ="Customer Name: " + Fields!CustomerName.Value

    which produced everything I need except Customer Name was not underlined.  Do you know how to do that?

    LVL 11

    Assisted Solution

    The 2005 version of reporting services dosnt suppot mixed formatting within the same textbox/cell so you will need to split your expression across 2 cells or textboxes and have one contain the label and the other containing the actual customer name and set the text format to be underlined for that textbox/cell.

    Apparently the 2008 version allows you to do what your trying to achieve

    LVL 4

    Author Closing Comment

    Thank you.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Suggested Solutions

    Hi, In my previous Article  ( discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
    Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    794 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

    14 Experts available now in Live!

    Get 1:1 Help Now