Click to Rate and Give Feedback
TechNet
TechNet Library
SQL Server
SQL Server 2008
Reporting Services
Development
 How to: Format Text in a Text Box
Community Content
In this section
Statistics Annotations (0)
Collapse All/Expand All Collapse All
SQL Server 2008 Books Online (October 2009)
How to: Format Text in a Text Box

You can format any part of the text separately within a text box. This ability to mix formats by adding placeholder text enables you to create mail merges or templates for text in your report. Any expression can be defined and formatted separately using a placeholder.

  1. In the Toolbox, double-click a Textbox report item, or drag it to the design surface.

  2. Inside the text box, select the text you want to format.

  3. Right-click the selected text, and click Text Properties.

  4. Set formatting options.

  5. Click OK.

  6. Repeat steps 2 through 5 for the remaining text you want to format.

  1. On the View menu, click Toolbox. The Toolbox appears.

  2. Double-click or drag Textbox from the Toolbox to the design surface. A new text box appears on the design surface.

  3. Type MyField: in the text box.

  4. Drag a field from your dataset into the text box. A placeholder is created for your field.

  5. Double-click the placeholder text, and then click Placeholder Properties.

  6. In Font, select Bold.

  7. Click OK. The string at design time should read, "MyField: [@FieldName]", where FieldName is the name of your field.

  8. Click Preview.

  9. The @FieldName placeholder has been replaced by the value of your field.

Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
Processing
© 2009 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks | Privacy Statement
Page view tracker