SSRS Newbie here.
Using SQL 2008 R2
I need to examine a report tablix cell and, if it begins with a certain text, say "xyz:" I need to change the background color of that cell and peel off the letters "xyz:".
So if the data was "xyz:Michigan" the report would show the word "Michigan" with a green background.
I know I can go into the textbox proprties fill property and do something like:
=Iif(ReportItems!State like "xyz:", "Green", "No Color")
So, for color changing the cell background, the problem is of course that SSRS doesn't like the "like" operator. What can I use in its place?
I'm not even sure where to begin on removing the "xyz:". Any ideas from our SSRS experts?
As a follow-up, does anyone have a good link to SSRS Expression examples? I've tried the one in MSDN (http://msdn.microsoft.com/en-us/library/ms157328.aspx
) and while it has some good examples, none that really help me here.
Thanks in advance.