Change DataSource

[RobDog888]

Is there some easy way to change a reports data source without having it delete all on report objects that are bound to the to-be-deleted source?

Crystal Reports 8.5

[brucevde]

Under the Database menu there is a Set Location command.

[RobDog888]

Yes, I had tried that and it wanted to remove my bound controls from the report evn though I had added a second source of the same fields.

What I am trying to do is change a data source created inside the rpt file from a SQL View to a SQL Stored parameterized procedure. Its my understanding that CR supports SPs as a datasource but Im not 100% about it supporting the parameters in it too. I can probably take them out and jus go with a selection formula but im trying to dramatically increase performance as it currently slow and the View is the reason.

[Paul M]

Are you doing this at runtime?

[RobDog888]

I will be setting the datasource to an ADO recordset at runtime but during design time I would like to remove the sql view source as at design time I have both sources. At run time I cant get the ADO to display since the fields are still bound to the sql view source.