Report sorting question

[Jeff Harrison]

--- Jeff Harrison <jeffaharrison at yahoo.com> wrote:

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

Actually I just realized that I got my terminology
wrong on the break #s.  The fourth sort (Drug Code) is
actually break #1, and the second sort (sort_order) is
break #3 in this case.


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