SSRS Report Builder Part 10.6 - Stored Procedure Parameters

By Andrew Gould

Chapters
00:00 Topic List
00:31 Creating the Data Source
02:33 Creating the Basic Query
04:13 Creating a Basic Stored Procedure
05:53 Testing the Procedure in SSMS
07:29 Using a Stored Procedure in a Dataset
09:05 Adding a Parameter to the Procedure
13:25 Using the Parameter in the Report
14:40 Making a Parameter Optional
16:58 Creating More Optional Parameters
21:43 Optional Date Parameters

Learn how to use a stored procedure to populate a Report Builder dataset including optional parameters.

[TheMindverse]

I hadn't used SSRS to create an SP-based report in a while, and this was just what was needed to refresh my memory. Thanks so much.

[richardekeopara]

All your SSRS tutorials are awesome! I have watched many of them over the last few weeks and I'm a confident SSRS developer now, thanks to you.

[GandhiJa]

This was so helpful and easy to follow step by step. Thanks so much!

[briangubkin]

Thank you! This tutorial was clear and helped me with my issues.

[enrikekasijas]

Your videos are so amazing. Right know I am checking VBA ;P I will get to this one at one point. I hate I am just too far behind. I need to catch up. Ps. Your VBA tutorials are out of this world xD love you!;D

[likhitaGrandhi]

Hi, Thank you for your amazing tutorials, they are very clear. It has helped me developing many reports and improve my skills. I have question, Can you please explain how to pass a user defined table type to SP in Report builder? I would really be Grateful if you can help me. Thanks.

[alexandredantas-cm]

Is it possible to use Stored Procedure in Fabric ? data source is a Lakehouse or a semantic model in Power Report BI Builder, options Tables and Stored Procedures are disable when the data source is a Lake or Semantic Model. Thanks.

[abdullahquhtani]

Is there a way to use server authentication to connect to database and save or embedded username and password or SQL connection string in RDL file ?

[DanielTorres-jzqo]

Hello! I am very grateful for your channel, I have improved a lot with reports after your classes.

I have a situation that I could not solve, if you can help me I would be grateful!

Situation:

I have a Store Procedure that has an OUTPUT parameter which is an ID to perform a select on another table.

when I call this SP in my dataset I can't recover the output parameter, is this possible in the report biulder?

Example Code:

DECLARE @output INT

EXEC Stp_example @DT_example = '20230717'

IF @output > 0

BEGIN
SELECT *
from tLogEventos
WHERE iIDEvento = @output
order by dHoraExecucao desc
END

Yours sincerely