Post reply

Multi values in Matrix report field

  • April 9, 2009 at 1:48 pm

    #219910

    Hi,

    I have a matrix report to do that needs to have one or more values displayed in a single field i.e.

    Val1 x

    y

    .

    .

    .

    Val2 z

    How can I do this?

    thanks

  • April 13, 2009 at 6:23 am

    #976498

    try this code!

    =Switch(Fields!Mes.Value = 1,"JAN/" & Parameters!pAno.Value ,Fields!Mes.Value = 2,"FEV/" & Parameters!pAno.Value , Fields!Mes.Value = 3,"MAR/" & Parameters!pAno.Value ,Fields!Mes.Value = 4,"ABR/" & Parameters!pAno.Value ,Fields!Mes.Value = 5,"MAI/" & Parameters!pAno.Value ,

    Fields!Mes.Value = 6,"JUN/" & Parameters!pAno.Value ,Fields!Mes.Value = 7,"JUL/" & Parameters!pAno.Value ,Fields!Mes.Value = 8,"AGO/" & Parameters!pAno.Value ,Fields!Mes.Value = 9,"SET/" & Parameters!pAno.Value ,Fields!Mes.Value = 10,"OUT/" & Parameters!pAno.Value ,

    Fields!Mes.Value = 11,"NOV/" & Parameters!pAno.Value ,Fields!Mes.Value = 12,"DEZ/" & Parameters!pAno.Value )

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

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