Reports & Discoverer :: Reference Fields In Detail Group At Report Level

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


ADVERTISEMENT

Reports & Discoverer :: Master-detail Report ( 3 / 4 Columns Detail To Be Printed)

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

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 View Related

Reports & Discoverer :: Get Graph Output At Report Level?

Dec 24, 2010

get Graph output at report level.

View 1 Replies View Related

Reports & Discoverer :: Any Option At Report Or Template Level

Aug 6, 2010

i am having requirement that i want a total record on single page.is there any option at report level or template level.

(if on header has 2 to 3 lines then it will come in one page but if there is one header with above 20 line then it will not come in one page if there any option to be set to full fill such a requirement.)

View 4 Replies View Related

Reports & Discoverer :: Getting Runtime Sequence Number At Report Level?

Jan 21, 2011

how do i get runtime sequence number at report level.

View 1 Replies View Related

Reports & Discoverer :: Building Across / Down Group Report?

Nov 25, 2012

I have an Across Group Report, but can't create a design / layout what i want (explained more detail as shown on the images).

Current report when it's running:

[URL]

The final layout that what i want:

[URL]

Environments:

- Oracle Developer Reports 10g R2
- Oracle Database 10gR2

View 2 Replies View Related

Reports & Discoverer :: Exclude 1 Group In Report?

Nov 29, 2010

I want to show all the data except 1 organization, Report is grouped on organization.

View 2 Replies View Related

Reports & Discoverer :: Selective Sorting On Report Group?

Dec 11, 2010

I have a Group report based on one group.For eg..there is machine (Group) and it has detail records .The problem is there are certain specific machine on which i want sorting to be done the rest will be not sorted.

machine WX
Details not be sorted
machine sh4
Details to be sorted
machine sh5
Details to be sorted
machine AN1
Details not to be sorted

View 12 Replies View Related

Reports & Discoverer :: Group Report From View Sort Differently?

May 20, 2011

I encountering while giving ORDER BY CLASS at report query.

View was created from Master and Detail table with simple join after this i created group above report with order by ID (Varchar2 , Values like 0010101001) but in report it order ruffly( not ascending or descending but randomly) .

View 3 Replies View Related

Reports & Discoverer :: Moving Fields In Oracle Reports?

Nov 13, 2010

In my requirement i have to move a field from bottom to the first page of report. I try to drag the field but i think it's in multiple frame .i am very new to oracle how can i work with multiple frame in layout wizard.

View 2 Replies View Related

Reports & Discoverer :: How To Add Fields From Another Database To EUL

Sep 9, 2010

I am trying to add fields from an SQL server database to the EUL. We have a lot of Oracle tables and fields in the existinging EUL, and we have created a database link from the Oracle database to the SQL database. But how can I find til SQL database tables and fields in Discoverer admin?

View 1 Replies View Related

Reports & Discoverer :: Divide Row To Same Fields

Jun 28, 2011

i want to divided report to same fields such as

above
account_no , account_name , account_date
120 industry 1-1-2010

middle
account_no , acccount_name , account_date
121 medical 1-1-2009

bottom
account_no , account_name , account_date
122 financial 1-1-2008

View 11 Replies View Related

Reports & Discoverer :: Master Detail Record Show One Page

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

Reports & Discoverer :: Unable To Move Fields?

Mar 26, 2012

I am modifying an existing report. It's just a tabular format with column headers. I selected all fields and frames and turned confine mode and flex mode OFF. I need to add another column to this report so I tried to resize and then move some of the fields.

If I try to move the right side of a colum header/field in, to make it smaller, it won't let me. I can move the left side of the field in, but then it won't let me move the entire field or column header to the left. If I try to move a field over to the right, all the fields to the right side move along with it. Doesn't this normally only happen when flex or confine mode are ON?

View 1 Replies View Related

Reports & Discoverer :: Appending Data Fields To Text?

Jul 29, 2011

I know how to append fields to text, but how do I deal with the variable length? I want to place text on a report and inside the text I have data from two different fields. It works great except that my fields are 35 characters long. If the data fills the entire field it looks great, if the data is only 10 characters long, I have a huge gap between the end of the data and the text that follows. How do I fix this?

View 3 Replies View Related

Reports & Discoverer :: PDF Group Wise?

Aug 11, 2010

Report have one parameter para name depatwhen i go to generate pdf it will ask me which dept if i pick 10 then they generate one pdf if i pick All Dept then they generate again one pdf i need seperate pdf like 10,20,30,40 generate four pdf files

View 8 Replies View Related

Reports & Discoverer :: Page Break On A Group?

Jun 5, 2003

I have a report with 4 groups one above the other and there is data such that each group has certain number of records for a particular value. Now what I want is, to have a page break after each set of data for all the groups. Can this be achieved using format triggers ?

View 3 Replies View Related

Reports & Discoverer :: How To Spill The Group To Next Page

Oct 28, 2010

what i need to do so that the Group shown by the RED arrow spills over to next page ?

The image shows that my report is grouped into 4 Levels. Do i simple create a Page Break on Last Group ?

View 20 Replies View Related

Reports & Discoverer :: How To Print A Report Name With Full Path At Left Bottom On Report

Sep 20, 2012

How can i print a report name with full path at left bottom on report.

View 3 Replies View Related

Reports & Discoverer :: Can Create Drill Down Report With Parameter Form Of Report

Nov 29, 2011

I am trying to open report in parameter form in drill down report.

View 7 Replies View Related

Reports & Discoverer :: Can Create Drill Down Report With Parameter Form For Report

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

Reports & Discoverer :: During Open Report The Discoverer Application Frozen?

Jun 23, 2010

When I try to manage the report the Discoverer application frozen.

View 5 Replies View Related

Reports & Discoverer :: Anyway To Stop Report In Before-Report Trigger

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

Reports & Discoverer :: How To Create Aging Report In Discoverer

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

Reports & Discoverer :: How To Merge Multiple Reports In One Report In 6i

Aug 23, 2011

How to merge multiple reports in one report in reports 6i.

View 1 Replies View Related

Reports & Discoverer :: Creating Data Link Using A Column Only Selected In One Group

Dec 14, 2010

I have a report with 2 groups Gheader and Glines.The report looks at PO headers and lines. I want to create a data link from the the 2 queries based on the line id in po_lines_all.However I only want to select this in the lines query so I do not get repeating records at the header query.

View 11 Replies View Related

SQL & PL/SQL :: How To Declare A Variable Which Reference Level Type

Aug 5, 2010

I have a problem :

In package head I declare a variable , which reference 'level' type , but I don't know how to declare the variable , because I don't know what type of 'level'.

View 9 Replies View Related

Reports & Discoverer :: Calling Report From Another Report

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

Reports & Discoverer :: How To Call A Report From A Report

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







Copyrights 2005-15 www.BigResource.com, All rights reserved