How to add a parameter in an existing report in SSRS

  • I need to add a parameter to the existing report which has already some parameters. I m very new to SS Reporting services and I need advice how to get to that.

  • From the MSSQL Business Intelligence Design Studio  choose the REPORT > REPORT PARAMETERS menu item where you can add a new param and indicate the data source for the param.

  • can some one tell me how to open the reports that are already existing from Visual studio or BI Dev Studio. I installed SQL Server 2005 and when I get into the visual studio I couldn't see any of the folders or reports.

    Please advice.

  • All I need is to know how to access the .rdl file for the specific reports. I was given the location of the report on the reporting server. Please advice..

  • The .rdl is stored in the ReportServer database.  What I generally do is open the report via the web browser, go to the Properties tab, and click Edit.  You can then save the rdl as a file, and pull it into a Reporting Services project in BIDS. 

    You will probably have to edit the data source and any references to custom assemblies (if any) which may not exist on the workstation you are editing the report on.

  • Dear Satish,

    Place a report viewer Control in your .Net application.

    Then it will ask for report server and path.

    Report server : http:\\localhost\Reportserver (Most Common)

    Report Path : The path to the Rdl File.

    If ur Rdl Files are in folder myreports then

    Path will be like /myreports/reportname.rdl

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply