How do I remove the group number that is displayed in bar charts when there are more than 50+ label items? Can someone educate me on why it happens and how can it be corrected please? Query used for the chart is as below(from view): Select total_count,column1 as Series, column2 as Label from v_test;
Discy Latest Questions
There's a interactive report(on page 1) with checkbox options that I have created using the steps shared in On Page 2 - there's another IR which should show the records based on rows selected from previous IR I did try to google for solutions on the question above but couldn't locate any. Can you please suggest ways to achieve this? Or if you could guide me to already provided solution it would be of great help.
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;
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?