Conditional Formating in Reporting Services 2005

  • Hello,

    I have a problem formating a line in a diagram in SSRS 2005. I want to change the color of the line depending on a value on the x-axis.

    I always get an exception that the bordercolor expression for the diagram Object 'Bestandsentwicklung.DataPoint' contains an error. The entry string has the wrong format.

    The function is the following:

    =IIF(Parameters!CurrentWeek.Value.ToString > cdbl(Fields!DimZeit_WocheTag_Woche_MEMBER_KEY.Value.ToString),"Firebrick","Blue")

    whereby the parameter currentweek should return a number and the field DimZeit_WocheTag_Woche_MEMBER_KEY, too.

    Can anyone help me? How do I have to convert the values to solve the problem?

    Stefan


    Kindest Regards,

    SK

  • remove the .ToString (s)

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg
  • Hi,

    I experienced this problem in another diagram and could solve it by converting the parameter to a string first and then to a number. Of course this is crazy, but it worked.

    I tried it without the ToString. It doesn't work.

    Stefan


    Kindest Regards,

    SK

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

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