How can I make report in below format ?
Month Apr-09 May-09 Jun-09 ...... Mar-10 Total
Basic 1000.00 1100.00 1300.00 ...... 1300.00 13260.00
HRA 500.00 600.00 650.00 ...... 600.00 6350.00
Conveyance 100.00 200.00 300.00 ...... 350.00 1300.00
Gross Amt 12350.00 13500.00 13200.00 ......14500.00 23456.00
I want to make report of processing time for tasks. Every task has several stages and connected with them modification dates. I need calculate total processing time for every task.
In my calculations i have to consider only "working" hours. There is time window table (For example working hours: from 8 a.m to 4 p.m, but can be different thats why i use table with id - different id = different time window). Scripts i used to simulate problem:
create table t (
id number,
s_date date,
e_date date
);
declare
[code]........
table t constrains "working" hours:
12011-04-10 08:00:002011-04-10 16:00:00
12011-04-11 08:00:002011-04-11 16:00:00
...
but could be also
22011-04-10 09:00:002011-04-10 17:00:00
22011-04-11 09:00:002011-04-11 17:00:00
...
table w contains tasks history processing by team (8 hours for tenet, rest time (out of hours defined in table t) of working trough incident should be ignored/omitted in calculations):
12011-04-10 10:00:00
12011-04-11 02:08:16
12011-04-11 16:23:10
22011-04-12 08:12:30
22011-04-13 00:40:15
32011-04-14 09:37:54
32011-04-14 15:54:36
32011-04-15 06:40:44
32011-04-16 09:48:06
32011-04-16 20:06:01
32011-04-18 14:11:29
At the beginning I tried this query, but I don't know how consider/dose time window from table t
select id, change_date,
round( to_number(change_date-lag(change_date) over (partition by id order by change_date))*24*60*60) sec
from w;
12011-04-10 10:00:00
12011-04-11 02:08:1658096 - sholud be 21600 (sum time only for 2011-04-10 16:00:00)
12011-04-11 16:23:1051294 - should be 28800 (sum time only from 2011-04-11 08:00:00 to 2011-04-11 16:00:00)
22011-04-12 08:12:30
22011-04-13 00:40:1559265 - should be 28050 (sum time only from 2011-04-12 08:12:30 to 2011-04-12 16:00:00)
32011-04-14 09:37:54
I have a payment table that has the ids of cds that has being sold in the past month. From there I want to make a demand wise report. I am aware of the report wizard in the oracle forms but I dont want to use it. Here are the tables in a bit more details.
payment: id_cd, price, dateofsell
cd_details: id_cd, name, price, language.
How to make report high 3.33 inch per page. so if there are more than one page in the report it will start printing in the correct position on the next page,
i make generate to PDF then print.
I have one view which displays the information of all the receipts with date now i want to make ageing report based on this date. the columns will be 0-30 , 30-60,60-180 and > 180 , i want to distribute the receipts qty based on number of days.
View 1 Replies View RelatedI have created a master-detail form. The detail columns are created as report columns instead of getting created as Items. I need to make a column non-editable.
View 1 Replies View Relatedi want to use Graphic builder for make a chart in report builder. how can i use them for create a chart report? i need to see some samples for create my project. put a sample of .OGD and .rdf
View 6 Replies View Relatedhow to make a form with report and an insert form in the same page, these two forms are related to the same table. Our customer wants a user can add new row to the table in a form and see all of rows created by this user in a report, this report should provide edit link as well. the problem is: whenever I inserted a new row or edit a row or delete a row, and submitted, and return to this page, all of hidden items lost their values, so report is blank, and some display only items also lost their values.
View 6 Replies View RelatedHow can i print a report name with full path at left bottom on report.
View 3 Replies View RelatedHaving this issue in Apex 4.1.1 and 4.2 (haven't tried it in versions prior to 4.1.1 yet). So I got my standard IR, and trying to create a private report with control breaks, aggregations.
Once I save it as a private report, It applies the same on my primary report.
It's no big issue as I can flip back to Primary report and delete the control breaks, aggregations but is some kind of bug? Ideally it shouldn't modify my primary report unless I try to save it as "Default Report Setting".
How do I create Items context help editable report or report & form app?
what is its table?
I am trying to open report in parameter form in drill down report.
View 7 Replies View RelatedI have a Page containing 3 reports and I was wondering if it is possible to re-execute only one of the these reports using a button or preferably a Select List which allows me to choose which of the 3 reports I wish to 'refresh/re-execute'. I may be totally wrong here but I assumed that choosing the option to submit a Page will cause all regions to refresh i.e. re-execute the SQL queries they are 'based on'.
View 6 Replies View RelatedI had report A which drill down to report B. While drilling down to report B, The parameter form of report B should be displayed which accept parameter code and then open the report B. My parameter form is displayed but not accepting the input. i am using the hyperlink to display the second report. Is there any cgimap.bat file to be configured for the parameter report? If yes then how to configure this file?
View 1 Replies View RelatedI have a Report Region with Type SQL Query and Source "SELECT * FROM <table>" where <table> has a primary key from a sequence. Under Report Attributes, I have Report Column "ST_NM" with Show and Sort checked and having a Sort Sequence of "1". I assume this is to set the iniital display sequence but regardless, the report rows display in Primary key order initially.
To try it: [URL]
1) How do I set the initial display sequence to be other than the primary key sequence?
What is the code/javascript/url behind the test report button on report queries component?
We are having DSN problems using the print url given on the report query. The URL works for some of our developers and not for others.
The test report button on the report query appears to work for everyone but I do not know what is behind the "Test Report" button. If I could recreate the test report button on our page this would be GREAT!
i made a matrix report using report builder 6ii want to export all report data into excel.
View 0 Replies View RelatedI have to implement IR report search functionality (*when ever we click on column header it will display all the values in that particular column , once we click on particular value , the report will filter based on that particular value * ) in classic report .
View 8 Replies View RelatedIs there any way of stopping the report from executing in Before-Report Trigger.
Actually what i am doing is to see whether some records are present there in the table in Before-Report Trigger on which the report is going to print. Because I am doing some updates in After-Report trigger. I want to stop if there is no records present in the table in Before-Report Trigger so the report will not go forward to After-Trigger of the report.
how to stop and by using which statement.the other way so that if report has no data then After-Report Trigger should not fired.
I have created a classic report in Apex. Have enabled the print PDF link on the report for the business users to download it in a PDF format. Is is possible to put a logo in a downloaded PDF from the report?
View 0 Replies View Relatedi am writing a script for inserting rows in a table where primary key of that table consists of 4 columns. I want to add a new row where 3 columns of that table will be same but change the value of the last one. this is giving an error saying that i am violating the unique constraint. I tried to disable that constraint/PK by following statement but still this error is coming
alter table sections_budgets modify primary key disable cascade;
OR
alter table sections_budgets modify constraints sec_bdgt_pk disable cascade;
the insert statement which i am using. The first four columns are part of PK
insert into sections_budgets (SELECT sb.bdgt_cd, sb.bdgt_dpf_cd, sb.bdgt_yr, :sec_code, sb.usf_usr_id,
sb.aty, sb.comaty, sb.comytd, sb.expn_ytd, sb.sys_dt, sb.cat,
sb.start_aty, sb.expn_lmt
FROM sections_budgets sb
WHERE sb.bdgt_dpf_cd = :b_d_code AND sb.bdgt_yr = :year);
is there any other way of inserting records in this table without droping the whole table because it contains too many triggers and constraints?
On a page I have let's say 5 rows (can be more or less) and each row ends with a checkbox. On the next page(next prcodure) I go through all rows, but I get a "No data found" when a checkbox is not checked. Checkbox's parametre is send using an array.How can I make sure is a checkbox checked or not. If it's not, I put a formHidden through in it's place?
View 1 Replies View Relatedi have multiple inserts to make in a table that is in an Oracle database...i already try several ways to do it but it always giving erros... how to make multiple inserts at same time.
View 2 Replies View Relatedhow should i do to make horizontal partitioning?
View 18 Replies View RelatedI want to learn how to make columns out of records?
View 8 Replies View RelatedHow to make a call to a proc and immediately return without waiting for the called proc to end.
Nothing I try seems to do the trick...The calling program always has to wait.
I have read the messages below about making a calendar but am still unsure of how to go about doing this. I have the STNDRD20.OLB file, but I don't know where to put it or what to do with it! What comes next?
View 20 Replies View RelatedHow to make a node of a Hierarchical Tree BOLD without intervene java code ?
View 1 Replies View RelatedI want to make default 'y' for COL1 how should i make it.1) "COL1" NCHAR(10) DEFAULT N'y'or 2) "COL1" NCHAR(10) DEFAULT 'y' yours sincerly
View 5 Replies View RelatedWell I need to make a trigger that don't allow delete departments in the next 3 month.
I dont know how to start it :/