Replacing exising views with New Views(only views title)

[khan007]

I AM ON CRYSTAL 8.5, WIN 2K, ALSO HAVE ACTIVE X VIEWER.

I am facing some problem with views.

I had designed almost 300 reports in last 3 years based on views, each having 100+ formulas. Working fine.

Now the manager wants to change the views name and came up with new naming convention and want me to replace old views with new one.
I cannot use alias as they will permenantly remove the old views, ones we convert them on all reports.

Please advice me what I suppose to do, rather than going each and every report and change manually each and every formula.

Is there any tool in market to have this functionality.

Thanks In advance.

 

[dgillz]

I believe you can rename the view, then from crystal use database, set location, and point it to the renamed view.

If any field names have changed, you will be prompted to go through a field-to-field mapping process, but this is a one time thing (per report).

Finally, you will have a cosmetic problem in that if you pull up the visual linking expert of the field explorer, you will still see the old name of the view. To solve this do a set alias.

I am 100% sure this works on SQL tables, not quite that sure on views, but give this a try and let me know what happens.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[khan007]

Thanks,

It worked.
Really Appreciated.