Can they not index their date fields?

Assuming the answer is no; mirror the data to your own table that you have control over. Import the whole kit and caboodle, then you have all sweet and tasty FileMaker goodness.

Geoff

> -----Original Message-----
> From: FileMaker Pro Discussions [mailto:FMPRO-
> [log in to unmask]] On Behalf Of Jason Bourque
> Sent: Thursday, September 15, 2011 12:24 PM
> To: [log in to unmask]
> Subject: How do I create reports with FMP SQL server data,
> 
> Hello,
> 
> I am tasked with building some sales/promotions reports with GP great plains
> data in an external SQL source.
> 
> I cannot do date range searches as it grinds to a halt. 1/1/2011...1/31/2011
> 
> I tried adding two calculations, date month and then year. Then use them to
> do the range search
> 
> Should I use Queries to populate a second FMP data only table then report
> on it?  If so how is this done?
> 
> Any guidance on the would be greatly appreciated.
> 
> Thank you,
> Jason Bourque
> Sent from my iPhone