2.4k questions

2.4k answers

95.4k users

4 Online Users
0 Member 4 Guest
Today Visits : 2124
Yesterday Visits : 2079
Total Visits : 2337558



Dear All, These are my answers from Quora and primarily Google; please check the answer and from others sites; the answers are free and without any liability.To make a decision, write down all of the positives and negatives on a piece of paper.Thank you,

Elias Katsaniotis, MSc


Viktoria Katsanioti,




0 votes

How do you filter with blank values (reporting services, development)?
in General by (95.8k points)

1 Answer

0 votes
see  Filter by blank Value or Null

Hi KittyCat101, According to your description, you want to filter blank or null value in fields. Right? In Reporting Services, it’s not supported to filter both null and blank values. In your scenario, I would suggest you replace all null/empty values into one type (either null or blank), then filter it in the dataset query. If you still have any questions, please feel free to ask. Thanks, Xi Jin.


my opinion for null or empty

you may use nvl()


SQL Language Reference

Previous Next JavaScript must be enabled to correctly display this content


you may use decode()


DECODE Syntax Description of the illustration decode.gif Purpose DECODE compares expr to each search value one by one. If expr is equal to a search , then Oracle Database returns the corresponding result . If no match is found, then Oracle returns default . If default is omitted, then Oracle returns null. The arguments can be any of the numeric types ( NUMBER , BINARY_FLOAT , or BINARY_DOUBLE ) or character types. If expr and search are character data, then Oracle compares them using nonpadded comparison semantics. expr , search , and result can be any of the datatypes CHAR , VARCHAR2 , NCHAR , or NVARCHAR2 . The string returned is of VARCHAR2 datatype and is in the same character set as the first result parameter. If the first search-result pair are numeric, then Oracle compares all search-result expressions and the first expr to determine the argument with the highest numeric precedence, implicitly converts the remaining arguments to that datatype, and returns that datatype. The search , result , and default values can be derived from expressions. Oracle Database uses short-circuit evaluation . That is, the database evaluates each search value only before comparing it to expr , rather than evaluating all search values before comparing any of them with expr . Consequently, Oracle never evaluates a search if a previous search is equal to expr . Oracle automatically converts expr and each search value to the datatype of the first search value before comparing. Oracle automatically converts the return value to the same datatype as the first result . If the first result has the datatype CHAR or if the first result is null, then Oracle converts the return value to the datatype VARCHAR2 . In a DECODE function, Oracle considers two nulls to be equivalent. If expr is null, then Oracle returns the result of the first search that is also null. The maximum number of components in the DECODE function, including expr , searches , results , and default , is 255. Examples This example decodes the value warehouse_id . If warehouse_id is 1, then the function returns ' Southlake '; if warehouse_id is 2, then it returns ' San Francisco '; and so forth. If warehouse_id is not 1, 2, 3, or 4, then the function returns ' Non domestic '. SELECT product_id, DECODE (warehouse_id, 1, 'Southlake', 2, 'San Francisco', 3, 'New Jersey', 4, 'Seattle', 'Non domestic') "Location of inventory" FROM inventories WHERE product_id < 1775;

by (95.8k points)