Pro SQL Server 2012 Reporting Services

CHAPTER 4  LAYING OUT A REPORT

Figure 4-17. Rectangle in table with formatting

When you preview the report, the Estimated_Cost field doesn’t appear to be in the correct format,

which should be currency. Each textbox contains formatting properties that you can set in several ways.

In the Layout tab, right-click the textbox that contains the sum of the Estimated_Cost data field, and

select Properties. You can set the format for the textbox value on the Format tab of the Textbox

Properties dialog box. Alternatively, you can alter the Format property in the Properties window. Choose

Currency (see Figure 4-18). The default currency format, with a code of “C,” contains two decimal

places. If you wish, you can override this by choosing Custom and typing “C0” or “C1”, which would give