This has been an ongoing issue for years. I use CR Adv 9.0. If I have a report that previously used a stored procedure that I need to use a view or a table or visa versa, I use the Set Datasource Location and re-map the fields. This save time as I don't lose the format on the report and don't have to re-add fields to the report or get errors in formulas etc.
what is annoying is that the sql query and ALL the formulas etc still show as the old location ie oldtablename.field etc. Why does it not update all the fields/references on the report to the new table name? How do I change it?
If I had a issue with performance, I typically take the sql query and run it in sql to see if it's a sql optimization issue or crystal just being slow, but because it doesn't update, I have to manually change the table names to the new ones.
what is annoying is that the sql query and ALL the formulas etc still show as the old location ie oldtablename.field etc. Why does it not update all the fields/references on the report to the new table name? How do I change it?
If I had a issue with performance, I typically take the sql query and run it in sql to see if it's a sql optimization issue or crystal just being slow, but because it doesn't update, I have to manually change the table names to the new ones.