you suppress sections (a row is usually a detail section) by going into the section expert and selecting the formula (x-2) button next to the 'Suppress (no Drill down)' option.
you add a boolean evaluation formula, true results in suppressed and false results in show.
i assume you have a primary key per 'pay row' and if you placed that field on your report canvas it would duplicate on your 'doubled rows'.
if that is correct you will use something like
not onfirstrecord and previous(table.id)=table.id.
Running Totals have to be placed in detail sections or footers. If you place them in headers they will not calculate any rows below the first row in the grouping that you placed it on.
perhaps that explains your total?
if not I would need to see some sample row level data and how you want it calculated to help much more.
Edited by DBlank - 09 Aug 2012 at 9:27am
IP Logged
