Bob - Also check the fields listed in your break levels and compare them to the list of columns after the ORDER BY clause. If they are different, then that could be causing it to sort differently than the break levels - and might have some affect on the results.
If the columns in the break grouping are the same as in the order by grouping, omit the order by when you print the reports - it's just redundant and may slow down printing. The breakpoints force the sort order. If you need to sort by a DESC sequence or by additional columns at the detail level on the detail report, you can either add those columns in as additional break levels (without placing those sections on the report) or you can add them to an ORDER BY clause - as long as your ORDER BY clause begins with the same breakpoint columns first listed in the same relative order as in the breakpoint list. Sami ----------------------------------------------------------------- Sami Aaron Software Management Specialists 19312 W 63rd Terr Shawnee KS 66218 mailto:[EMAIL PROTECTED] 913-915-1971 ----- Original Message ----- From: "Thompson Technology Consultants" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, February 19, 2004 8:45 AM Subject: [RBASE-L] - Report problem > Would someone please verify my logic in regards to a report problem > > I have created a detail report and a summary report. The detail report > lists individual transactions by department and grouped by type. > The summary report shows only the department totals. > > To create the summary report, I simply took the detail report and > made the detail lines invisible. When running the report it looks > fine, just the way I want it to. > > However, using the exact same where / order by clause, the detail report > will occasionally give a different department total than the summary report. > For example, the reports show department totals for 15 departments. > On the detail report, 3 departments show a different total than on > the summary report. Again the only difference between the two reports > is making the detail lines invisible. > > Has any one experienced this and is it not a valid method to produce > a summary report by making detail lines invisible? > > Thank you, > -Bob > > > > Thompson Technology Consultants > 276 Chippewa > LaPorte, IN 46350 > 219-324-2605 (Phone & Fax) > 219-363-7441 (Cell) > http://ttc.inc.home.comcast.net > > > >
