none
Dynamic labelling for Y Axis in a Chart report RRS feed

  • Question

  • I'm creating a report to display the time trend for projects going through different stages.

     

    The requirement is to display time in X axis and project stages in Y axis. However, apparently it's only number supported in Y axis. Though I can do some expression, but either it's repeating a same text lable or it has some funny behaviour.

     

    Expressions I have tried:

     

    1. IIF(Fields!StageID.Value = 1, "Inception", IIF(Fields!StageID.Value = 2, "Definition", "Delivery"))

     

    This will display all "Inception" in the Y axis.

     

    2. "Inception;Definition;Delivery;Completion;Closure". This will display "Defintion" in 0 position, Delivery in 1 and above.

     

    Any advice will be greatly appreciated.

     

    Thank in advance.

     

    Guoming

     

    Wednesday, May 30, 2007 10:10 AM