can I change data source name globally? 1

[beckybear]

Is there any way to change a table name globally?

I have a set of reports that use a certain table and I want to change the reports to use a view with the same field names, but obviously a different table name. Is there any way to do this aside from recreating the reports with the new view?

Thanks.

 

[Naith]

You'd have to go into each report, and change the data source they're looking at via Database/Set Location.

I don't think Crystal are enabling a facility to update a batch of reports datasources until v9's successor, at least.

Naith

 

[beckybear]

Thanks for your help. I must have been blind to miss that option on the menus. Need more caffeine, I guess.

 

[synapsevampire]

I have an example which will allow you to change multiple reports data sources using CSP in Crystal Enterprise.

If you're interested, email me and I'll forward a zip file (4KB).

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com