Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Set datasource location to Command Object 1

Status
Not open for further replies.

quinn23

IS-IT--Management
Jan 4, 2002
29
US
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top