No problem! No you don't "need" an Order By clause if you have your breaks set up in the manner you want them. There is nothing to be gained by having an order by, and it might possibly slow the report down since you're essentially sorting it twice by the same columns!
And yes, unfortunately, if you wanted the same report sorted a different way, you would have to have another report. In that other report you would have to change the breaks to match how you want the other sorting. Since we now have the ability to use PROPERTY commands in reports, I wouldn't be surprised if someday in the future we would have the ability to change report breaks on the fly ... Wouldn't that be nice?? Your break and order are identical the way you have them > Hi Karen > > So do you need an Order by clause ? Does it help? > > If you want to have the same report but Order it by custnum or Lastname ... > do you > have to have 2 different reports? > > In Reports the Break points are 0 custnum, 1 trdate, 2 treatdr > so is that the same as Order by custnum, trdate, treatdr or reverse > > Sorry for such basic questions > > Thanks > Marc >
