Đang chuẩn bị liên kết để tải về tài liệu:
Sams Microsoft SQL Server 2008- P4

Tham khảo tài liệu 'sams microsoft sql server 2008- p4', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | Generating Reports with Visual Studio 131 Design Screen After selecting your data the next step is to design the presentation for the data. Layout assistance is provided by the Toolbox Report Data and Design dockable windows. Design view is a default that BIDS displays after you add a report see Figure 8.11 . Report items Toolbox Main menu Toolbar Solution Explorer Dataset fields Report data Context help tip for a property Properties window Property pages Alphabetical Categorized Properties toolbar Output window Error List window FIGURE 8.11 Report Design view. 8 The Toolbox shown in Figure 8.11 is accessible by selecting Toolbox from the View menu. This has all the report item controls you might use while authoring reports. The simplest way to use them is to drag the control you want onto the body of a report. Data can be inserted from the Report Data window. Just choose Report Data from the View menu. The Report Data window contains a tree list of available fields to use from the data sets. If you drag a field onto the report body BIDS creates a text box to contain the field. Any item on the report can be modified through the Properties window. The Properties window can be accessed by pressing F4 or by selecting Properties Window from the View menu. Figure 8.11 shows the Properties window for a report object. lease purchase PDF Split-Merge on www.verypdf.com to remove this watermark. 132 CHAPTER 8 Report Designer s At this point in the report development process you need to take the results of your query and apply a layout and format to them. Let s make a simple tabular report and add a few bells and whistles. Complete the following steps using the Sales by Territory by Salesperson report 1. Drag a text box from the Toolbox to the report body. In the Properties window F4 select the text box. Most likely the text box you just added is already selected. Enter Sales by Territory by Salesperson in the text box and change the following property values to those .