Link to home
Start Free TrialLog in
Avatar of BostonMA
BostonMAFlag for United States of America

asked on

How to specify font size in format expression SSRS 2005

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?

Avatar of Salim Fayad
Salim Fayad
Flag of Lebanon image

You cannot do that in one textbox, you have to seperate them into 2 textboxes and each one you give it its own font.
Avatar of BostonMA

ASKER


Then what is the technique to acheive this:

[Customer Name] - [Customer Id]
ie;
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.
ASKER CERTIFIED SOLUTION
Avatar of Salim Fayad
Salim Fayad
Flag of Lebanon image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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