Reports with stored procedure

• rnamani7375

  Grasshopper

  Points: 13

  More actions

  September 11, 2010 at 7:43 pm

  #238054

  I have a stored procedure with 6 parameters and that is called in ssrs 2005. I am passing parameters by using report parameters by creating 6 datasets. Now i have a issue i have to club two datasets ie i have to give 2 parameters from one dataset. Please suggest me is this possible? If yes can any one guide me how to do it

  Thanks in advance

• tsmith-960032

  SSCrazy

  Points: 2518

  More actions

  September 15, 2010 at 10:01 am

  #1221484

  I am not sure I understand what you are trying to do, but, I hope this will help.

  Since you are using an sp, and the parameters are set up, they are ALL visible and can be used in ALL datasets.

• rnamani7375

  Grasshopper

  Points: 13

  More actions

  September 15, 2010 at 10:09 am

  #1221494

  i got a requriement that i have to pass 2 parameters to stored procedure by using one dataset is that possible?

• tsmith-960032

  SSCrazy

  Points: 2518

  More actions

  September 15, 2010 at 10:41 am

  #1221517

  Report parameters are global, and thus can be passed back to any stored procedure, as long as the parameter name(s) match the parameter name that the stored procedure is expecting.

  Also, if you want to use a field that is passed to a dataset from a stored procedure in another dataset, you can create a parameter and set it equal to that field, and then it is usable throughout all the datasets of the report. Just set the parameter type to the field type, to be hidden or internal, so it doesn't pop up asking the user to enter data, and set its default value to that of the specific field of the specific dataset by choosing default value "get values from query"

  Again, you can create as many parameters as you want, and set them equal to any field of any dataset.