How to specify font size in format expression SSRS 2005

Posted on 2009-04-20
Last Modified: 2012-05-06
I have an expression like this:

=Fields!Customer_Name.Value + format(Fields!Customer_ID.Value, "8")

where 8 is my attempt to format the ID in font size 8.  Basically I want the customer name in one font size (10 and bolded preferably), and the ID in another size (8 and not bolded).  What is the technique/syntax to accomplish this?

Question by:BostonMA
    LVL 11

    Expert Comment

    by:Salim Fayad
    You cannot do that in one textbox, you have to seperate them into 2 textboxes and each one you give it its own font.
    LVL 4

    Author Comment


    Then what is the technique to acheive this:

    [Customer Name] - [Customer Id]
    Mike Smith - 79438
    George Bresh - 24671

    where [Customer Name] is in font 10 and the ID is in a smaller font.
    Notice if I just put the two fields next to each other it wont work in the above example it would look like:

    Mike Smith      - 79438
    George Bresh - 24671

    which i dont want.
    LVL 11

    Accepted Solution

    For one textbox, there is only one font. The Expression allows you to manage this one value programaticaly based on some calculations. So, I am afraid that you cannot do that in Reporting Services
    LVL 11

    Expert Comment

    by:Salim Fayad
    There is 2 properties for the textbox that you can put them for the [Customer Name] to do what you want, put them as true:
    1. CanGrow
    2. CanShrink

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
    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…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    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

    11 Experts available now in Live!

    Get 1:1 Help Now