(Reply) old data/archive records

[Jeff Harrison]

Butch Ammon wrote:
[snip]
> 
> No, we're just using standard everyday automatic indexes.  
> When running a cost 
> report from "oldorder" using Request Output, it still reads 
> the 82,000 some odd 
> records.  It's okay and runs great, but, well, you know how 
> some people can be. 
> They want things NOW.
> 

Butch, do you have an index on order date?  If so, and you wish your report
to only look at orders after a certain date, then this is very easy to
implement - even without the lookup - method.  All you need to do is use a
simple selection set, and make sure that PFIXS=ON is in your config file or
your environment.

Jeff Harrison
jeff.harrison at epixweb.com

Author of JHExport and JHImport - The fastest and easiest ways to generate
code for filepro exports and imports.  Demos available upon request.