Yes, I did. But when viewing report, it can not read

the type of parameters are Menu Type. Since list of values is fixed data TYPE , they didn't refresh. My solution: changing from fixed data to SQL.

Thanks for your answers, I have use the Menu type instead of the Date type.

Hi Thomas, I think the problems do not at ' Dept' prompt, it's Order_no prompt, since Order_No prompt must be depended on 3 parameters. I tried like your suggestion, but it's not work. And I try removing parameters from the codes of Order_no prompt then it's OK select order_no order_no from ordhead

Optimizing my sql like this, it's still happening errors: select order_no order_no from ordhead WHERE (:PM_BUYER is null or ordhead.buyer =:PM_BUYER) AND (:PM_dept is null or ordhead.dept =:PM_dept) AND (ordhead.status in (:PM_status)) I removed OR from the codes, It's fine select order_no order_no from ordhead WHERE…

I have resolved this issue, this is my code select order_no order_no from ordhead WHERE (ordhead.buyer =nvl(:PM_BUYER, ordhead.buyer)) AND (ordhead.dept =nvl(:PM_dept,ordhead.dept)) AND (ordhead.status in (:PM_status)) And set default value = * for select all values passed.…

Because NULL value not exist in list of values of parameter. I was union NULL value to list of values of parameter and the report is working now.

Thanks for your help, I have resolved this problem.

Hi @Gianni Ceresa, Thanks for your friendly reminder. At now, I'm facing the issue that comes from this setup PRD solution, when I did set up my prompts is new row to show difference lines then they were a bad show. In detail,

Special thanks to guys, I have resolved this problem.