Exporting Duplicate Fieldnames

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
Chris_Barnes
Posts: 25
Joined: Tue Oct 10, 2017 12:44 pm

Exporting Duplicate Fieldnames

Post by Chris_Barnes » Tue Nov 25, 2003 1:13 pm

[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

Nick
Posts: 103
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Exporting Duplicate Fieldnames

Post by Nick » Tue Nov 25, 2003 5:24 pm

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____

Chris_Barnes
Posts: 25
Joined: Tue Oct 10, 2017 12:44 pm

==> RE: Exporting Duplicate Fieldnames

Post by Chris_Barnes » Wed Nov 26, 2003 5:03 am

Thanks!!! :)

Post Reply