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

