question

David B avatar image
David B asked

SSRS Parameters

Hi all

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?

Please help!

Thanks - David

ssrsparameters
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Jason Cumberland avatar image
Jason Cumberland answered

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
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.