SSRS - Report for Stored Procedure with Parameters

• Shawn Melton

  SSC-Insane

  Points: 24685

  More actions

  November 3, 2014 at 10:21 pm

  #300715

  Comments posted to this topic are about the item SSRS - Report for Stored Procedure with Parameters[/url]

  I will note there is one error in the query for the "Lookup_DepartmentName", a period somehow got put after the last column of the SELECT statement. So it should read:

  SELECT Name, DepartmentID

  FROM HumanResources.Department

  UNION

  SELECT '',NULL

  ORDER BY Name

  Shawn Melton
  Twitter: @wsmelton
  Blog: wsmelton.github.com
  Github: wsmelton

• Conficker

  SSCommitted

  Points: 1567

  More actions

  November 4, 2014 at 2:19 am

  #1756472

  Thanks for your very informative post.

  if you can add how to pass multiple parameters over the stored procedure will be very useful.

  Thanks again.

• Shawn Melton

  SSC-Insane

  Points: 24685

  More actions

  November 4, 2014 at 7:15 am

  #1756539

  Conficker (11/4/2014)

  ---

  Thanks for your very informative post.

  if you can add how to pass multiple parameters over the stored procedure will be very useful.

  Thanks again.

  I don't think I follow, there are multiple parameters being passed in this example to a stored procedure.

  Shawn Melton
  Twitter: @wsmelton
  Blog: wsmelton.github.com
  Github: wsmelton

• thomashohner

  SSCrazy Eights

  Points: 9856

  More actions

  November 4, 2014 at 7:19 am

  #1756541

  Shawn,

  He may mean how to pass multiple values through a single parameter via a split list function. Just a guess though as the wording is confusing.

  Great article!

  ***SQL born on date Spring 2013:-)

• Conficker

  SSCommitted

  Points: 1567

  More actions

  November 4, 2014 at 7:26 am

  #1756542

  Thanks Thomas, that's correct

  i mean if we have to run your report for multiple departments.

  eg. Finance, Marketing, Production same time

  Hope that makes sense

• Shawn Melton

  SSC-Insane

  Points: 24685

  More actions

  November 4, 2014 at 7:41 am

  #1756547

  Conficker (11/4/2014)

  ---

  Thanks Thomas, that's correct

  i mean if we have to run your report for multiple departments.

  eg. Finance, Marketing, Production same time

  Hope that makes sense

  Ah, gotcha. Yeah, I had thought about including something like that but Steve wanted to keep this as a basic example. I can see if I can't maybe make a "part-2" for that type of example.

  Shawn Melton
  Twitter: @wsmelton
  Blog: wsmelton.github.com
  Github: wsmelton

• apglr32

  SSC Journeyman

  Points: 82

  More actions

  November 4, 2014 at 7:56 am

  #1756553

  Great article, yeah I'd like to see multiple departments passed in as well.

  Thanks for sharing.

• jsm60

  SSC Enthusiast

  Points: 191

  More actions

  November 4, 2014 at 8:25 am

  #1756557

  Excellent article, easy to follow.

• Rod at work

  SSC-Dedicated

  Points: 34057

  More actions

  June 26, 2019 at 7:57 pm

  #3657896

  I've been asked to write a SSRS report against a MySQL database. Everything I know on how to write a SSRS report against SQL Server, doesn't seem to work at all with MySQL. I came across a blog post which sorta helped, but not when it came to specifying how to write SSRS reports against a MySQL database, when calling a stored proc with parameters.

  Kindest Regards, Rod Connect with me on LinkedIn.