7 SSRS - Creating a Radio Button Parameter (SQL Server Reporting Services)
In this video, we will learn about how to create a radio button parameter in SSRS (SQL Server Reporting Services)
===============Script to CREATE TABLE==================
CREATE TABLE [dbo].[Employee](
[id] [int],
[first_name] [varchar](50),
[last_name] [varchar](50),
[email] [varchar](50),
[gender] [varchar](50),
[is_active] [bit]
)
=============Script to CREATE PROCEDURE================
CREATE PROCEDURE [dbo].[GetEmpData]
(
@gender VARCHAR(50),
@is_active BIT
)
AS
BEGIN
SELECT [id]
,[first_name]
,[last_name]
,[email]
,[gender]
,[is_active]
FROM [SSRSDB].[dbo].[Employee]
WHERE gender = @gender AND is_active = @is_active
END
===================Executing Procedure==================
EXEC [dbo].[GetEmpData] 'male',0
EXEC [dbo].[GetEmpData] 'male',1
EXEC [dbo].[GetEmpData] 'female',0
EXEC [dbo].[GetEmpData] 'female',1