Hello I want to create a report using a SQL query; something like this SELECT * FROM ORDERS WHERE ORDER_TYPE_ID = $P{my_order_type_id} AND ORDER_Company_ID = $P{my_order_company_id} But my web application needs to be able to restrict or not restrict what users see based on the type of user. So the 'my_order_company_id' parameter may not always be passed for all users. Does this mean that when 'my_order_company_id' is not passed to the query the report will run the following query a instead of query b? a) SELECT * FROM ORDERS WHERE ORDER_TYPE_ID = 1 AND ORDER_Company_ID = null b) SELECT * FROM ORDERS WHERE ORDER_TYPE_ID = 1 If so, is there a way for me to make the report query b? Thanks
