SSRS - Report for Stored Procedure with Parameters

Question

Post reply

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

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

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

Conficker SSCommitted Points: 1507 More actions · Answer 1

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 · Answer 2

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 · Answer 3

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: 1507 More actions · Answer 4

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 · Answer 5

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 · Answer 6

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

Thanks for sharing.

jsm60 SSC Enthusiast Points: 191 More actions · Answer 7

jsm60

SSC Enthusiast

Points: 191

November 4, 2014 at 8:25 am

#1756557

Excellent article, easy to follow.

Rod at work SSC-Dedicated Points: 33898 More actions · Answer 8

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.