Set datasource location to Command Object 1

[quinn23]

Good day all
I've created a report with Crystal XI going against an Oracle 10 db. I access the data through the 'Oracle Server' option in the datasources. During the report development I needed to chart against an aggregate formula which drillable charts wouldn't allow me to use. To get around the issue I created a command object with all the same fields in the report and my formula. All this works great and the chart is working correctly. However rather than keep the report the way I have it I would like to point all fields on the report to the command object. I haven't found a way to use the 'Set datasource location' to point all my existing fields to the new command object. The command object has the same fields I just don't know how to re-map all the existing fields to my command object. Is this possible or do I need to re-create the report?
Thanks in advance

 

[IanWaterman]

YOu will need to select a table which has the most fields in use to map the command too. This will open a field mapping window again link as many fields as possible.

All the other fields from other tables will be lost, you will then need to introduce them back into the report.

Whilst this is not quick, its quicker than building report from scratch. Watch out for groups and make sure you reset group and selection statement before running. I have known reports to become corrupted if you don't do this. Just to be safe save report with a new name so you can always go back to original if it all goes horribly wrong.

Ian

 

[quinn23]

Thanks IanWaterman