• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 578
  • Last Modified:

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!


1 Solution
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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now