Remove Blank Spaces from parameter SSRS

0
votes

I am trying to do a report on SSRS and the first parameter I have to enter it manually or can Copy paste it from a excel file(one by one). Sometimes there are spaces before the ID. The other 2 parameters are dependent on the first parameter.

I am trying to figure our what can be done in order to just take the ID when entered into the parameter box. I have attached a picture for your reference.enter image description here

1
reporting-servicesssrs-2008

1 Answers

1
votes

I'm assuming that you want to use this parameter in a SQL query?

If so, in your query why not just trim the leading spaces from the value like this:

where ID = ltrim(@ID)

If I have misunderstood, please add some more information to help clarify exactly what you're trying to do.