SSRS -HOW TO CHANGE PARAMETER NAME

Question

User1124985708 posted

I am using procedure to build my report ,Procedure has 3 parameter ,while displaying it show parameter name as is.I want to change parameter name but their is no option like Label,yes we can change prompt name but how to change parameter name for Display purpose.....

Ok ..let me explain it  thru Example:

If my procedure has @customerid then SSRS itself create 1 parameter texbox with Labeled as customerid

See one way is  to change Parameter name here is to change my procedure parameter as @CustomerName but i don't want to change procedure ,vl it be possible to change Display name thru SSRS itself.....

Answer 1

User-8475372 posted

If you are using SQL Server Business Intelligence Development Studio (BIDS) 2008 then you can find the report parameters in the Report data section. 

In that click on the report parameters and Change the Name for the parameter as Customer Name

Answer 2

User2105670541 posted

Go to your report >> View >> Report Data >> Parameters >> Double click on the @customerid parameter>> In Parameter Name set your required value

Answer 3

User1124985708 posted

Got d solution .......We have to change Parameter Prompt and not Parameter name....

Answer 4

User2105670541 posted

Oops, actualy i meant the same, probably wrote the Name instead of prompt. silly me :)