Greetings

I am trying to develop a report which identifies clients' spend with us in 2007 (so as to identify who we must send Xmas gifts to)... I have created a sub-summary report which sorts by "Year as No.", then by "Client Code" and then sub-summary by sub-total of invoices.

How can I then perform a search for clients who have spent more than x? It appears as though my GetSummary field is unsearchable which makes sense to me... I just need to find out if there is any way to either find all clients with a spend of more than x or if I can at least sort the records to identify the top 10...

Any help would be great!

Many thanks!

Can you sort on the GetSummary field?

monsta is aware of that when writing:

It appears as though my GetSummary field is unsearchable which makes sense to me.

I would here seek rescue under this algorithm:

http://www.onegasoft.com/tools/fastsummaries/index.shtml

Where you then only tag a few records with a summary value, in which the search is made. Just remember to include some kind of housekeeping to remove the tags again after establishing the needed facts, before the script ends!

Tagging however is in any form, is not multi user so in the end will the only correct way of accomplishing the matter by stuffing a global field with Fast Summary data, testing each established summary value against the requirement stored in say a script parameter:

http://www.kevinfrank.com/download/kf-fast-summary.zip

--sd