Oleg shows you how to do this in a filter... I prefer to do it in a query,
which seems to be what you were asking...
Create a data set with the following query
SELECT
PartID, Part, QTY, Description
FROM
TableX
WHERE
Description like @Description
THen test the report... BIDs will automatically add a parameter called
Description and hook it to the query... But your users MUST add the wild card
characters themselves.. THis is most flexible because they can search for an
exact match OR use wildcards - but they must be trained ..IF you always want
to add the wildcard stuff... try
SELECT
PartID, Part, QTY, Description
FROM
TableX
WHERE
Description like '%' + @Description + '%'
Good luck and have fun!
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
[quoted text, click to view] "john wright" wrote:
> I want to provide a parameter for my users to look up an item using a
> description field. The database is set up with a description field for each
> item. I have set up the parameter for this description field, now I want it
> to act as a like query and search for all similiar matches. How is this
> done?
>
> Similiar to the following query
>
> SELECT
> PartID, Part, QTY, Description
> FROM
> TableX
> WHERE
> Description like '%[parameter value]%'
>
> Thanks.
>
> john
>
>
Or instead of the users putting in a wild card do this:
SELECT
PartID, Part, QTY, Description
FROM
TableX
WHERE
Description like @Description + '%'
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
[quoted text, click to view] "Wayne Snyder" <wayne.nospam.snyder@mariner-usa.com> wrote in message
news:25B78A02-8631-4DBD-8E8F-0D40686C51F0@microsoft.com...
> Oleg shows you how to do this in a filter... I prefer to do it in a query,
> which seems to be what you were asking...
>
> Create a data set with the following query
>
> SELECT
> PartID, Part, QTY, Description
> FROM
> TableX
> WHERE
> Description like @Description
>
> THen test the report... BIDs will automatically add a parameter called
> Description and hook it to the query... But your users MUST add the wild
> card
> characters themselves.. THis is most flexible because they can search for
> an
> exact match OR use wildcards - but they must be trained ..IF you always
> want
> to add the wildcard stuff... try
>
> SELECT
> PartID, Part, QTY, Description
> FROM
> TableX
> WHERE
> Description like '%' + @Description + '%'
>
>
> Good luck and have fun!
>
>
>
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
>
> I support the Professional Association for SQL Server ( PASS) and it''s
> community of SQL Professionals.
>
>
> "john wright" wrote:
>
>> I want to provide a parameter for my users to look up an item using a
>> description field. The database is set up with a description field for
>> each
>> item. I have set up the parameter for this description field, now I want
>> it
>> to act as a like query and search for all similiar matches. How is this
>> done?
>>
>> Similiar to the following query
>>
>> SELECT
>> PartID, Part, QTY, Description
>> FROM
>> TableX
>> WHERE
>> Description like '%[parameter value]%'
>>
>> Thanks.
>>
>> john
>>
>>
>>
