CODEWITHSUNDEEP
reporting-servicesparameters
Tim Vavra
Tim Vavra

Reputation: 537

Select ALL in SSRS

I have a table based on three drop down lists. The first is a client list, the second is a date list and the third is a stage list. The first two are single value lists. I can only allow the user to select 1 from each of those lists. The third list is a stage list. This contains the values First,Final and Release. My client has come back to me and asked if I can supply them with the ability to select all of the stages as an option. Here is the query as I have it right now. I have tried using (AnnotationDate IN (@Stage)) in place of (AnnotationDate = @Stage) but was unsuccessful. Can anyone give me a helpful hint?

SELECT     AdDate, Page_ID, Status, AnnotationNumber, AnnotationBy, [Role Description], AnnotationDate, AnnotationType, BusinessUnit, ActualAgencyError, ErrorType, 
                      AnnotationComments, TeamComments, sgkComments, PA, Client, Activity, Support, Name, BusImpact
FROM         vwAgencyErrorOpen
WHERE     (Client = @Client) AND (AdDate = @Job) AND (AnnotationDate = @Stage)
ORDER BY Page_ID

Upvotes: 0

Views: 201

Answers (1)

Sam
Sam

Reputation: 7313

Change your @Stage Parameter to be multi-seletion.

MultiSelect Parameter

Then remove the (AnnotationDate = @Stage) clause from the query.

And then set up a filter on your dataset as below:

Dataset Filter

You can then select all of your options.

Select all

Upvotes: 1

Related Questions