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))
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:
Post a Comment