Multiple Subtotals - lose subtotal row formatting
744011Jan 2 2010 — edited Jan 14 2010I have 3 subtotals on the same group break. If I show only one of the 3 subtotals, I continue to have formatting for all columns on the subtotal rows based on the formatting of the subtotal I'm showing. If I add any one or both of the other subtotals to the sheet, I lose formatting on the other columns that do not contain the subtotal.
For example, all my detail rows are white background with black text and my subtotal row should have dark gray background with white text. This works great with one subtotal. If I add the other subtotals, on the subtotal row, the cells that have a subtotal are formatted dark gray background with white text, but the other cells (not subtotaled columns) become white.
How can I force it to show the dark gray background for all cells in the row without creating a subtotal for each column?
I'm using Discoverer Plus 10g (10.1.2.55.26) and I've tried editing in Discoverer Desktop without any luck either.
Regards,
Emily