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
Printable View
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
Under the Database menu there is a Set Location command.
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.
Are you doing this at runtime?
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.