Change to a SQL Union Query

[brek2]

I am using Crystal 8.5 with a SQL 2000 database. I have two Crystal reports that use a union query. I have a new report that needs two new fields added to that union query.

If I add two new fields and rename the union query, how will that affect the existing reports?
Does Crystal automatically update the existing reports with the query changes?
Will I need to change the existing reports to use the new query?
Or should I just build a new union query for the new report?

Thanks in advance for your help.

 

[brek2]

I should probably add that the union query is in the SQL Server database as a view.

Thanks.

 

[dbpr]

I don't understand why you need to rename the View.

Crystal by default will not reprocess the query and after digesting it will use ordinal numbers for the columns for speed.

When a table or view changes you should run "Verify Database" from the database menu. If you are running the the report programatically then run the Verify method on the Database object for each report and subreport.

To answer more directly:
1)Add the fields to end of the view so the columns ordinals do not change,otherwise you will have to reverify all existing reports.
2)No, need to use Verify Database
3)No if you append fields only
4)No need, but its up to you

Hope this helps