Your question is not very clear.. You want to add few characters to your parameter value and display in your report ?

 

if so, create a formula like :

 

"yourcharacters"&{?Parameter}

OR

You want to add few characters and validate your modified parameter against database fild value in your stored procedure ?  If so, then you need to either modify the stored procedure by adding additional characters.  Because, once you enter your parameter then it will hit the stored procedure and we can't make any modification in between.

 

 

 

Absolutely you are correct if you call stored procedure through add command.

 

To do this :

 

--Create a report level parameter --right click on parameters and new.

 

Now go in create new connections--Add command -- now call your stored procedure from here.

 

Proc <stored procedure name>, {?reportleveparameter}+{?accutalparameter}

 

Can you check with '&'

Inside the database Command, we must declare a variable, edit it (add characters), and then use the variable in the SP call.

 

For ex.

declare @word varchar(20)

select @word = 'aaa' & '{?MY_PARAM}'

exec sp_MyProc @param1 = @word

 

A parameter of a stored procedure cannot be edited directly.