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