Skip to Content
0
Former Member
Jun 27, 2011 at 08:45 PM

Changing data source to stored procedure

20 Views

I have many reports that use tables in a SQL database as a data source. There can be anywhere from 1 to 10 tables used in a report. I need to change these over to use a single stored procedure. If I set the data source location for each table to the stored procedure it still shows up as multiple tables, not a single stored procedure in the explorer window. What is the best way to do this without removing all of the fields already on the report?