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.




    Wednesday, May 30, 2007 10:10 AM