Report sorting question

[Jeff Harrison]

--- Kenneth Brody <kenbrody at bestweb.net> wrote:

> 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.)
> 
> --

The way I interpret the data given is that he has 4
levels of breaks - the 3 records in question have one
of two different values for the second break (Sort
order either "A" or "B").  The question was, if all of
the other breaks have the same data, then "Is it to be
expected that at the 4th break you would get 2 lines?"
 I think that the answer to that is yes.  This is how
the breaks work.  If you don't want this, then I don't
think that you want the 2nd break.

Jeff Harrison
jeffaharrison at yahoo.com

Author of JHExport and JHImport.  The easiest and
fastest ways to generate code for filePro exports and
imports.



__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com