Search

Advertisements

SSRS - IsNothing - Decision Function

SCENARIO:

If a column has NULL value  and if we want to display the entire row only if the column has NOT NULL value and to eliminate\hide  the entire row if the column has NULL value .

 If we want to handle above scenario in SSRS ,IsNothing function can be used.

--sample data

CREATE TABLE TEST_SSRS(ID INT,Name VARCHAR(20))

INSERT TEST_SSRS SELECT 1,'Sathya'
INSERT TEST_SSRS SELECT 2,'Sunny'
INSERT TEST_SSRS (Name) SELECT 'Hansi'


--you can also try giving this condition directly "WHERE ID IS NOT NULL" in your  dataset to hide entire row if the column has NULL value.

SELECT * FROM TEST_SSRS WHERE ID IS NOT NULL


EXAMPLE : SSRS report not displaying  row if the column has NULL value













No comments:

Advertisements