Yep, your "order by" clause should NEVER be in a different order than the 
breaks you have defined in the report.   If you have extra columns mentioned in 
your Order By clause, just define them as additional breaks.

Karen

 
> I just found a possible bug in my code.  I have a report with 2 break 
> points and
>  my Print statement Order by clause had 3 columns.  I noticed that I would 
> get
>  a different number of pages printed depending when I deleted the Order by
>  clause.
>   
>  Am I correct in  understanding that if you have Break points in a report 
> you
>  do not need an Order by clause on the Print statement or at least you 
> should
>  have the Order by match the Break points?
>   
>  I have some reports that do account aging that I need breat points for 
> Custnum
>  but I let the user Order the report by other columns.....I guess this will 
> come back
>  and bite me one day....Correct?
> 
   

Reply via email to