As per our information Radio button is work on True and False statement .So we have to create stored procedure with parameter and using bit . Bit is work on true and false .
Step 1:
===============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
Step 2: Create Data Source and Data Set and Add Report
How can handle null values parameters in report
No comments:
Post a Comment