Report sorting question

Tue Feb 14 12:53:16 PST 2006

I have a report with no detail lines, and 4 sub-total sections.  Three
records are selected to be printed.  The sub-total fields are as follows
from left to right

Print_Dest	Sort_Order		Total_Qty_Req	NDC (National Drug
Code)

I am only printing data in the 4th sub-total field.  The report is limited
to printing only 5 drugs via an internal counter.  The three records
selected are identical except for the Sort_Order.  Two of the records have a
Sort_Order of "A" and the last is "B".  If I run the report and let it
select the "top 5" items it prints as expected.  However, if I limit the
selection via an open selection to select only 1 drug (the 3 afore-mentioned
records) I get two lines printed instead of 1.  If I put the record # field
on the report I get one line with the two records w/ the Sort_order of "A"
and the second line is the record with the Sort_Order of "B".  Is this
behavior to be expected because of the different Sort_Order of the 3rd
record?  Is there a way around this?

The report is a picklist showing the top 5 most needed drugs on
prescriptions waiting to be filled.  So I need them sorted by Printer_Dest
(where the drug is located), Sort_Order(priority determined by when this
customer's order must leave the building, Total_Qty_Req (by filling which
drug can I fill the most Rx's, and by NDC (the drug identifier).  Once this
list is printed I have a process set up via *clerk which automatically
prints all the Rx labels for that particular NDC.  Thank you in advance.

Don Coleman
Donald G. Coleman, Consultant
402 Andrew Circle
Indiana, PA 15701
dcoleman at dgcreact.com
(724) 349-6302