April 9, 2009 at 8:38 pm
For some reason, I am unable to get the filter functionality to work properly. I have 4 teams(categories) labeled as A, B, C, D. Then I have the values being represented in the chart are points.
I go to Chart Properties and then the Data tab. I go to category and select Edit and then to Filters.
Here I select
Expression as =Fields!Team.Value
Operator as =
Value as A
I want to make a pie graph of just Team A against the whole. When I use the settings above, the graph does not even show. If I take out the filter, the graph shows all 4 teams broken out in the graph based on points.
I hope this makes sense. If not, let me know and I can try to explain this a little better.
Thank you in advance,
Bob
April 13, 2009 at 5:56 am
I believe you need to set the value to be an expression like this:
="A"
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
April 13, 2009 at 6:03 am
Hello Jack,
Yes, I did some research online over the weekend and I came across that suggestion. I tried the following:
A
"A"
=A
="A"
None of which worked, but when I ran the query to see the results, there were 4 rows returned A, B, C, D. So I do know there are Fields!Team.Value = A exists. I am not sure what the difference between the filter on the Chart properties and the filter on the Category properties, but I have tried both locations and the when the filter is added, the graph just does not show (like that value doesn't exist).
Any other ideas that I can try? I am still looking into it myself, but I have yet to find the answer.
Thank you for the reply.
April 13, 2009 at 6:48 pm
After countless hours of troubleshooting, I found the problem that caused the filtering not to work. The table that I was accessing that stored the team name (in this case A) had been designed to store the name in nchar(10), which caused my team name to be A with 9 trailing spaces.
Thank you for your help anyways....my bad.
Bob
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply