Page 1 of 1
Exporting Duplicate Fieldnames
Posted: Tue Nov 25, 2003 1:13 pm
by Chris_Barnes
[updated:LAST EDITED ON Nov-25-03 AT 01:13 PM (EST)]Hi,____One of our clients is trying to export a report from R&R10 to excel. The report has 2 instances of a field called ADDRLINE_1 from two different tables, but the report is only exporting one of these. Is there anything we can change on the report to stop this happening?____Regards____Chris
=> RE: Exporting Duplicate Fieldnames
Posted: Tue Nov 25, 2003 5:24 pm
by Nick
create an RR calculated field with a different name and put that calc field in the line that is being exported to Excel. That calc field replaces the SECOND field that had a duplicate name.____example: record line with FIELD1 and FIELD1 again - gets changed to a record line with FIELD1 and FIELD1X - where the calc field FIELD1X contains the expression FIELD1.____export to DBF also works the same way - and has the same workaround.____nick____
==> RE: Exporting Duplicate Fieldnames
Posted: Wed Nov 26, 2003 5:03 am
by Chris_Barnes
Thanks!!! :)