Crystal reports and Filemaker Pro

May 7, 200124 yr

Newbies

Hi,

I'm trying to connect 2 filemaker Pro files within Crystal Reports. The wizard in Crystal works fine with ODBC, but when the program must refresh the data it give a fault.

Printing one table in Crystal works fine.

Is there someone who has the same problem and maybe has a solution.

Thanks ,

Diederd Loysch

May 8, 200124 yr

What version of Crystal reports are you using?, and what is the error message or number returned?

May 9, 200124 yr

Author
Newbies

I'm using Crystal reports 8.0.1 (crw32 8.0.0.371)

The fault I had was : ODBC error [Filemaker][ODBC filemaker Pro] extra characters at end of query:INNER

Error detected in database dll

Best regards ,

Dieder

May 15, 200124 yr

Newbies

Hey there Diederd.

For the INNER query error, look at the SQL generated by Crystal. You'll most likely find a problem with a field name.

If you have the choice, I wouldn't use Crystal and FMP. The FMP ODBC is painfully slow and once you get over 1000 records, you are really pushing the drivers. I tried to go this route, and I was providing a dis-service to my users.