O'Reilly logo

SQL Server 2012 Reporting Services Blueprints by Mickey Stuewe, Marlon Ribunal

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Formatting literals in an expression

We may want to make label for our textboxes: Category, Subcategory, and Product:

  • Category: Accessories
  • Subcategory: Tires and Tubes
  • Product: Patch kit / 8 patches, mountain tire tube, road tire tube

Prior to SQL Server Reporting Services 2008, you can only do that by creating two separate textboxes, so you can set separate font styles for each textbox.

SSRS 2008 and above have another property, called placeholder, that allows us to set different styles for literals and expressions within a single textbox. Let's do that:

  1. Go back to the designer, highlight the <<Expr>> in the first textbox and right-click on it, then select Placeholder Properties:
  2. That displays the Placeholder Properties dialog box. Click on the expression ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required