Microsoft SQL Server 2005 Reporting Services
Revisions
December, 2006
Changes and additions are in blue text.
Page 116, Note Text
…If you have not done so already, download the sample code from this book’s web page at Search for the book’s web page using the ISBN which is 0072262397 and then use the code link to download the zip file containing the book’s material. Follow the instructions in the zip file to install the Galactic database and the other sample code as needed.
Page 132, Step 6
6. Select the Generic style in the style list and click Next. The Choose the Deployment Location Page of the Report Wizard appears. (This page of the Wizard will be skipped under certain circumstances. See the Task Notes on page 136.)
Page 182, Illustration
Replace the illustration on this page with I05-15R.tif.
Page 193, Step 4 and Step 5
4. In the Properties window, click the Property Pages button shown in the following illustration. The Matrix Properties dialog box appears.
5. The Matrix Properties dialog box appears. Click the Groups tab.
Page 198, Step 1
1. Select <New Dataset…> from the Dataset drop-down list. The Dataset dialog box appears.
Page 228, Step 18
PropertyValue e
Label= “Total Maint. Days – “Sum(Fields!DaysInMaint.Value) & vbcrlf & vbcrlf & Fields!Year.Value
Page 228, Step 19
PropertyValue e
Label= Fields!PropulsionType.Value & “Total Maint. Days(All Years)“
Page 229, Illustration
Replace the illustration on this page with I06-06R.tif.
Page 231, 3rd Complete Paragraph, 5th Sentence
… In this way, we can take “Total Maint. Days –” and concatenate it with 211 to get …
Page 264, Step 1
1. From the Main menu, select File | Close Project to close the solution.
Page 267, Query
SELECTJob.DescriptionAS Job,
Employee.EmployeeNumber,
Employee.FirstName,
Employee.LastName,
CONVERT(char(4), DATEPART(yy, '1/1/2006'))+'-'+
RIGHT('0'+CONVERT(varchar(2), DATEPART(wk, '1/1/2006')),2) AS Week,
TimeEntry.WorkDate,
TimeEntry.HoursWorked
FROM TimeEntry
INNER JOIN Assignment ON TimeEntry.AssignmentID = Assignment.AssignmentID
INNER JOIN Employee ON Assignment.EmployeeNumber = Employee.EmployeeNumber
INNER JOIN Job ON Assignment.JobID = Job.JobID
ORDER BY Job, Employee.EmployeeNumber, Week, TimeEntry.WorkDate
Page 272, Step 15 – Step 21
15. Click OK to exit the Table Properties dialog box.
16. Right-click the gray rectangle to the left of the detail row and select Edit Group from the Context Menu. The Details Grouping dialog box appears.
17. Select the Visibility tab.
18. Select Hidden from the Initial Visibility setting.
19. Check the box which is labeled Visibility Can Be Toggled by Another Report Item.
20. Select Week from the Report Item drop-down list. (This is at the bottom of the list.)
21. Click OK to exit the Grouping and Sorting Properties dialog box.
Page 305, Step 32
32. Select both the table and the text box with the string Employees with 45 to 55 hours for this week. …
Page 305, Step 35
35. Select the new text box by itself. Change the value of the text box to Employees with over 55 hours for this week. …
Page 331, 1st Partial Paragraph, Last Sentence
… We then divide and use the ###.00% format string to create a percentage.
Page 360, Step 4
The first character of the last sentence in this step is bold. It should not be bold.
Page 377, Step 33
33. Select several transport numbers from the drop-down list and click View Report. (Autorefresh is not supported in the report preview.) Your report appears similar to Figure 8-21.
Page 379, 1st Full Paragraph
Finally, we used autorefresh to meet the business requirements of the report. When the Autorefresh property is set, the report is automatically rerun on the schedule you specify. Unfortunately, autorefresh is only supported in the Report Manager. You can see autorefresh in action if you deploy this report to the Report Manager after reading Chapter 11.
Page 485, Step 14
14. Make sure the Allow Report History to Be Created Manually check box is checked…
Page 485, Figure 11-7
Replace the figure on this page with F11-07R.tif.
Page 567, Step 6
6. Find the <UI> entry…If you have SSL available on this server, change the <UseSSL> setting from False to True. In addition, remove the value between the <ReportServerVirtualDirectory> and </ReportServerVirtualDirectory> tags. The ReportServerUrl and ReportServerVirtualDirectory values are mutually exclusive and you will receive a parse error if both values are present.