We have 2 parameters, parameter1 and parameter2, that we need to filter in our RD. For example, we want the RD to display records that have parameter1 equals to "A" AND parameter2 does not equal to "B", including those records that have blank values for parameter2. We would have the following condition:
Parameter1 = "A" AND Parameter2 != "B".
However, the above condition does not include any records with blank values for parameter2 even though their parameter1 is "A". Are there any way to achieve this? We tried to use OR to include blank values for parameter2 but their parameter1 wouldn't be equal to "A"
***Edited by Moderator: Pooja Gadige to add capability tag***