Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

In my report in SSRS 2008 I have created a expression for the CasesShipped column like this:

=IIF(Fields!Current_Product.Value= "Match"," ",Sum(Fields!Cases_Shipped.Value))

It sums the Cases_Shipped value having same distributor item code. Now I want to apply a filter for the Cases_Shipped drop down list value to report records after previously mentioned activity.

How can I do this?

share|improve this question

migrated from Oct 20 '11 at 13:57

This question came from our site for professional and enthusiast programmers.

Probably the easiest way would be to use a drill through report. Add an action to the row group that links to a new report. Duplicate the layout of the new report, but implement a filter on the dataset of interest.

Pass the row group value ([SQLFieldName]) to a parameter of the report. If you use a multivalue variable with an IN statement in the SQL, several filters can be used at once.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.