How to set Output Parameter and get the value in SSRS(BIDS)?

• fujun_1984

  Valued Member

  Points: 67

  More actions

  September 14, 2015 at 7:30 pm

  #321241

  Hi, everyone!

  I am working on SSRS 2008 R2 in BIDS. The report's data source is from Stored Procedure which is running good in SQL Server 2008 R2.

  The stored procedure has an output parameter, which I don't know how to set in BIDS, so when I try to add the data source to the report, a mistake is shown up.

  So my problem is:

  1、How to set the output parameter correctly, so the data source(stored procedure) can be run as good as it were in SQL Server 2008 R2.

  2、How to get the output parameter value in BIDS which will be used to set the title of talbe dynamically.

  Thanks!