Take the 2-minute tour ×
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. It's 100% free, no registration required.

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 stackoverflow.com Oct 20 '11 at 13:57

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

add comment

1 Answer 1

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
add comment

Your Answer

 
discard

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