Passing Stored procedure to dataset in ssrs

• saurabhnil

  SSC Enthusiast

  Points: 107

  More actions

  August 1, 2008 at 1:26 am

  #210785

  Hi all

  I have created a SSRS report and defined dataset for the same. In this one can give stored procedure name or query for that dataset.

  I want to pass stored procedure name to a data set in SSRS through .NET code

  - Anyone has any solutiong for this ?

• saurabhnil

  SSC Enthusiast

  Points: 107

  More actions

  September 2, 2008 at 7:06 am

  #865963

  Solution for this problem I was thinking will be so different. But its just the common way.

  Instead of giving stored procedures name - i have given

  "= Parameters!Stored_Proc_Name.Value"

  So one can pass stored procedure name as a parameter.

  This is working for me.