tailieunhanh - Microsoft SQL Server 2005 Developer’s Guide- P38

Microsoft SQL Server 2005 Developer’s Guide- P38:SQL Server 2005 is a feature-rich release that provides a host of new tools and technologies for the database developer. This book is written to help database developers and DBAs become productive immediately with the new features and capabilities found in SQL Server 2005. | Chapter 9 Reporting Services 349 wizard dialog will ask you to design a query to execute to retrieve the data for your report. A Query Builder button allows you to interactively create your query statement. Next you will be prompted to select a report type tabular or matrix. The next dialog asks how you would like your report grouped. A list of available fields is displayed for you to select and assemble according to Page Group or Detail sections on your report pages. You then choose the layout of your report and the style of your report. After you select your report data groupings and layout a summary dialog will be displayed where you can name your report and optionally choose to preview the report. The Report Wizard Summary is shown in Figure 9-6. If you have chosen to preview your report clicking the Finish button on the Report Wizard Summary page executes the query and generates the report to a preview pane in the BI Development Studio environment as shown in Figure 9-7. Figure 9-6 Report Wizard summary 350 Microsoft SQL Server 2005 Developer s Guide Figure 9-7 Report preview Using the Report Designer to Create a Report To start the Report Designer and create a report project you open up SQL Server 2005 s Business Intelligence Development Studio and then select File New Project. On the New Projects dialog click the Business Intelligence Projects options from the Project Types list box to view the installed BI project templates and select the Report Project template. Type a name and location for the project and click OK to create the report project. You can see an example of the Reporting Services Report Designer in Figure 9-8. The next section discusses each of the Report Designer elements. Design Surface In the center of the screen in Figure 9-8 you can see the Report Designer s design surface. The design surface presents three tabs Data Layout and Preview. To create a report you must first define a dataset by clicking the Data tab to reveal the Data pane. .