'Crystal Report 2008 swap data table for identical differently-named table

I have a Crystal Report that gets its data from a SQL Server view. The users want the view to be able to get data from a particular start/end date range which means the view needs parameters passed to it.

I have put the view's query into a SQL Server stored procedure with parameters.

I was able to get the Crystal Report in question to use that SP as part of its data and it prompts for the start/end dates just fine.

I have gone through the formula fields and was able to modify the formulas to point to the corresponding fields in the SP's data in stead of the view.

I need to somehow get the fields that are displaying in the details section of the report and other areas to utilize data from the new SP and not from the view.

I'd like to modify each control and field on the Crystal Report layout to somehow change the tablename of those fields from (CurrentTableName).(FieldName) to (NEWTableName).(FieldName). I think this would be the least intrusive because I think some of the fields being used have formatting and other attributes added to them and I don't want to do a whole bunch of detective work.

I know in other development products there is usually a properties window where you can find the TableName.FieldName for an object in the report and you can just edit it to be NEWTableName.FieldName.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source