CHAPTER 13 CREATING REPORTS USING REPORT BUILDER 1.0, 2.0, AND 3.0
Next, you will format the Estimated_Cost field to display the value as currency. Click back in the
Design area, and then follow these steps to apply some formatting:- Right-click the SUM(Estimated_Cost) textbox and choose Textbox Properties.
- Figure 13-57 shows the dialog that presents the textbox properties
encompassing many of the formatting and actionable items available, such as
interactive sorting, visibility, and hyperlink options. These are all the same as
properties that you would set when developing a report in BIDS. Click Number
on the left and choose Currency for the format, then choose the option to Use
1000 separator (,) and click OK to save the Textbox Properties. - Next, apply the number formatting with the thousands separator to the
Visit_Count field by right-clicking it and selecting Textbox Properties. Select
the Number tab and then choose Number as the Category. Set the decimal
places to 0 and select the option to Use 1000 separator (,) and click OK to save
the Textbox Properties. - Since the default height of the report has given extra white space, let’s cut
down on this by dragging the footer bar up closer to our Matrix report item.
Figure 13-57. Textbox properties for Estimated_Cost