Pro SQL Server 2012 Reporting Services

CHAPTER 13  CREATING REPORTS USING REPORT BUILDER 1.0, 2.0, AND 3.0

Figure 13-46. Setting data source and connection string properties

The query designer contains a minimal set of tools for query design and is similar in fashion to

query builder applications in SSMS. You can graphically add tables to a query, use stored procedures,

table valued functions, create joins, and filter data with criteria. In our case, we are going to use the

Emp_Svc_Cost stored procedure. In the query designer, we can expand Stored Procedures in the

Database view pane and then select the Emp_Svc_Cost stored procedure. As you can see after selecting

the stored procedure, you are shown the fields that the stored procedure returns as well as the

parameters that the stored procedure expects. If you want to see the Query results, set the parameter

values that you want to set and then run the query. For this example, leave the default values set to (null)

and execute the stored procedure by clicking the Run Query button. Figure 13-47 shows the stored

procedure Emp_Svc_Cost being executed with resultant data. Alternatively, we could have clicked on the

Edit As Text button, selected Stored Procedure as the type and then entered Emp_Svc_Cost in the query

text box.