locked
SSRS -HOW TO CHANGE PARAMETER NAME RRS feed

  • 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.....

    Wednesday, April 18, 2012 1:57 AM

Answers

  • User1124985708 posted

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

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, April 18, 2012 5:53 AM

All replies

  • 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

    Wednesday, April 18, 2012 2:13 AM
  • User2105670541 posted

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

    Wednesday, April 18, 2012 2:47 AM
  • User1124985708 posted

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

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, April 18, 2012 5:53 AM
  • User2105670541 posted

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

    Wednesday, April 18, 2012 5:59 AM