Created a data source not want to add filter into the data source but issue is when i am adding filter:
| user_def24 = IIF(ISNULL('$user_def24$', '') = '', user_def24, '$user_def24$') then it`s not taking the data from table where user_def24 is null into consideration. When i am adding filter: |
| (user_def24 = IIF(ISNULL('$user_def24$', '') = '', user_def24, '$user_def24$') or user_def24 is null) then selecting one data from table it`s shows relevant data but with all rows which has user_def24 value null.
EEXPECTED BEHAVIOUR
When we are using filter then if a value is selected then data shows should be of that value and if nothing is selected on the parameter all values should be shown into table including null values.
|
