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