hy guys, when press on download pdf then show default to landscape how to set default to portrait any solution ? interactive grid or interactive report (19.2)
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;
I have 5 columns in table. I m going to collect user inputs in 4 columns and rest 1 column will be sysdate (date+ Time stamp) which user will not view/enter/correct but my form should manage and insert accurate value. How can I do? I have set value in default/source but while inserting it gives error. <dt_created> can not insert null. Pl guide.
Hello Sir, How can I preserve the checkbox in an Interactive Report with Select All option (eg, Report on EMP table). Once selected then need to load the selected rows into a new table (EMP_NEW). Your help and support would be appreciated.