Jump to content

Crystal Reports & FileMaker


Ted S
 Share

This topic is 6586 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hello,

Crystal to FileMaker newbie here. I'm trying to build a report using Crystal from data in FileMaker. Crystal wants me to enter a sql statement but I don't know the syntax and can't find it anywhere. My FileMaker file is called InstBase.FP5 and in that file is a field called Model.

I would guess that the sql would be like:

SELECT Model FROM InstBase.FP5

but that doesn't work. I've tried dropping the file extension, surrounding the file and field names with quotes, adding a semicolon to end the statement etc.

Can somebody help a dope like me write this statement. Just pulling one field from one file?

Thanks,

-Ted

Link to comment
Share on other sites

False alarm. I got it to work. I just didn't have the background stuff set up yet - sharing & all that. In fact, I don't think I needed the SQL at all.

The bad news is that it took about 2 minutes to pull down 1000 records. Yikes!

-Ted

Link to comment
Share on other sites

This topic is 6586 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.