I have an SSRS report which uses a parameter to bring through customer order information At the moment the user needs to enter the Customer order number in full but Ideally it would be better if they only needed to enter the first few characters - Is it possible to create a parameter that brings through all records beginning with a particular character or string of characters?
Thanks - David
Answer by Jason Cumberland ·
The only way I can think of to do this is to change the query to use a 'like' search with the first few values and a wildcard for the order number instead of looking for equality. Example below.
Set @ordernum paramter value to "2345%"
select * from Orders where OrderNumber like @ordernum