Building Reports in SQL Server 2005

Learn to use the SQL Server Report Wizard and to write reports from scratch. Excerpt: The report you will be creating in this chapter is called the Employee Service Cost report. This report will utilize the same query and stored procedure, Emp_Svc_Cost, that you have been working with since Chapter 2 to provide the report data. As a reminder, the query returns detail records that represent services, such as a skilled nurse or home health aide visit, performed for patients. Each type of service has an associated cost for the health-care company. This report, when complete, will show important cost points based on associated data provided by the query, such as the patient’s diagnosis, the employees who performed the services, the date of each service, and the branch location of the patient. By grouping and sorting the report at these cost points, the user will be able to see the cost of services from the individual patient all the way up to the branch location, which might serve hundreds of patients. You will group and calculate the cost amount at each level.