Keep Report - Swap out Table/Stored Proc 2

[tadd]

I have a report that used to connect to a table, now it connects to a stored proc that returns the same fields. Problem is that the fields on the report still get their values from the table, but I want to them to get their values from the stored proc.

Is there some easy way to keep my report with all of its formatting, and just swap out the underlying data source for each field? All of the field names are the same between the old table and the new stored proc.

Even if I could just select the existing fields on the report and change their data source one by one, that would be fine. I couldn't figure out how to do that. ???

Thanks for any pointers.

 

[Madawc]

Database > Set Datasource Location should do it.

It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options.


Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[tadd]

Sorry. This is Crystal 10.

 

[tadd]

Using "Set Datasource Location" worked pefectly. Thanks.

 

[tadd]

I have a small follow up: I noticed that after I replaced the table with the stored procedure, the original table name did not change under [Field Explorer | Database Fields.]

Is there anyway to rename this table name/label? (I'm not even sure what Crystal calls this label - but it is the same name as the original table that the report was originally built on.)

 

[DataDog]

Ya, just go to Database/Database Expert - right mouse click on the table and rename it to your new sp name. Screwey, but it works.

DataDog
If God wanted us to count in Hexadecimal, then why did he only give us A fingers?

 

[tadd]

This worked. Thanks!

Crystal is strange indeed...never cared for the interface...