Reports & Discoverer :: Detail And Summary In One Report
Aug 25, 2012
I have one group wise report and my requirement is i need to print both the Outputs in one single report first, is group with details and the summary in the last page showing machine code and summary of qty as totals ,I have given below test case .
create table ot_cut_detail (mach_code varchar2(12),batch_code varchar2(12),pos_no varchar2(12),pos_qty number)
insert into ot_cut_detail values ('L1','01','1001',2);
insert into ot_cut_detail values ('L1','01','1002',2);
insert into ot_cut_detail values ('L1','01','1003',2);
insert into ot_cut_detail values ('L2','01','1004',2);
insert into ot_cut_detail values ('L2','01','1005',2);
SQL> SELECT * FROM OT_CUT_DETAIL;
MACH_CODE BATCH_CODE POS_NO POS_QTY
------------ ------------ ------------ ---------
L1 01 1001 2
L1 01 1002 2
L1 01 1003 2
L2 01 1004 2
L2 01 1005 2
--Detailed output is like this as below
MACH_CODE BATCH_CODE POS_NO A
------------ ------------ ------------ ---------
L1 01 1001 2
1002 2
1003 2
L1 Total 6
L2 01 1004 2
1005 2
L2 Total 4
Grand 10
--Summary report will be as below both in one report.
MACH_CODE BATCH_CODE totals
------------ ------------ ---------
L2 01 4
L1 01 6
View 14 Replies
ADVERTISEMENT
Jul 19, 2013
my report is based on two tables.master and detail. i am using GROUP ABOVE style.displaying master tables columns up and detail table columns down.
my problem is ...i want 3 columns from master table (i.e)RECEIVER ID,RECEIVER NAME and RECEIVE DATE to be printed at the bottom of the page.
and also i want only 4 records from detail table to be printed on each page.
View 1 Replies
View Related
Mar 26, 2012
I have been sweating on this since the weekend.
My source table
SELECT
'182383' EMPLOYEE_NO
, 'ABACUS' FULL_NAME
, 'ADMIN' DEPARTMENT
, 'ADMIN' PREV_DEPARTMENT
, TO_DATE(20090104,'YYYYMMDD') EMP_START_DATE
[Code]....
EFFECTIVE_START_DATE: SCD field, Date ABACUS moves from one department to another.
EFFECTIVE_END_DATE: SCD field, Date ABACUS left the department from another. To keep history of movement.
The sample report shows possible scenario on my data.
I want to build monthly report to cater from departmental headcount on monthly basis, starting from from ABACUS start date.
see sample report below
MONTH | DEPARTMENT |NEW_HIRES | RELOCATION (OUT) | RELOCATION (IN) | NET TOTAL PREV MONTH | NET TOTAL PRESENT MONTH |
WHERE
MONTH: REPORT MONTH
DEPARTMENT: THE DEPARTMENTS IN THE ORGANIZATION
NEW_HIRES: NUMBER OF NEW STAFFS HIRED THAT MONTH BASE ON EMP_START_DATE
RELOCATION_OUT: NUMBER OF STAFFS MOVEMENT TO ANOTHER DEPARTMENT (EMP_END_DATE IS NULL, EFFECTIVE_START_DATE AND
[Code]....
View 4 Replies
View Related
Mar 29, 2012
I have a report w/ master group and detail group and at the report level I would like to display a text based on a value of a field in the detail group. I created a column placeholder at the report level and then assigned it a field value in the detail group. I wanted to show my text based on this value, but it did not work.
View 5 Replies
View Related
Apr 9, 2013
we have just upgraded discoverer from 3.1 to 4.1
and we click on create summary folders we got this error Summary management not available because : this user has no privilige or quota to create materialized view in the current schema External summary registeration not available because : this user has no privilige or quota to create materialized view in the current schema
altough i granted privilige for materialized view
View 1 Replies
View Related
Sep 8, 2013
See my data
Location--------Employee-------------Sales-----------------------Sales per emp
1------------------ 4-----------------------100------------------------------25
2------------------ 5-----------------------120------------------------------20
3------------------ 7-----------------------210------------------------------30
Total---------------16-----------------------430-----------------------------27
The total 27 achieve by (430/16)=27 How can I get using ORacle BI Discoverer 11g Desktop
View 7 Replies
View Related
Jun 30, 2011
When i create report in master detail. When detail record end on the page, the second record show on same page. Problem is that detail show on other page. I want that if record is completed on that page then ok. Otherwise it show on next page.
View 3 Replies
View Related
Sep 20, 2012
How can i print a report name with full path at left bottom on report.
View 3 Replies
View Related
Nov 29, 2011
I am trying to open report in parameter form in drill down report.
View 7 Replies
View Related
Dec 19, 2011
I 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 Related
Jun 23, 2010
When I try to manage the report the Discoverer application frozen.
View 5 Replies
View Related
Jul 24, 2011
Is 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.
View 2 Replies
View Related
May 28, 2010
[Message #1] how to get a unapplied receipts for ageing report? and RMA(credit and debit note)columns ?
Which tables should be refered for Ageing reports.
[Message #2] How to create an ageing report in discoverer?
Which tables should be refered for a Ageing reports.
Ageing report colums customer name, customer id,location,segment, credit note and debit note in different column,unapplied amount and applied amount in a different colum.Already i got a due remaning date and total amount I want a linked table names.
View 1 Replies
View Related
Aug 23, 2011
How to merge multiple reports in one report in reports 6i.
View 1 Replies
View Related
Aug 31, 2010
I created two reports separately.
1.pub.jsp
2.serc.jsp
what i need is i want to call the report serc.jsp from pub.jsp .
View 6 Replies
View Related
Aug 17, 2012
How to Call a Report from a Report?
Not from a form but a Report from a Report?
View 3 Replies
View Related
Sep 25, 2012
I am facing problem while printing from the Oracle Report.. Web.show_document does not print the output of RDF file directly on the printer.
View 1 Replies
View Related
Dec 6, 2012
The code works great for few reports and for few reports it gives an error saying Unable to run the reports in 10g, When i checked the job status it says Terminated with error: <br>REP-163: Invalid value for keyword DESTYPE. Valid options are FILE, PRINTER, MAIL, INTEROFFICE, or CACHE.
I have kept the DESTYPE as CACHE. It is failing at Run_Report_Object(ReportId, Pl_Id)
View 3 Replies
View Related
Oct 19, 2011
How can I run my report in my main menu or fort page for example I want to run my report when user click a button. What will process?
View 5 Replies
View Related
Oct 6, 2010
We Implemented Unicode facility in our application, in forms its working fine. But, while running report in pdf arabicCharacters are not displaying Properly.
we did the following settings in uifont.ali
[ PDF:Subset ]
Arial..Italic.Bold.. = "Arialbi.ttf"
Arial...Bold.. = "Arialbd.ttf"
Arial..Italic... = "Ariali.ttf"
[code]...
View 3 Replies
View Related
Apr 30, 2013
I want to create report using this query, is there any option?
declare
cursor c2 is
select epi_id, epi_code, epi_name
[Code].....
View 4 Replies
View Related
Nov 4, 2010
Have there any limitation on report key(Number of report key) on cgicmd.dat file?
REP-52005: The specified key mrr does not exist in key map file.
But this key 'mrr' exists on cgicmd.dat.
View 1 Replies
View Related
Oct 3, 2011
i'd like to fit two pages in one report. i.e i'd like to divide A4 paper into 2 pages. How to do that in report 10g . like in the PS
View 2 Replies
View Related
Apr 12, 2011
I am beginner to reports working on reports 10g..Actually i have to print addresses of customer on a report. Using one of the layout style i am trying that. But i have a requirement. i need to print only the city name. they should not be any town.. How can i format when town field is null then i should not show town in the report?
View 1 Replies
View Related
Jul 6, 2011
i used below code to call Report from Form
Function to call procedure to run report:
DECLARE
report_id Report_Object;
v_report_other VARCHAR2(4000);
vc_connect varchar2(50);
BEGIN
--Call run_report_object
[code]......
its showing report output in a new window, but problem is that if i copy the url, then close current report browser window, start new IE session and paste the copied url it showing the same report... but i don't want to allow this and want to Kill the current job id ( while it displaying the same report ), how i can do this?
View 1 Replies
View Related
May 14, 2013
How can I run an AWR report through SQL Developer? I do not have EM installed on my Oracle 11g database.
View 1 Replies
View Related
Sep 14, 2010
when i open one pdf report hyperlink is attached in this report & we can open again a new report through this hyperlink when i click on this hyperlink & return back to main report then it is starting from first page
suppose i m in 4 page & use hyperlink & open new report after that when i return back to main report it starting from first page..is there any solution so that i will return back on same position from where i have click the hyperlink instead of first page
View 4 Replies
View Related
Jun 27, 2011
A drill-down report (B) is called from another drill-down report (A) which opens correctly, but when I close report (B) all reports including the master report are closed automatically.
View 4 Replies
View Related
Feb 3, 2012
I'm calling sub drill-down report (Report C) from a drill-down report (Report B) using buttons. Report opens correctly but when I tend to close the sub drill-down report (Report C), all reports in hierarchy including the main report (Report A) also close down after raising an exception "An un-handled win32 exception raised in RWRBE60.EXE [3300]"
Report Calling Sequence:-
Main Report => Drill Down Report => Sub Drill Down Report
View 3 Replies
View Related
Oct 1, 2013
I am developing One new Label Format report (Totally three Different label Format)each label Different size,Three different printer.
How to default printer on each reports
View 2 Replies
View Related