Dennis - Try changing from SUM OF variables to using the DBCalc object. Sami ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Sami Aaron Software Management Specialists 913-915-1971 [EMAIL PROTECTED]
________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Fleming Sent: Friday, August 05, 2005 7:41 AM To: RBG7-L Mailing List Subject: [RBG7-L] - Report breaks and duplicates? RB7.1 Having some problems in trying to get some reports to subtotal properly without duplicating a line (or leaving values blank) when going to a new page. Header and footer page breaks and subtotaling seem to work fine except for a new page. Keep together or not doesn't seem to matter. One pass or two pass setting doesn't seem to make a difference either. Examples: Break_var1 1 Break_var1 23 Break_var2 15 Break_var3 20 or 1 Break_var1 Break_var2 15 Break_var3 20 etc. Any suggestions appreciated. I thought about building a view instead of using SUM OF and do all totaling outside the report since this will make it faster. But I need to get this out the door asap. TIA, Dennis ***** Dennis Fleming IISCO http://www.TheBestCMMS.com <http://www.thebestcmms.com/> Phone: 570 775-7593 Mobile: 570 351-5290
