April 7, 2007 at 9:30 am
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
SK
April 7, 2007 at 10:34 am
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. SelburgApril 7, 2007 at 10:40 am
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
SK
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply