Report sorting question

[Kenneth Brody]

Quoting Don Coleman (Tue, 14 Feb 2006 15:53:16 -0500):

> 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?
[...]

We would need to know the exact contents of the fields in the selected
records, and the exact output, in order to know what's going on.  (You
could place the sort fields on the detail lines, and mark the detail and
subtotal lines so they can be distinguished in the output.)

--
KenBrody at BestWeb dot net        spamtrap: <g8ymh8uf001 at sneakemail.com>
http://www.hvcomputer.com
http://www.fileProPlus.com