Pro SQL Server 2012 Reporting Services

(sharon) #1
CHAPTER 4  LAYING OUT A REPORT

Figure 4-8. Textbox Placeholder properties


For this demonstration, you will add a simple date placeholder, a greeting, and a data field, each
with different formatting styles. In chapter 6, you will expand on this by creating a patient survey form
letter that combines multiple objects like Rectangle and Table to deliver a detailed report of services
rendered along with the survey. For a simple Textbox like this one, no grouping is available for the
dataset, Pro_SSRS_DS, so you will use the First function to extract the patient name from the dataset for
this example.
With the Placeholder Properties dialogue box still open, type “Today” in the Label field and
“=NOW()” in the Value field. One important note on formatting is that if HTML is selected on the
General tab, other date-formatting rules on the Number tab will not be applied. Therefore, for this
placeholder, select None – Plain Text Only as in Figure 4-9.

Free download pdf