The bug was fixed in the late releases of 6.5. It was a combination of break point + footers. The solution (which can even speed up some reports) is to not use the SUM OF syntax.
In the footer, identify the where clause that would return all rows in the group. Then create a variable, placed in the footer, calculated in the footer (Variables > Change Section) such as this: F1_TotalSomething = (SUM(Something)) FROM <the table> WHERE <where ...> [EMAIL PROTECTED] wrote: >Bob, > >There was a bug in early versions where if the total fell at the page >break (I think... it has something to do w/ the page break <g>) the >sum would be incorrect. I haven't tested 6.5 to see if it still holds >true. > >Ben > > >On 19 Feb 2004 at 8:45, Thompson Technology Consultants wrote: > >> 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 >> > > -- Albert Berry Full Time Consultant to PSD Solutions 350 West Hubbard, Suite 210 Chicago, IL 60610 312-828-9253 Ext. 32 __________________________________________________________________ Introducing the New Netscape Internet Service. Only $9.95 a month -- Sign up today at http://isp.netscape.com/register Netscape. Just the Net You Need.
