Conditional Totals problem

[Jackie_(Guest)]

I have a very simple report with conditional totals in the summary line which will not return the correct result.____I want to count the number of businesses in any one quarter who have Outcome=^PASSEX^. ____I have grouped by companyno and am totalling with Grand Total - Accumulating on Outcome____The data is grouped on companyno and outcome and sorted on companyno, date and outcome____The total should be 9 but is returning 11____Here is a copy of my results:__ company outcome date___863_PASSEX_24/01/2003___14044_PASSEX_04/03/2003___14835_PASSEX_24/03/2003___23988_PASSEX_05/03/2003___32753_PASSEX_25/03/2003___32753_PASSEX_01/04/2002___58686_PASSEX_21/02/2003___58686_PASSEX_18/02/2003___61506_PASSEX_03/03/2003___62886_PASSEX_19/03/2003___62886_PASSEX_14/03/2003___62886_PASSEX_26/02/2003___63165_PASSEX_19/03/2003______ Qtr 1 1 __ Qtr 2 0 __ Qtr 3 0 __ Qtr 4 11 ____Any asistance would be greatly appreciated____Thanks____Jackie____

[kfleming]

Try accumulating by company rather than outcome and see if that helps.____Kathleen__R&R Support

[Jackie_(Guest)]

Thanks Kathleen____I think I^ve tried every combination and nothing works - what^s even stranger is that when I display the company number in the group header line (using a logical field) it shows the correct number in the record line but doesn^t display all the company numbers in the group header line- only three, and then when I accumulate on company number it also says three. I^ve even simplified the report to a skeleton with no outcomes but it just won^t work. Are there any known bugs with my version (9.0.007) or with ODBC. I^ve been writing reports for years and never come across this.____Many thanks____Jackie

[kfleming]

Is the report based on more than one data table?____Kathleen__R&R Support