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.
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.