[RBASE-L] - Re: Printing reports break points Order by

[Marc]

Thanks Karen

I could understand that your break Totals might be off but this office
says they are getting 2 different pages printed for the same custnum
and all I can think of is Index problems or my goofy breaks / Order by
thing,

Marc

  ----- Original Message ----- 
  From: [EMAIL PROTECTED] 
  To: RBASE-L Mailing List 
  Sent: Thursday, June 19, 2008 1:32 PM
  Subject: [RBASE-L] - Re: Printing reports break points Order by


  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