export report to excel - field name

[LVA]

I am using filemaker pro 5 and I need to export a filemaker report to excel using DBF format. When I do so , the field names don't appear as they are on the files. When the fields are from a related file after exported to excel they have the relationship name. How can I garantee that the name in excel will be the fields name like in filemaker or how can I change the name and choose what name I want to be written in excel ?

Luiza

[danjacoby]

How about exporting the records from the related file?

[LVA]

The report I have to export has fields from the same file where the report layout is and another file. So I would have the same problem if I made the report using a different file.

But the problem isn't the file where the report is. The problem is the layout field when exported to excel as I explained before.

Anyway , thanks.

Luiza

[IdealData]

Consider building your report by making a new FM database which will have the values from the other files by doing some imports.

Then make your report in the new file and do your DBF export.

The file names will no longer be related, and you might want to take the opportunity to use different names in the new file.

[IdealData]

...alternatively

For the related fields that cause the problem substitute them with calculated fields in the main file. The calculations are, of course, the related fields in the related file.

It's a bit of extra storage, but it won't worry FMP.

[danjacoby]

The problem is that you're trying to export related data.

If it's a one-to-one relationship, you should just include the "related" data in the main file.

If it's a one-to-many relationship, you can create a relationship in the related file, then create records in the related file which show the data from the main file, and export all the data directly from the related file. That way, all the field names will export.

If it's a many-to-one relationship, just create calc fields in the main file that show the data from the related file.

[LVA]

Thanks to you all !

I managed to do it by creating calculation fields (with the names I wanted to be printed on the report). These calculated fields recieved data from the fields I needed on the report. Then I exported these new calculated fields to excel . In my solution it would be better to create fields instead of creating another file.

luiza