Reports & Discoverer :: Fake Columns In Matrix?
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
ADVERTISEMENT
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
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
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
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
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
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
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
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
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
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
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 16, 2010
I want to create a report by using one field and one text as columns name in layout but display the all the columns. I mention the 5 column names in query.how can I write function in summary column.
View 4 Replies
View Related
Jul 25, 2011
I have the following 6 columns in a report. And i need a 7th column which is a calculated field (average of the first 6 columns), the problem is some of the records have a '0' value in them so the aveage is not always (SUM)/6, If one of the fields have a 0 then the average is (SUM)/5, likewise if 2 fields have o's in them then the average will be (SUM)/4, see the sample data set.
A B C D E F G(Average)
83 83 33 0 0 100
83 83 33 0 0 100
0 67 67 100 17 92
83 83 100 67 50 100
83 83 100 83 50 100
67 0 83 100 17 100
83 83 83 67 67 100
83 83 83 50 50 90
[Code]....
View 7 Replies
View Related
Sep 10, 2012
I have report where there are multiple columns and requirement is user may choose his own sorting order from form, any sample .rdf.
CREATE TABLE EMP (EMP_CODE VARCHAR2(12),EMP_NAME VARCHAR2(20),SAL NUMBER);
INSERT INTO EMP VALUES ('1','A',10);
INSERT INTO EMP VALUES ('2','C',3);
INSERT INTO EMP VALUES ('3','B',20);
[Code]..
--note order by is changing, how its doable in report 6i.
View 2 Replies
View Related
Feb 18, 2012
I have a small requirement for report, i want to develop a report based on dates and employee performance.Suppose i give the parameter from date as 01'st jan 2011 and end date as 31'st Jan 2011 then employee hrs will be as summary as rows distributed among days with the given date range as columns.How to make each day as column automatically.
View 5 Replies
View Related
Jun 4, 2012
I am adding a parameter to the parameter form of existing reports based on a select statement and has two columns. That part is fine. However, Oracle reports is adding a dash between the two values. Still fine, but I am also adding a UNION with ALL in case the user wants to run the report for all values. In the Parameter form it looks like this:
ALL -
RBC - 111
RRG - 234
TEB - 445
How do I get rid of the dash for "ALL" since I did not physically add it? Below is my select statement for the parameter I created:
SELECT code,
code_num
FROM codes
WHERE code_num <> 0
UNION
SELECT 'ALL', ' '
FROM dual
ORDER BY 1;
View 8 Replies
View Related
Jan 10, 2011
I have Two Parameters like 'YES' & 'NO'
when parameter is YES, column having values
when Parameter is NO, column having no values
In this scenario, how can i skip the column with space when parameter is NO because the column exist in middle of columns in report and Present with space when parameter is YES.
View 9 Replies
View Related
Feb 1, 2012
I have the following Union All query. It throws the following error in SQL plus
ERROR at line 27: ORA-01789: query block has incorrect number of result columns
After doing some google for the above error it suggests there are incorrect number of columns in the Union All query.I could not figure out the exact location well SQl Plus says error is on line 27 at the first opening bracket like
(Select distinct c.contact_code
Following is the SQL query
Select
tbl_contact.contact_code,
contact_title
||'.'||contact_name contact_name,
contact_address,
[Code] ......
View 1 Replies
View Related
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
Jul 5, 2010
how to Run a Discoverer Reports in a Forms Menu.
View 2 Replies
View Related
Dec 6, 2011
Is it possible to link to Discoverer Viewer from Forms without requiring the user to log in again. If so, can I then link to a specific Workbook within Discoverer?
View 2 Replies
View Related
Mar 19, 2012
When running my query in sql developer, I have to execute the command apps.fnd_global.apps_initialize(user_id, resp_id, resp_appl_id) in order to show the result of my query. Without this, the query returns nothing. The problem is I am using this query as a custom query for my Discoverer report and my report does not show any record.
View 3 Replies
View Related
Nov 9, 2011
I need to copy my discoverer report from dev to prod. How should I do this? Are the items created using calculation in the report can also be copied? These items are not present in the folder in discoverer admin.
View 1 Replies
View Related
