Pro SQL Server 2012 Reporting Services

CHAPTER 6  BUILDING REPORTS

Figure 6-22. Placeholder Properties dialog with HTML selected

The textbox can also contain expressions that correspond to other field values from datasets as well,
just as you would expect. After the greeting, you can see that we have added the patient’s name as
another placeholder. This name, which contains the value expression
=FIRST(Fields!Patient_Name.Value, "DataSet2"), will change with the parameter value that we set up for
the PatID field.
The remainder of the textbox contains additional formatting, such as bold, italicized, and font color
of some text, all of which are independent of the header placeholder that contains the HTML code. This
kind of formatting was not available before SSRS 2008. With the ability to also export to Microsoft Word,
rich text formatting opens up new avenues of report creation for your business. Figure 6-23 shows the
rendered Patient Survey Letter report.