Reports & Discoverer :: Matrix Report With 2 Column?
May 7, 2010
I want to create matrix report with 2 column
we can assign one column in matrix report my req is to assign 2 column .
example
Row Is FND
columns are Cdate & Ldate
Cells are Crate & Lrate
CDATE CDATE CDATE CDATE LDATE LDATE LDATE
FND 01-MAR 02-MAR 03-MAR 04 MAR 28-FEB 31-JAN 31-DEC
-------------------------------------
ABC CRATE CRATE CRATE CRATE LRATE LRATE LRATE
ABC CRATE CRATE CRATE CRATE LRATE LRATE LRATE
ABC CRATE CRATE CRATE CRATE LRATE LRATE LRATE
XYZ CRATE CRATE CRATE CRATE LRATE LRATE LRATE
XYZ CRATE CRATE CRATE CRATE LRATE LRATE LRATE
XYZ CRATE CRATE CRATE CRATE LRATE LRATE LRATE
View 1 Replies
ADVERTISEMENT
May 20, 2010
I have to set a matrix report as follow:
- in the rows the machine_id.
- in the column the material_lib.
Table material ( material_id,material_lib,ordre)
- in the cells quantity.
I get successfully my matrix through the wizard of report, but i should display the columns sorted with the field ordre.
how to get the columns of the matrix sorted.
View 5 Replies
View Related
Dec 22, 2010
I am using oracle Dev 10g R2 in windows Xp. I have a matrix report and it will produce result correctly as the attachment1. Now I want to display this report as a same format. I would like to display 0 for those that does not exist in the query.
View 2 Replies
View Related
Nov 5, 2011
i have convert many report's in xls, but that report's are not group field's
but this report is group by field, so the data can not be fitted in correct position
View 1 Replies
View Related
Feb 25, 2011
I want to Fix Null values as 0 in Matrix Report. But i am not able to Do it...
let it be there is one item NUM1
what Sequencing and triggers(format trigger or else) should i follow on it with what code?
View 2 Replies
View Related
Nov 11, 2010
I want to show 1 record per page in matrix report. I set Main section orientation as landscape and width is 14. but it show multiple records on single page.
View 2 Replies
View Related
Jun 20, 2012
I am having a matrix report, which has its column cells from table A and row cells from table B when I run the report the columns and rows are not ordered I wrote the order by statement in the report query but there was no defference.
I also wrot a subquery like
select column1, column2, (select column3 from table1 order by code)
from .... but it seems I can not order in a subquery
Is there any way to do that
View 5 Replies
View Related
Feb 8, 2012
I have to create the matrix report which shows calender. Looks Like this.
View 14 Replies
View Related
Nov 3, 2010
I have developed simple matrix report using wizard. But now I want to do it manually.
View 3 Replies
View Related
Aug 22, 2007
how to generate matrix report to excel file. i have done this . but the exact layout is not getting displayed in the excel file. I have attache the layout i ma trying to export to excel.
View 8 Replies
View Related
Apr 7, 2011
Report 6i. I created Matrix Report . it is working fine.
I would like to know that it is possible If Matrix Report Cell do not have data then display any words like 'A'\
View 1 Replies
View Related
Nov 11, 2010
I want to Bold the value with highest value in Numeric field. how can i do this.
View 12 Replies
View Related
Apr 15, 2011
1) I am able to view the oracle report in PDF format in my Web Application, but when I tried to print this PDF on Line matrix printer, the characters are not printing rightly.
2) Can I take report output as a text file and and print it through DOS mode printing.
View 2 Replies
View Related
Aug 27, 2010
wanna to make matrix report retrieve months year and the number of weeks from dual table it supposes to the weeks number is 52 or 53 week months and weeks on the rows please find attach pic it show what i need to do for exmple
month name: January February March April May June July August September Nov October December
no of week : 1-2-3-4-5-6-7-8-9-10-11-12-13-14-15-16-17-18-20-21-22....... TO 52 week
View 5 Replies
View Related
Jun 20, 2012
1 problem regarding to oracle report 6i.
I have to hide a repeating frame based on different condition
like DEPTCODE = 1 THEN
return('true');
else
return('true');
end if;
there is 4 record when we select DEPTCODE = 1 and there is 25 records when we select DEPTCODE = 2
now my problem is when I choose DEPTCODE=1 the summary of that report like sum of sal, avg of comm is calculated based in all 29 records.
it happen because of all the summary column is placehoder column not CS.
the calculation of all placehoder column is complex I cant convert it in simple CS.
so how can it possible when i choose DEPTCODE=1 and it shows me summary of only 4 records.???
View 5 Replies
View Related
Oct 24, 2011
I want to design a report in different numeral(English,Arabic). I am using application server as a middle tier.
Like
empno name salary english salary arabic
34232 John 5000 in arabic digits
45454 Clark 6500 in arabic digits
I have already change environment as a parameter Eng to Arb or vice versa. but i need both language digits at a time.
View 3 Replies
View Related
Aug 17, 2011
I have done a matrix group report which displays the department codes as columns and main account as rows for a month my problem is there are two groups and in one group there is data for 5 departments and in other group there is data for 4 departments and in display if there is no data for one department it should come as fixed columns in order to make it more readable
.Is there any way where i can fake some null data and bring it as column or any other way.
View 5 Replies
View Related
Dec 12, 2011
I have a report and require the output in xls/xlsx (Excel) format. Currently following properties under System Parameters in Report Builder 6i have been made
Desname = The path for e.g: \C:sz-serverc$ihelp_workingxls
pt_sample_report.xls
Desformat = Delimited
Destype = File
The rest parameters has default settings I have not changed any of the rest User parameter.The report comes up in excel format but totally in distorted manner. i.e; All the column names of report are displayed first in vertical format followed by actual rows for the report.
The requirement is like this
[Select all] [Show/ hide]
Student ID Student Name Fathers Name Guardian Name
1 sample1 sample2 sample3
2 sample4 sample5 sample6
And it is displaying like this
Student ID Student Name Fathers Name Guardian Name 1 sample1 sample2 sample3
Student ID Student Name Fathers Name Guardian Name 2 sample4 sample5 sample6
View 2 Replies
View Related
May 30, 2013
I have a matrix report that shows production per year(horizontal) and per country(vertical). The customer's willing to see the data ordered by production, and not per country. I tried to add a CF containing the production in the country group and order by that one, but I'm getting a message saying that the field object cannot be contained into the frame. Both the field and the containing frame are set to Variable. how to get rid of the error or how to achieve the main goal of ordering by the cell content?
View 11 Replies
View Related
Jul 28, 2010
how could i rotate the text inside a matrix cell ??like
.......c....c....c
.......o....o....o
........l.....l.....l
.......#....#....#
.......1....2....3
----------------------
row#1
.......
row#2
.......
row#3
View 7 Replies
View Related
Jan 1, 2011
I got this error when try to run a matrix report
REP-1813 :Object F_2 too large to fit in matrix cell
how can i deal with this.N.B the report was working fine with no problems and suddenly happened this.
View 1 Replies
View Related
Nov 3, 2010
How can I Sort Ascending or Descending of Last Total Column of Matrix Report R6i i.e. F_SumsalPerempno, summing total salary of each empno at end of each row.
I need the employee paid highest amount of total salary during the year to appear on first row, while months to display as per original order.
View 2 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