November 3, 2014 at 10:21 pm
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
November 4, 2014 at 2:19 am
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.
November 4, 2014 at 7:15 am
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
November 4, 2014 at 7:19 am
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:-)
November 4, 2014 at 7:26 am
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
November 4, 2014 at 7:41 am
Conficker (11/4/2014)
Thanks Thomas, that's correcti 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
November 4, 2014 at 7:56 am
Great article, yeah I'd like to see multiple departments passed in as well.
Thanks for sharing.
November 4, 2014 at 8:25 am
Excellent article, easy to follow.
June 26, 2019 at 7:57 pm
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy