[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


How to specify font size in format expression SSRS 2005

Posted on 2009-04-20
Medium Priority
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
  • 3
LVL 11

Expert Comment

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

Author Comment

ID: 24188413

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

Salim Fayad earned 2000 total points
ID: 24188558
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
ID: 24188576
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

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

872 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