can i make a font style on matrix subtotal different from one in cells?

• maya potiyevskaya

  SSCrazy

  Points: 2091

  More actions

  November 20, 2007 at 9:19 am

  #200640

  Hi Experts,

  you know how when you use table as your report region and can change the subtotal row to be different? maybe, bold, different color and such.

  guess what? when you add subtotal for matrix control, it inherrits the same font you use in regular matrix row.

  would it be possible to make this subtotal row in matrix region look more distinct? maybe, adding some programming code? or, it cannot be done at all?

  thanks in advance to All for your help.

• maya potiyevskaya

  SSCrazy

  Points: 2091

  More actions

  November 20, 2007 at 10:47 am

  #752812

  Hi,

  i think i figured it out myself and want to share. use InScope function. for example:

  =iif(InScope("group_product"), "Transparent", "LightGrey")

  that's assuming we have a group by row called "group_product". this will highlight the bottom row for subtotal.

  this logic can be applied for anything, it's pretty nice.

  thanks!

• Kevin Mao-243787

  SSChasing Mays

  Points: 602

  More actions

  November 20, 2007 at 12:15 pm

  #752847

  Great, I am looking for that. Thanks for sharing.