Database Reference
In-Depth Information
Excel can use SQL stored procedures as well, but it's not as straightforward as it could be. Other applications
such as Microsoft Reporting Server (SSRS), however, have no such problems. In SSRS you can effortlessly launch
a wizard and include the stored procedure name you want to use to capture your report data. Figure
13-27
shows
the SSRS Report Wizard on its final dialog window, which list the details about the wizard configuration. Note
that the stored procedure name was used as a query.
Figure 13-27.
Getting report data from the stored procedure with Reporting Services
When the wizard completes, your SSRS project will include a new report that contains data generated from
your stored procedure (Figure
13-28
).
