[RBG7-L] - Report breaks and duplicates?

[Dennis Fleming]

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

Phone: 570 775-7593

Mobile: 570 351-5290