SSRS Not Letting Me Filter


Attached is a very simple subreport.  I can't believe that SSRS is not letting me conduct a basic filter.

I have a field in the report called "AvailQty" (i.e. the available quantity).  I simply want to filter it to say that this field has to be > 0.

But, SSRS gives me an error saying that "FilterProcessing cannot be performed".  And, in the same message it tells me to check "System.Decimals" or something that I've never heard of before.

Sigh....I don't understand how the developers of this app expected people to get work done Every time I turn around, a new undecipherable error comes up.

Please help!


Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Correct.  Once the report is generated, SSRS does not have a 'Filter by Form' capacity like Excel does.  The only way to pull this off within just SSRS is to expose a parameter that handles the 'AvailQty > 0', and gets passed to the data source, and that SP/? handles it in the calculation of the set that gets returned.  So, you'd have to re-execute the report.

The one client I had that demanded this capability, we had an extremely good .NET developer that figured out how to have the combo boxes on a page, with the SSRS .rdl as a frame, and handled the maniuplation in the .NET page.  Still re-executed the report, but the UI made it appear that it was dynamic.

Good luck.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.