Using parameters -- sql server reporting services

Shan
8/31/2005 9:17:04 AM

I have a scenario where I want user to input data for search. Statement
looks like
Select course_nbr, attend
From table_1
Where (course_nbr = @course_nbr)

This only allows user to input exact course number and then the query will
return a result.

I want to be able for user to input the first few letters of the course
number and the query should return all course numbers that starts with those
letter.

Any help would be greatly appreciated.

MJ Taft
8/31/2005 10:57:03 AM

try using Where (course_nbr Like @course_nbr)

[quoted text, click to view]

Shan
8/31/2005 11:31:05 AM

Thanks MJ, That works fine only I have to add a % sign when Im doing a
search for the course number. For example I want all the courses starting
with letter "N". I just use N%.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

sql server reporting services : Using parameters