Prob exporting to XL-missing fields

[Henneman]

I have a fairly simple report that pulls data from a primary table and is linked to six additional tables to lookup the translated code values for six different fields. Although there are six relationships specified, there are really only two tables -- one is linked 4 times, the other is linked twice, each obviously using different aliases.____The report in question was redesigned from a paper-based report, moving all of the needed fields onto a single "record" band in order to facilitate an export to Excel. Here^s the problem... when exporting to Excel, it essentially ignores the links and the fields to all but the first instance of each of the two files. I can preview it to the screen, print it or even send it to a text file, and all appears well. However, when sending it to Excel or to dBase, it refuses to "see" the other links and it does not output the description fields from the linked tables.____I^m sure hoping someone has some bright insights here! Thanks!

[kfleming]

If the same field name is on the layout from a different table, R&R will only export the first instance. So if you have the field ABC in tableA and tableB and have tableA->ABC and tableB->ABC on the layout, only ABC from tableA will be exported. To work around this you need to create a calculated field for the second instance. In this case I would create a calculated field called B_ABC with the expression tableB->ABC and place it on the layout in place of tableB->ABC. So the export would contain ABC (the ABC field from tableA) and B_ABC (the ABC field from tableB.)____Kathleen__R&R Support

[Henneman]

Kathleen, many thanks, worked like a charm.