Bypass a report filter
-
Is there a way to "skip over" a filter? I have a date range parameter and one other parameter. There is also a filter on the report. Is there a way to run the report without including the filter, somehow?
- NineIron - Wednesday, March 15, 2017 6:14 AM
Almost certainly but it will be difficult to be specific because you've not given a lot of details. One way could be to write the filter expression to do one thing if condition x is met and another if condition y is met.
On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a PhilosopherHow to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
-
The report pulls data for our Radiology department. They want to be able to pull exams by date range, exam type, and location. There is a date range parameter and a dropdown for the exam types. I added a filter for location, which is another dropdown but, the user would like to be able to run the report for all locations as well as choose a location as needed.
-
I see. I'm assuming your dropdowns are Report Parameters. If that is the case, if you tick the Allow Multiple Values box thusly
then set your filter like so:
You should, when you come to run the report, have a 'Select All' option on your location parameter. This will do exactly what it says and run the report for every location.
On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a PhilosopherHow to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
-
Wonderful. I had the Operator set to "=", not "IN". Works like a charm.
Thanx. -
You're welcome. I've been caught out by that myself recently :blush:
On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a PhilosopherHow to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply