Needed help on displaying Summary of Orders in a different region based on filter from Interactive report. If a filter on Order table is applied on column Product within IR. The summary region should show Total# of orders & Order value per the selected Product. How can I pass the filter value from IR to the below where condition? select p.product_name as OrderName, sum(quantity) as Order_Quantity, sum(quantity * p.list_price) sales from demo_order_items i join demo_product_info p on i.product_id= p.product_id Where p.product_id = 10 group by p.product_name;
Discy Latest Questions
Need inputs on how do I display Name in navigation bar instead of username. Tried the steps mentioned here: Display Full Name But receive an error on Application computations PL/SQL function body. declare v_app_user varchar2(30); begin v_app_user := V('P_APP_USER'); select fname into v_app_user from usertable where username = :APP_USER; return v_app_user; end; Can I someone please guide on what I seem to be following wrong?