Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bigweed
Starting Member
19 Posts |
 Posted - 2010-12-15 : 04:12:54
|
| Hi allI want to use a filter in my dataset to return site records. This filter is going to use values stored in a multi value report parameter. So far, so good. I would ordinarily put the following in the Filter box in the dataset page in VS2005:IN (@Site)However, I dont want to filter for just exact matches for the above values, I also want to return all records where Site number BEGINS WITH the values stored in @Site parameter. I have tried entering:IN (@Site)*andIN (@Site*)but I got errors in both cases.I tried the following but they didnt work either:IN (@Site + N'%')andIN (@Site) + '%'The following works, but only with parameters which are NOT multi value:projitemtrans.siteid LIKE @Site + '%'Can someone please help me with this? Thanks |
|
|
bigweed
Starting Member
19 Posts |
Posted - 2010-12-19 : 13:47:49
|
| Anybody have any clues for this please? I have been reading up abou tthis, and I think that dynamic SQL is the only way to go, but I have no idea how to code it, or where. Also, calling it as a stored procedure reads like the right thing to do, but I am again at a loss as to how to do it. Can anyone help please? |
 |
|
|
|
|
|
SSRS 2005 - Wildcard with multi value parameter??