Subject: | |
From: | |
Reply To: | |
Date: | Thu, 15 Sep 2011 17:14:21 +0000 |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
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
|
|
|