Changing a Table/View (Source)
Posted on 2011-03-25
I'm using Crystal XI
I built a report using a view that I created in SQL Server. Now, while Version 1 is being used, I need to modify the view enough that it would affect the original report. So, I need to create a version 2. But there is enough of version one that will remain that I'd like to just make a new copy of the report and point the data source to the version 2 view (rather than rebuild the report).
All the field names will be exactly the same, just the view name will change.
I thought I could do it through "Set Database Location", but selecting the old view name (vwMyView_v1) under "Current Data Source" and selecting the new view (vwMyView_v2) under "Replace With", then clicking "Update" has no effect.
How do I change the table/view source?