July 16, 2008 at 9:17 am
Hello.
I have a dataset which consists of a field called Salesperson among others. I am using this dataset successfully in a table in the report. I would like to add to the report, a table which summarizes data in which the Salesperson value is "Unassigned". I thought that a table filter would be the way to go so I added a filter like this:
Expression: =Fields!Salesperson.Value
Operator: =
Value: Unassigned
No data comes through in the table so I guess that the filter is blocking all of it. I know that there is data in the table that fullfills this condition. What am I doing wrong?
Thank you for any help you can give.
July 16, 2008 at 9:25 am
I know that this makes absolutely no sense since you already defined the operator as "=" but you need to set your value to "=Unassigned"
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 16, 2008 at 9:53 am
Thank you for your reply. Unfortunately it didn't work. I decided to include the empid in the dataset and filter on that and now it is working. ="Unassigned" is not matching exactly with any values. Maybe there is a space in the dataset value somewhere. I'm not sure. Is there a "like" operator in reporting services expression that I could have used?
Thanks.
July 16, 2008 at 9:58 am
Yes there is a Like. You also need to match case so you should use a .ToUpper() when matching strings.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 16, 2008 at 10:03 am
Thank you very much for your quick and helpful replies. I'm set.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply