Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
Microsoft SQL Server 2008 R2 Unleashed- P227:SQL Server 2005 provided a number of significant new features and enhancements over what was available in SQL Server 2000. This is not too surprising considering there was a five-year gap between these major releases.Microsoft SQL Server 2008 is not as much of a quantum leap forward from SQL Server 2005 | 2224 CHAPTER 53 SQL Server 2008 Reporting Services Check the check box near the bottom that reads Add a Bing Maps Layer then select Road in the Tile Type drop-down. Integration with Bing Maps will surely give your reports a visual edge over the competition. Notice the new reporting term used on this check box layer. You can think of maps as collections of z-ordered layers of information. You can add layers to illustrate regions points place names pictures icons roads terrain perspective or just about anything else you can conceive of. Click Next then on the Choose Map Visualization screen click the Bubble Map button and then click Next. On the ensuing Choose the Analytical Dataset screen select the Choose an Existing Dataset radio button and then click on your dataset usually it is named DataSetl . Our analytical data illustrates relative numbers of product sales by state that is we are relating relative integer values to points in space. Click Next and on the ensuing Choose Color Theme and Data Visualization screen pick a color theme you like Ocean looks nice . Then make sure the Use Bubble Sizes check box is checked and that the Data field shown in the drop-down contains the simple expression Sum Quantity . This field is taken directly from the sample dataset. Check the Use Bubble Colors check box ensure that the data field expression is the same as before Sum Quantity and then pick a color you like and click Finish. When you return to the RB3 UI change the title text for the report to something more meaningful and then run the report. Afterwards save the report and then look at it using Internet Explorer in Report Manager. No doubt your users will be very impressed with the result illustrated in Figure 53.33. Returning to RB3 switch back to Design mode and then click twice on your report s map control. The Map Layers dialog appearing against the right edge of the map functions much like the Layers palette you may have worked with in Adobe Photoshop. It enables .
