RBase is simply counting the rows it reads through. You will need to count the information in a different fashion. In the footer
Col1_AggregateTotal = (COUNT(Col1)) IN <table> WHERE <break point criteria> So if you need to know how many OverTime's there are in Employee where EmplNum and Date then: vOverTimeCount = (COUNT(OverTime)) IN Employee WHERE EmplNum = EmplNum and DateCol = DateCol. "Bill Eyring" <[EMAIL PROTECTED]> wrote: >I have recently had the need to create a report with multiple aggregate >report variables using the count function. I am working with Rbase for >Windows 6.5++ build 1.851xRT03. > >The first column in the report all have not null values. The succeeding >columns may or may not have values. Logically then you would expect that the >aggregate count variables at the end of the report would have different sums >for each column since the count function is supposed to include only not >null values. That, however, is not the case. The sum of each variable is the >same as the largest aggregate variable sum. > >In my report I defined each aggregate variable by choosing Variables,Create >Aggregate Variables,Select column Name,Select function(Count) and then add. >Each aggregate variable is based on a different column. I then placed each >aggregate variable in the report footer underneath each column. When you >check Variable,Change Section each variable is calculated on the Detail >section. > >The report has only 3 sections - ReportHeader,Detail and ReportFooter. > >There are no break headers or footers in the report. The SHOW CHAR command >at the R> prompt shows; >Quotes= ' >Plus= + >Single= _ >Many= % >IDQuotes=` > >The settings for ANSI,ZERO or Null does not change the result of the >aggregate variables. > >Here is an example: > > IdNum Col2 Col3 Col4 Col5 > X X X > X X X X > X X X > X X > X X X > >Totals 5 5 5 5 5 > >The correct totals should be; > 5 3 1 4 2 > >I have reported this to Rbase Technical Support and they were good enough to >suggest a workaround. > >Can anyone replicate this problem or suggest an answer to this problem ? > >Thanks, > >Bill Eyring >Director of Information Systems >Michael Haberman Associates, Inc. >125 Front Street, Mineola, N.Y. 11501 >516-739-8080 >Rbase Developer > >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l >================================================ >TO SEARCH ARCHIVES: >http://www.mail-archive.com/rbase-l%40sonetmail.com/ > -- __________________________________________________________________ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
