Filter Chart Series on Report Manager SSRS - won't always work

[shancherie]

This is my first time ever posting to a forum... bear with me!

I created a report in .NET with a chart. It's pretty snappy, I must say. The report is based on number of clients by city for multiple agencies (agency is a report parameter). The dataset this info comes from is also used for a table, so the filter cannot be added there. The filter is in place on the pie chart's series, for cities where the percentage of clients is 1.5% or greater - I don't want cities with less than 1.5% included (the pie chart disintigrates into black lines and the legend is unreadable).

Grouping and Sorting Properties -- Filter for the series:
=(Fields!Client_Count.Value/Sum(Fields!Client_Count.Value, "GridMax"))*100 >= =1.5

It works fine in .NET - every time. When I upload to Report Manager (SSRS), it runs once perfectly - filter in place. When you "view report" again (whether or not you change parameters), the filter is not utilized and the pie chart is unreadable. You can keep clicking "view report" and one time the filter will be in place, the fourth time it won't. I have not been able to determine a pattern for when it runs through the filter... it is not every other time. It is not always the first time that it works. I have found nothing in MANY searches online that reference this problem.

Any ideas?

 

[RiverGuy]

I'm not sure, but have you tried a more generic filter on the chart to replicate the behavior? For example, pick your largest slice in the pie and apply a filter so that one is omitted. Then check and see if it comes back on subsequent renders. This would narrow it down to your particular filter expression or the chart/ssrs implementation itself.

 

[xlbo]

Not sure why it would run once ok and then not again but:

=(Fields!Client_Count.Value/Sum(Fields!Client_Count.Value, "GridMax"))*100 >= =1.5

should really be:

=(Fields!Client_Count.Value/Sum(Fields!Client_Count.Value, "GridMax"))*100 >= 1.5

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[shancherie]

RiverGuy - I'll test a couple other filter options and see if the same thing happens...

xlbo - the extra = sign is not actually part of the Operator or Expression fields, it is for the Value column in the filter grid. Without it, the filter won't work at all.

Thanks for your responses!