Change from pointing to a SQL View to Pointing to a Procedure

[CFBaber]

I am attempting to set the location of the data source from pointing to a sql view to pointing to a sql stored procedure. Is there a proper way to do this that will work for pointing lots of reports to sprocs?

 

[Naith]

Set Location via the Database menu is how you point a report at a new datasource.

Unfortunately, you do have to repeat this step for each report affected by the datasource change.

Naith