 | |||
|
|
||
| |||
| |||
| ||||||||
|
|
|||||||
|
|
|
|
| Book Excerpt: |
|
||
|
|||
|
|||
|
|||
|
|||
|
|||
|
|
||||||||||||||||||||||||||||||||||||
Introduction In Chapter 4, you built your first reports using the Report Wizard. This is like learning to ride your first two-wheeler with the training wheels on. Now it is time for the training wheels to come off, so you can see what this baby can really do! We are going to begin building reports from scratch. We hope these next few chapters provide the handholding you need, and then you can learn to ride sans training wheels without getting skinned knees. First, we work with the two types of reports you were introduced to in Chapter 4. We begin by building a table report without the use of the Report Wizard. From there, we do the same with a matrix report. After that, we look at two new report types—the chart report and the list report. We end the chapter by working with some of the basic report items that make up each report—namely, the line control, the text box control, and the rectangle control. Along the way, you learn more about the Report Designer that serves as our development platform. So, the training wheels are off and the wrenches have been put away. Don your helmets; it's time to ride! Riding Down Familiar Roads We cover some familiar territory as we begin building reports without the Report Wizard. In Chapter 4, you used the Report Wizard to create table reports (the Customer List Report and the Customer-Invoice Report) and matrix reports (the Invoice-Batch Number Report). We create these types of reports once more but, this time, without the aid of the wizard. Again, we look at the business needs of Galactic Delivery Services (GDS) and create reports to satisfy those business needs. The Transport List Report Features Highlighted
Business Need The transport maintenance department at Galactic Delivery Services needs a list of all the transports currently in service. They want this list to be grouped by transport type. The list includes the serial number, the purchase date, and the date the transport was last in for repairs. The list also includes the cargo capacity and range of each transport type. Task Overview
Transport List Report, Task 1: Create the Chapter05 Project, Create a Shared Data Source, and Create a New Report in the Chapter05 Project
NOTE
Task Notes Because we are creating several reports in the Chapter05 project, all of which select data from the Galactic database, we began by creating a shared data source. This saves us time as we create each of the reports. We continue this practice throughout the remaining chapters. In Steps 20 and 21, we are adding a report to the project. In Chapter 4, you saw that selecting Add New Report from the Context menu causes the new report to be created with the Report Wizard. In this chapter, we are looking to build our reports from scratch, which is why we used Add New Item in Step 21.
Task Notes Because we are creating several reports in the Chapter05 project, all of which select data from the Galactic database, we began by creating a shared data source. This saves us time as we create each of the reports. We continue this practice throughout the remaining chapters. In Steps 20 and 21, we are adding a report to the project. In Chapter 4, you saw that selecting Add New Report from the Context menu causes the new report to be created with the Report Wizard. In this chapter, we are looking to build our reports from scratch, which is why we used Add New Item in Step 21.
Click for the next excerpt in this series: Transport List Report Task 2: Create a Dataset
|
|
|
|
||||||||||||||||||||||||||||||||||
The following excerpt, courtesy of McGraw-Hill Osborne Media, is from Chapter 5 of the book Microsoft SQL Server 2005 Reporting Services 2005 written by Brian Larson. Click here to 
|
|
 |  |  | |  | |  | |  | |  | |  | |  | |  | |
|
|
About Us | Contact Us | For Advertisers | For Business Partners | Site Index | RSS |
|
|
||
|
|||||||
