CHAPTER 6 BUILDING REPORTSchapter to connect to the Pro_SSRS database. The connection string should look similar to the following:
Data Source=localhost;Initial Catalog=Pro_SSRS
The next screen in the wizard defines the query. Paste the query you created in Chapter 2 into the
Query String area (see Figure 6-1). You can open this query from the Query folder in the code download
for the book. The file is called Report_Wizard_Query.sql. Clicking the Query Builder button launches the
graphical query designer.
Figure 6-1. Pasting the query in the Query String area
The next screen of the Report Wizard asks whether the report should be in tabular or matrix form.
Selecting Tabular will trigger the wizard to provide grouping information on the next screen; selecting
Matrix will provide a similar screen for rows and columns instead of groups. For this example, select
Tabular, click Next, and choose the grouping and detail layout to show Year as the primary group, with
Month, EmployeeClassID, and Employee_Name next. For details, you want to see the patient-specific
information—Diagnosis, Visit_Count, Estimated_Cost, and Service_Type—as shown in Figure 6-2.