First I apologize if this topic already exists, but after registering, this website would not allow me to search.
2nd, I'm very, very green to all things SQL so I'll try my best to explain as much detail as possible.
I first created the following query using MS SQL Server Management Studio 2012. I typically build and test first using this software.
declare @SearchValue as VarChar(60) = '%Central%'
(Name1 like @SearchValue or Name2 like @SearchValue or Name3 like @SearchValue)
The above query works as expected (except I have %Central% hard-coded and I will need this to be parameter input in Reporting Services). But it does find the declared value %Central% in any of the 3 'Name' fields.
I then copied this query into MS SQL Server 2012 Report Builder (version 11.0.3513.0). I use this reporting tool so that the report/query can be published and used by other internal employees.
So here's where I'm struggling. In Report Builder, I can't figure out how to setup the wildcard search as a parameter so that 1 input (such as the word "%Central%") will be searched for in all 3 'Name' fields and return matches if %Central% is found in any 1 of the 3 'Name' fields.
Do I keep the Declare line? If yes, does this line need to change? How do I change the '%Central%' to be a parameter within this line?