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

[Marc]

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

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


  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?