In WebI XI/R2 I have a table turned into a cross-tab. There are sums added both at the bottom of the columns and across the rows, so a final column named Sums exists to the right of the table. It appears to be part of the table, but the alternate color selection for the rows doesnt carry through that column of sums, not does it carry through the bottom if the row of Sums is in the alternate color position. Is there a way to change that?
Thanks
Once you turn a table into a cross-tab and add the summarizations, the newly appended rows default to an all-white background. When dealing with the block and you go to properties, under the heading “Alternate Row/Column Colors” appear, where you can control the number to alternate rows and contrasting color, however, any changes that you apply only affects the basic block, not the appended columns that are coming in as a result of the summing. You may want to submit a tech support request on this item (if not for anything else but the establishment of an ADAPT). BO may claim this as a “feature”, however, I for one would also like more flexibility. What we do for our reports is either leave the background in the default white, or we give the background its own color (usually something pale with bold font…)
Yes, you actually can do alternate fill colors on the sum column. You have to create a conditional formatting rule that has the function =Mod(LineNumber();2)=1 and if that puts the shaded color on the wrong line, then use =Mod(LineNumber();2)=0. The above is to do every other line shaded/formatted.
To do every 3rd line, change the Mod number to what fits what you are looking for. Apply the conditional formatting to your Sum column(s).
(BOB member since 2007-09-27)