Hi, I'm using Multi-Select Parameter in my report and using this syntax "$X{IN, dummy, PARAM_MULTI_PROJ_ID}" in the query. QUERY 1: Now this works fine if I'm put some value for this parameter and I run the report. But when I do not give any value in this parameter then instead of showing no results it simply selects all the rows of that table and provide the output which is not desired as per my requirement. Below is the query where i'm using this parameter. Please let me know if my implementation is in correct somewhere: SELECT tab.id AS id FROM my_table tabWHERE $X{IN, tab.ID, PARAM_MULTI_PROJ_ID} QUERY 2:Also, Im using a separate queyr where I'm checking whether the Multi-Select parameter is null or not. Please check the below query and let me know if it is correct:SELECTCASE WHEN$X{IN, 0, PARAM_MULTI_PROJ_ID} THEN 0 ELSE 1 END as filter_checkFROM DUAL Thanks
