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

  • 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.

  • 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!

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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply