1244
Part IX: Business Intelligence
Tab Items Confi guredAlignment Horizontal options are Left, Center, and Right. Vertical options are
Top, Center, and Bottom. Confi gure any padding here.
Font Change the font of text inside the box. Standard formatting options
are Font, Properties, Strikethrough.
Border Border options. You can control which edges have a border, and the
width, color, and pattern of the line edging the box.
Fill Fill options are colors, patterns, images for display, or a watermark.
Visibility Can hide objects in a report. This is also where drill-downs are
confi gured.
Interactive Sorting When a property is set, enables user to click a column header and
interactively sort the report.
Action When a property is set, enables drill-throughs to a URL or to another
report after clicking the item.Using Reporting Services Features to Visualize
Your Data
So you have a basic report thanks to the wizard. Now you receive another few require-
ments. Your boss says, "This is great, but I'd like to know who my top clients are. Can you
highlight clients who exceed $1,000,000 in sales?” You can accomplish this in several ways;
two of them are covered next.One way to achieve the goal would be add another fi eld to the dataset, which would evalu-
ate the annual sales and evaluate to true when they are more than $1,000,000. To create a
calculated fi eld on the dataset, perform the following steps:- Right-click the ResellerContact dataset.
- Select Add Calculated Field.
- In the last Field Name on the Fields tab, type PremiumClient.
- Click the Fx button beside the Field Source box beside the Field Name.
- In the Expression Dialog box, enter =IIF(Fields!AnnualSales
.Value>1000000,"True", Nothing) and click OK twice. - Drag the PremiumClient Field onto the report surface beside the AnnualSales fi eld.
Let go of the fi eld when the ibar appears. - Click Preview to see the results.
TABLE 55 -2 (continued)c55.indd 1244c55.indd 1244 7/31/2012 10:28:05 AM7/31/2012 10:28:05 AM
http://www.it-ebooks.info