Creating SQL Stored Procedures via SQL Server is easier than you might have originally thought, so let us explain what to do.

Stored procedure XML This screenshot lists the source of a SQL Server 2014 stored procedure hitting the AdventureWorks2012 database, selecting data from the Customer and SalesOrderHeader tables.

This tutorial demonstrates how to bind a report to a stored procedure provided by an SQL data source: Create a new report. Click the report's smart tag. In the invoked actions list, expand the ...