Print Page | Close Window

Field remapping

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=13068
Printed Date: 05 May 2024 at 6:55am


Topic: Field remapping
Posted By: DCrum
Subject: Field remapping
Date Posted: 29 Apr 2011 at 11:58am

I have a report that was created using the wizard to construct the database fields.  The report grew more complex and required me to rewrite the query using the Command.  I aliased all the columns the same and would like to know if there is a way to remap the old Fields from ( Field."TABLENAME"."COLUMNNAME" ) to ( Field.Command.ColumnName )

 
Thanks


Replies:
Posted By: hilfy
Date Posted: 02 May 2011 at 8:51am
Unfortunately, moving from tables to a command is not quite the same as changing the individual tables.  So, there is no simple way to remap the fields on the report from one to the other.  I suggest that you don't delete the tables immediately after adding the command.  Instead, use the table fields as a key to where the command fields are supposed to go, then edit all of your formulas prior to deleting the tables.  Then, when you run the report for the first time, Crystal will let you know whether you've missed any mappings in formulas and bring them up for you to edit while it's trying to run.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window