Hello!

I need to access the information saved on FM v10 server advance to create reports on Cyrstal Report, but I do not know what to do, can someone help me? Do I need a driver? if I do, where i can find it? How I should I configure that driver?

Depends on what protocols Crystal supports. ODBC? XML? PHP? Server must be set to accept such connections and you will need FileMaker drivers that support Crystal.

Steven

Thank you Old Man Advance for your replay. I am trying to use or configure the ODBC/JDBC that works on Crystal and FM, but I do not know how. For what I had read, it does not work too well. I am using Crystal Report v11 and FM v10 server advance.

Could you tell me which drivers are you talking about? Where I can find them?

Look on Install CD for FileMaker Server 10 to see if there are ODBC drivers from FMI to use with FIleMaker Server. Failing that see if there are generic ODBC drivers from Microsoft or if using MAc OS from Actual Technologies (IIRC).

Steven

I am writing and SQL query in Crystal connecting via ODBC to filemaker database and trying to get a system date and cannot! I am typing something like this;

SELECT Get(CurrentDate), VISITS.Visit_Date
 FROM   VISITS

 

Get an error "Invalid syntax"

get(currentdate) is not a SQL COMMAND

 

What is it that you are trying to do, find all of today's visits?