SSRS 2008: Count alphanumeric characters in a field

I have a SSRS 2008 report.
I have a textbox that holds the customer name.
If that customer name has more than 50 alphanumeric characters in it, I want to change the font size in that texbox to 6.37pt otherwise i want it to be 6.5pt.
Can this be done and how ?
thayduckProgrammer AnalystAsked:
Who is Participating?
 
markterryCommented:
in the property box for font size, create an expression, which will say =iif(LEN(Fields!dataset.item.value) > 50, "6.37pt", "6.5pt")

I dont actually have the tool open, so I think maybe some of  this syntax is a bit off, like the fields.dataset.value, or the font size. but all the pieces you need are in the expression builder.
0
 
thayduckProgrammer AnalystAuthor Commented:
This is how I am using your solution.
Thanks..

=iif(LEN(Fields!colltype.Value) > 7, "6.37pt", "6.5pt")
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.