Skip to Content
0
Former Member
Mar 25, 2009 at 08:50 PM

Changing the Stored Procedure / Mapping Fields

21 Views

I have this problem a lot and am wondering if there is a better way.

I make a report with a stored procedure named SP1.

I need to change the stored procedure to SP2.

In the Designer, I select Database Expert and choose SP2.

Now, SP1 and SP2 are both in my report, but all the fields on the report are linked to SP1.

I have to manually change every field on the report and recreate all the summary fields.

Then, I remove SP1 from the Report.

Is there a better way to do this? It is getting tiring!

Thanks,

Linda