Database Reference
In-Depth Information
Using Stored Procedures
Views are only one example of how you can interact with SQL Server. You can also make Excel reports using a
stored procedure. This may not be obvious since the user interface does not show you that as an option, but by
going to the connection properties once again, you can change the settings to accomplish this. First you need to
change the command type from a table to a SQL statement and then change the command text from the name of
a view to the name of a stored procedure (Figure
15-17
). Configuring just these two settings will allow you to use a
stored procedure for your report.
Figure 15-17.
Changing the command type to SQL and command text to use a stored procedure
