Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Filtering a Data Region by using the "IN" Operator

Status
Not open for further replies.

cs2009

Programmer
Aug 10, 2009
50
US
Using SSRS 2005.

I'm trying to filter a data region by using the "IN" operator, but the region returns no records. I've tried different variations for the value expression such as:

GL, A6, B6, C6, H6, GV, A7, B7, C7, H7, GR, A8, B8, C8, H8, GS, A9, B9, C9, H9

or

Join(GL, A6, B6, C6, H6, GV, A7, B7, C7, H7, GR, A8, B8, C8, H8, GS, A9, B9, C9, H9,",")

Help.
 
Can you make this a parameter or hidden parameter? I've had luck filtering on an IN when using a parameter.
 
Thanks, RiverGuy. If using a parameter is the only way to make the "IN" operator work then I will use one.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top