Using the IN operator to filter in reporting services
Can anyone advise what the syntax should be when using the IN operator within a table filter. I have tried the below but the snytax is wrong:
Solution
If you just change the Value property and just add a comma separated list of values that should work:
This worked for me in a quick test, anyway.
Books Online seems to be pretty light on examples, but I did find one reference; see the In example in Commmonly Used Filters. It would be nice if this was explained better.
- How to turn IDENTITY_INSERT on and off using SQL Server 2008?
- Using the IN operator to filter in reporting services
- Loop in SQL Server 2008
- what is the best way for convert VisualFoxPro Database To Sql Server 2008 - Without Damage in Unicode Data?
- How to check if a column exists in a SQL Server table
- How to check table exist and then rename it
- SQL : remove last comma in string
- How to get week number of the month from the date in sql server 2008
- How to execute Table valued function
- Cannot open backup device. Operating System error 5
- SQL SP: Dynamic Query
- Enable foreign key with Check existing data
- SQL Server: Login failed for user
- Merge the two xml fragments into one?
- How to add a new identity column to a table in SQL Server?
- SQL Server: Invalid Column Name
- How can I select the first day of a month in SQL?
- Using T-SQL EXCEPT with DELETE / Optimizing a query
- Error 0xc0202049: Data Flow Task 1: Failure inserting into the read-only column
- Finding even or odd ID values
- How to fill all the months of the year in order using TSQL
- SQL SERVER: Get total days between two dates
- Reset identity seed after deleting records in SQL Server
- Delete all views from Sql Server
- How to solve the date comparison issue in SQL Server?
- connection timeout expired. the timeout period elapsed while attempting to consume the pre-login handshake acknowledgement
- Select most recent record for each member
- Creating new database from a backup of another Database on the same server?
- How Do I Deep Copy a Set of Data, and Change FK References to Point to All the Copies?
- Select From a table that is constantly being inserted into