SSRS - Report for Stored Procedure with Parameters

  • Shawn Melton

    SSC-Insane

    Points: 24675

    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

    Default port

    Points: 1457

    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: 24675

    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: 9852

    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

    Default port

    Points: 1457

    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: 24675

    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

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

    Thanks for sharing.

  • jsm60

    SSC Enthusiast

    Points: 191

    Excellent article, easy to follow.

  • Rod at work

    SSC-Dedicated

    Points: 33376

    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.

Viewing 9 posts - 1 through 9 (of 9 total)

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