CR 10 exporting to DBF

[Seabz420]

I have a basic report that returns addresses of members. The result needs to export to dBase so another program can run against the results. This use to work in CR 8.5 but now I get an error:

Failed to export the report.
[Microsoft][ODBC dBase Driver] Field 'DE_MADDR_AD2' already exists in table 'MAR1'.

MADDR_AD2 is a field in the CR report (but only appears once). MAR1 is the table I'm tring to export (does not exist..built when export runs).

I'm not sure why in 8.5 this works but in 10 it doesn't. Ideas?

 

[synapsevampire]

Try exporting the report to Report Definition format and see if it thinks that it's in there twice.

Otherwise, delete the field from the report, and then put it back in.

-k

 

[Seabz420]

I'll give that a try to see if it helps. I'm going to take a closer look at that export to Report Definition just to see what type of info it has. In the mean time, I just created a formula field that displays the same info as the database field. It worked, but I still want to know why it didn't work originally! Thanks for your advice! (as usual!)