Application Express :: How To Show Column Headers Before Grand Total
May 23, 2013
In a classic report, I'm using the Sum functionality and breaks by First Column to get subtotals and report total. I Repeat Headers on Break which works great for the subtotals but I would like for the report to display the column headers above the report total for easier reading. If the last grouping has a lot of data, the user needs to scroll up to read the column headers when looking at the Grand Total.
Is there a way to Repeat Headers prior to report total?
View 3 Replies
ADVERTISEMENT
Sep 17, 2010
Below is the statement I am working with. When I get the result the under the Tester column it is a empty space after the total has been done. How can I add the word "Grand Total" under the tester column after the rollup.
SELECT BG_detected_by Tester, CONCAT(Round(count(bg_target_rcyc) / count(bg_status)* 100), '%') Percentage_Compeleted,count(BG_Target_RCYC) Total_Target_Cycle,count(bg_status) Total_Defects
From Bug
where BG_STATUS = 'Open'
GROUP by Rollup(BG_DETECTED_BY,BG_STATUS)
having (grouping(bg_detected_by) = grouping(bg_status))
Tester Percentage_completed Target Defects
empty space --->Grand Total
View 1 Replies
View Related
Aug 8, 2013
I am trying to use rollup for a total, but it doesn't work because what I'm totaling is too conditional. I even tried adding on the totals to the end using a union and a specialized function, but for some reason, the order by stops working when I do the union (all field aliases and types are the same).I know the structure of the query itself probably isn't the best, how I can get the grand total, The subtotals from the rollup work fine, though.
The order by query runs fine against both parts of the union when they are run individually, but once I make it part of the union - the first part of the order by is an unknown field and the second is not a SELECTed list expression. I've commented out the union here. The statement works fine without it except for the grand total being all 0s. I kind of understand why it's all 0s, but not how to get around that.This is running in Oracle 10g2. I am trying to get totals for decisions by each of the four component values: ex_land, ex_imp,tx_land,tx_imp and then subtotals for each component values.
That works for the following query, but I cannot get a grand total through the rollup.
CREATE TABLE "FL_APP" ( "APP_ID" NUMBER(*,0), "FL_STAT_CODE" VARCHAR2(20 BYTE), CONSTRAINT "FL_APP PK" PRIMARY KEY ("APP_ID") ENABLE, CONSTRAINT "FL_APP_FL_STAT_DIM_FK1" FOREIGN KEY ("FL_STAT_CODE") REFERENCES "FL"."FL_STAT_DIM" ("FL_STAT_CODE") ON DELETE CASCADE ENABLE ) ;CREATE TABLE "FL_APP_PROP" ( "APP_ID" NUMBER(*,0), "FL_DECISION_CODE" VARCHAR2(10
[code]....
View 8 Replies
View Related
Nov 27, 2012
I have an IR where I have to show a column in report, but hide it while downloading to CSV.
I get this by having a condition on this column - NVL(:REQUEST,'EMPTY') NOT IN('CSV','XLS','PDF','XML','RTF') I also have a column where I have to hide it in the report, but show it while downloading to CSV.
I am able to hide it, but this column doesn't show up while downloading.I am using this condition on this column NVL(:REQUEST,'EMPTY') IN('CSV','XLS','PDF','XML','RTF') APEX - 4.0.2
View 1 Replies
View Related
May 27, 2013
I am trying to calculating the total column based on two columns, Total=unitprice*no.of items
I wrote this Javascript in page properties>javascrpt>Execute when Page Loads
"$('input[name=f05],input[name=f06]').change( function(){
parent_row = $(this).parents('tr:first');
sal = ( parent_row.find('input[name=f05]').val() == ' ') ? 0 : parseFloat(parent_row.find('input[name=f05]').val() );
comm = ( parent_row.find('input[name=f06]').val() == ' ') ? 0 : parseFloat(parent_row.find('input[name=f06]').val() );
total = sal * comm;
parent_row.find('input[name=f07]').val(total);
});
But its not Giving any result in total column?
View 3 Replies
View Related
Jun 21, 2010
i just want to add at the end of each area_cd the total number of asset.. what do you think i should add in my query????
View 32 Replies
View Related
Mar 26, 2013
I'm running a query like the below but now i would like to make the last line actually say Grand Total. Instead of just total.
SELECT decode (grouping (farinva_invh_Code),0,null,'Total') farinva_invh_Code,
--decode ( grouping (amt),0,null,'GrantTotal')Grant_Total,
farinva_invh_Code,
spriden_id,
--spriden_last_name "last Name"
[Code]....
View 3 Replies
View Related
May 14, 2008
I am using Form graph.jar forms it works properly but in case of bar graphs. i want to display values in the headers of bars.
View 8 Replies
View Related
Jun 26, 2012
I am trying to change the default behavior of Hide/Show Region to show, after some attempts i got it partially working but now clicking the icon to toggle hide/show doesn't work also changed the icons and added type="" but its not working.
View 16 Replies
View Related
Aug 15, 2011
My company recently purchased a package that is capable of automatically printing/caching reports generated by Oracle Reports at specified points in workflows, and so I am trying to design some reports that match the output of previous systems.
I'm having particular difficulty making one of them work the way I need it to. I've put a screenshot of how the report should be laid out (and how I've currently laid it out in Oracle Reports Builder) in the attachment. I'm using Oracle Reports Builder 10g against an 11g database.
Here's what I'm trying to accomplish:
The Header Information in Repeating Frame 1 should be visible on every page of the report. Shipments may cover multiple pages, and I want this section (logo, shipment number, date, carrier) on all of them. The Logo is in a BLOB in the database.
The information in Repeating Frame 2 should be visible on the first page for a shipment, but not on any other pages for the same shipment. Multiple shipments may be printed at a time, so this should only appear at the beginning of the group.
The information in Repeating Frame 3 and the nested Repeating Frame 4 should be visible on every page. I've tried multiple methods to make this work.
I've tried setting the main frame (Repeating Frame 1) to print on all pages, as well as Repeating Frames 3 & 4, with Repeating Frame 2 set to print only on the first page. This combination only yields the first page of the first shipment - no more.
I've tried removing frames 2, 3 and 4 from frame 1 and making them all independent of one another. This seems to yield a cartesian product-like result with all shipment lines attached to the first page and only frame 1 showing up on subsequent pages.
I've tried moving the "Header" information into the top margin. When I did, I got a "frequency below the group..." type of error for the fields in the margin. I then tried to create summary columns with breaks on pages that I could reference in the margin, but I couldn't get the image (from the BLOB) to output.
View 3 Replies
View Related
Nov 13, 2013
Apex 4.2 I have an interactive report.I use the sum attribute on the column and break formatting option to create a report total on one columnReport Sum Label Total:Break Columns No BreaksHow to I format the total text and value in to red
View 16 Replies
View Related
Sep 13, 2012
Im trying spooling a file in DB with below mentioned details.
SET SERVEROUTPUT OFF
set heading on
SET PAUSE OFF
SET FEED OFF
SET PAGES 0
[code]........
file .sql has 20 odd columns.
When file is spooled, it shows no columns headers at the top, why is it happening, I don't want to spool column headers separately.
View 12 Replies
View Related
Jul 22, 2013
i am trying to make an image to show up in an application am developing but is only appearing like a box but when i click on the edit pencil icon the image will appear.
View 1 Replies
View Related
Oct 18, 2012
Let's say that we have an order entry app and the price and quantity items are already populated. We now want to show the user the extended price (the product of the first two items). the extended price would automatically display after both the quantity and price items are entered. I'm assuming that would require some kind of client-side processing. I imagine server-side processing is simpler, so I'll lean in that direction. I'm sure we've all seen web sites that require you to click a button for the order totals to be updated. I'm okay with that approach, but I haven't quite put all of the pieces together. Here's what I came up with.
A region button was added to trigger the updating of the extended price. The button's "Action When Button Clicked" is to submit the page. Under "Page Processing", a process was created to do the calculation with the recipient of the product being a page item. From debug code in the procedure, I can see that the item containing the extended price was, indeed, modified. But the new value doesn't display in the field and the Session window shows that the value of the item didn't change.
I must be missing something. The debug code says the item value was updated. The Session window says it wasn't updated. What gives? What did I do wrong and what needs to be done to correct this?
View 3 Replies
View Related
Apr 19, 2013
how to show total number of department with their department name assign to employee table.
View 2 Replies
View Related
Dec 26, 2012
i want to hide/Show tab according to application user.i want to display tab abc if application user exist in group 006 .
My Column Name in user table name :user_master
{
user_id varchar2(15),
grp_id varchar2(10)
}
what sql statement i apply to hide and show Tab.
View 1 Replies
View Related
Sep 16, 2013
i am trying to use the query builder in my 11g xe database but vainly ,there are no results shown ?
View 6 Replies
View Related
May 17, 2011
I got table alpha
CREATE TABLE alpha
(alpha_id NUMBER
alpha_cash NUMBER,
alpha_other VARCHAR2(20)
);
[Code]....
What is the best/a good way to display in alpha the total regarding the alpha_id ?
View 1 Replies
View Related
May 29, 2013
I am using Apex 3.2...I have the following sql in a report
select
a.jobid jobid,
a.jobid related_jobs,
to_char(a.startdate, 'dd.mm.yyyy hh24:mi:ss') startdate,
to_char(a.enddate, 'dd.mm.yyyy hh24:mi:ss') enddate
from jobs aI would like to show a count from another table where the jobid = jobid from the above sql.The problem is I don't know how to refer to the jobid in my extra sql.Here is my extra sql for the new count column.
(select count(1)
from jobs a, loghead b, dba_scheduler_job_run_details c
where a.logid = b.logid
and b.session_id(+) = c.session_id
and a.jobid = :P3_JOBID) no_of_related_jobs.
This will not work because :P3_JOBID is a page item.I have also tried #JOBID#, but got en error, as it was not recognised.
View 1 Replies
View Related
Nov 13, 2012
I want to show progress bar every time when page loads.
Progress bar is coming on the page. but it is not going off after page is loaded.Below is the code which i added for the Progress bar.
//written on Header Text of Page
<script type="text/javascript">
<!--
function html_Submit_Progress(pThis){
$x_Show('AjaxLoading');
window.setTimeout('$s("AjaxLoading",$x("AjaxLoading").innerHTML)', 100);
}
[code]...
I want only to show only page loads.
Apex Version : Apex 4.1
DB Version : 10g
View 2 Replies
View Related
May 14, 2010
I can't figure out how to configure the query editor to copy the column headers with the query results on to the clipboard?
View 18 Replies
View Related
Jun 11, 2012
I'm using apex 4.1.1 And i want to use a Date Picker item on my page. This works, but.. When a user selects a date you can see the date highlighted. But in the "textarea"corresponding tot the datepicker is not showing the date. This shows the date after clicking the close button.
I would like to show the date directly after selecting a new date.
View 7 Replies
View Related
Jun 11, 2012
I have leave application form based on the LEAVE table, it has the following columns,
leave_id(primary key)
emp_name
from_date
to_date
no_of_days
Statuswhen they entered the details and submitted the form the data will be stored in LEAVE table. later on the applied leave will be approved or rejected and the STATUS column will be updated. Is this possible to show the last leave applied status as a alert message when they are logging in ?
View 5 Replies
View Related
Nov 11, 2012
Is it possible to detect the status of Hide / Show Region.
I have three hide/show regions RX,RY,RZ. When an event EX happens, then region RX should expand and the rest of the region should collapse. When an event EY happens, then region RY should expand and the rest of the region should collapse.
........
...
We can use this JS on DA to change the status of a region:
$("RX.uRegionControl").click();
$("RY.uRegionControl").click();
.....But, first we need to detect the status to know where to apply that DA. ? I am working on apex 4.2. theme 25.
View 2 Replies
View Related
Jun 3, 2013
The following query is used to generate a flash chart:
select null link
'Available' as "Available",
to_number(max_licenses - consumed_licenses)
from software_detail
where capture_date = trim(GET_CAPTURE_DATE)
and software_product = :p1
and software version = :p2
[code].....
But the 2d doughnut flash chart shows:
Available = 39
Consumed = 1
How is this possible?
Oracle 11.2.0.3 RAC on Windows 2008 R2
APEX 4.2.1.00.0 with Apex Listener 2.0 on Apache Tomcat 6.
View 4 Replies
View Related
Dec 14, 2012
Im tring to dynamically hide/show page item. I searched and found something but it not working for me. Im using apex 4.1 and below described are work I did.
In my page (form) I have 5 fileds iitems.
- Customer No
- Edit
- First Name
- Last Name
- Address
I want to hide First Name, Last Name, Address based on the value in Edit. Let say if user selects "Edit First Name" then First Name must get visible while Last Name & Address hidden.
So I placed this line onChange="$f_Hide_On_Value_Item(this,'LASTNAME,'LN')" in page item EDIT> Label > HTML Table Cell Attributes
But it not working for me? Where am I go wrong?
View 2 Replies
View Related
Aug 4, 2012
I am using Apex 4.1 and theme 24. I have a hide and show region in a page with some validations. On any validation error the region refreshes and closes. I don't want the region to close on refresh except Submit.
View 2 Replies
View Related
May 30, 2013
issue with my apex line chart. The scenario is as follows: have a table called revenue. revenues per year are saved in it. and revenues are generated from three sources which are also saved in the same table. I have made a line chart on it. works well.
Now I have to show that if the value of one of the sources had fallen, how must have it affected the total. I made a number field that takes an estimated change value, and build my sql query with it. it works but the problem is that it changes the non-affected source too. it must change the value of the affected source only and hence the total value.
bold or I will put it this way, how can I write a select statement for a chart series so that one of the rows value does not change and the other two change.
View 2 Replies
View Related
May 3, 2013
I have a multi record field of five rows. And 3 values.
the values are
IT
CSE
ECE
And i have one text item name is COUNT.
how to show the total number of records in Text item .
View 10 Replies
View Related
May 1, 2013
i have a hidden region at the page top i want to show only after clicking my button which is running DA plsql code. This region is like a prompt message container/div at the top of the page so after few seconds like 10 secs i want to hide it again. I tried to use JQUERY but never hide it back, also i tried another TRUE CONDITION within my dynamic action but it doesnt reset it back the region is always shown...
View 2 Replies
View Related
