Reports & Discoverer :: Display Data Vertically (landscape Format)?
Apr 19, 2013I need the data in this below format.
I added the image...
ADVERTISEMENT
Reports & Discoverer :: How To Change From Portrait To Landscape Report
Aug 7, 2011I am modifying one report which was in Portrait fashion. Now I had added more details and make the report to print in Landscape fashion. I had changed the parameters of header, body and trailer under Page Output heading in Oracle Report builder 10g. like making width 11, height 9.5 and printing fashion as Landscape. But I am having a problem. The report is printing in landscape but half of the report came on the paper and half remain empty. I have tried to adjust the scale but this didn't work. Can I correct this report or I have to make new one with landscape fashion from the beginning?
View 10 Replies View RelatedReports & Discoverer :: Change Format Of Figure Display On Bar Graph?
Aug 18, 2009how i can change format of figure display on bar graph(data labels) in oracle 10g graphical reports .i want to change format fom 99.99 to 9999 .
View 1 Replies View RelatedReports & Discoverer :: REP-1814 Report Cannot Be Formatted Object (vertically) Can Never Fit Within B_49
May 1, 2005I am facing error message: rep-1814 report cannot be formatted onject "vertically" can nver fir within the _49 Error in a specific Computer alone when i run a report. When i run the report in any other PC its working fine. I am yet to reinstall the Developer 2000 S/W.
View 12 Replies View RelatedReports & Discoverer :: Data To Be Taken In Different Format
Dec 2, 2012I have one table storing all the information about employye, i have to develop three different reports based on the same table with different groupings , is there a easy way to call each format differently using single interface ,something like ref cursor.I dont want to create two or 3 different reports , instead choose the format.
CREATE TABLE OT_JOB_DET
(
JT_TXN VARCHAR2(12 BYTE),
JT_NO NUMBER,
JT_DT DATE,
[Code].....
Reports & Discoverer :: Unable To Read Data In Image Format
Feb 5, 2013I have a database in access 2003 with the empno,empname and photo (bounded image). Using queries and an ODBC connection I have inserted the table into Oracle 8i (8.1.7). When I try to read the data using reports I get 'REP-1818 Unable to read data in image format.' error for the photo field.
View 5 Replies View RelatedReports & Discoverer :: How To Display Data Using User Variable
May 27, 2010following is my query model
SELECT INV.VENDOR_ID,inv.invoice_date,inv.po_header_id,
INV.INVOICE_ID,
INV.INVOICE_NUM,
[Code]....
WHAT i have to write in select field
Reports & Discoverer :: Matrix Report Cell If No Data Then Display (A)
Apr 7, 2011Report 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'\
JDeveloper, Java & XML :: Concatenate Strings To Print / Display Vertically
Feb 16, 2011I created a sample application in java which concatenates three strings and displays the result in a final string.
Check the -
public class conCat
{
public static void main (String[] args)
{
String Message1 = "This ";
String Message2 = "is a Sample ";
[code].......
This is a Sample Application
And the three strings are concatenated to the final string "Message" only. How to concatenate them vertically? The required output is :
This is a sample Application
Reports & Discoverer :: Text Bold - Format Particular Word In Oracle Reports At Runtime?
Nov 2, 2010I have a doubt; can we format a particular word in oracle reports at runtime..?
Ex:-
A text filed contains data Quote:We request #BANK# to finance the same Bill as per agreed interest rate and other terms and conditions agreed on the above addendum and immediately remit the proceeds to our account A/c no. #ACCOUNTNO#, held with your Bank.
We need to make #BANK#, #ACCOUNTNO# are bold at runtime, Is there any method to format characters at runtime..?
Reports & Discoverer :: Oracle Reports In Excel Format
Jan 14, 2010The environment of my company consist of an ERP system developed using Oracle Forms 4.5 and Reports 2.5. Now, due to increase in business activities, there is a lot of requests from users for reports in Excel sheet.
Our company is planning for Oracle ERP Rel 12....and it is under process of analysis..due to which there is no chance of upgrade to latest Developer Suite.
As of now, to fulfill user requirements of Excel based reports...what do you think is best and permanent solution? Is there any plug-in or Business Process or Business Intelligence application llike ORACLE BI Spreadsheet plug-in..which meets our demand.
As of now provide users with options to run the report and generate output in HTML format, from there, they copy it to Excel..but this process is not at all user friendly and feasible.
Reports & Discoverer :: Number Format
Oct 20, 2011I have a value 233560.66 but in report its showing 233560.67 using format NNNGNNNGNNNGNN0D00 but when i remove format it shows 233560.665 but i want result 233560.66
View 2 Replies View RelatedReports & Discoverer :: How To Format A Report
Apr 12, 2011I 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 RelatedReports & Discoverer :: Report In Excel Format
Nov 16, 2010i m using oracle 10 report when i convert this report into excelformat and open in excel file then setting of this report is not proper ...how i can set this report
View 4 Replies View RelatedReports & Discoverer :: Show Date In DD/MM/YYYY Format
Jan 2, 2013I have a date column , and i want to show the date in 'DD/MM/YYYY' format for eg days with 2 digit or comming properly but when it comes to single digit the 0 is not comming for example 4/11/2012 should come as 04/11/2012 like 16/11/2012 , i even did the conversion like to_char(rh_dt,'DD/MM/RRRR').
View 4 Replies View RelatedReports & Discoverer :: Document To PDF - Image Format For Best Quality
Jun 29, 2010i'm generating some document to pdf and sending them to a company. When they print them out the images in the pdf aren't very good, although they look ok in the pdf. i think it's a gif format at the minute.
what is the best image format for the best quality?
Reports & Discoverer :: Format Delimited (Tab) Showing Duplicates?
Mar 25, 2011 When I am printing a report in Delimited report format using the default delimiter "Tab", the heading lables is getting printed for all rows( which is fine ) and extra rows of heading labels is getting printed.
Ex:
If I have a heading labels Deptno, Dname and Loc and related data which I print in delimited format, the output will be as follows:
Deptno Dname Loc 10 Accounting NewYork
Deptno Dname Loc 20 Research Dallas
Deptno Dname Loc 30 Sales Chicago
Deptno Dname Loc 40 Operations Boston
Deptno Dname Loc Deptno Dname Loc
Other report formats are working fine.
The same report in different application server environment is working fine.
Reports & Discoverer :: How To Display Matrix Report
Dec 22, 2010I 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 RelatedReports & Discoverer :: Convert Oracle Report To Excel Format
Nov 10, 2012i m using oracle 9i (9.2.0.8.0) & developer 2000..I am getting below mentioned error when i convert Oracle Report to excel format.
"Report Builder
REP-1401:'afterreport':Fatal PL/SQL
error occurred ORA-43356 : Message 43356
not found; product = RDBMS ; facility = ORA "
Reports & Discoverer :: How To Create Parameter Form In Descriptive Format
Jan 28, 2013I have developed report in reports9i and executing this report at application server but the parameter form is not displaying as its displayed in report builder.
parameter form isn't in descriptive format like you can check the department field. how to create parameter form in descriptive format or I am doing any mistake?
SQL & PL/SQL :: Display Data In Grouping Format
Oct 13, 2010I have a query on displaying data as per my requirement. I have created a table called sales it has four columns
create table sales(country,state,district,sales);
and am inserting some same data
insert into sales('india','TN','Chennai',100);
insert into sales('india','TN','KPURAM',120);
insert into sales('india','TN','Bangalore',35);
insert into sales('india','ANDR','Guinder',100);
insert into sales('india','ANDR','Nellai',76);
insert into sales('london','city-a','xstreet',89);
insert into sales('london','city-a','binroad',100);
select * from sales;
country state district sales
india TN chennai 100
india TN KPURAM 120
india TN Bangalore 35
india ANDR Guinder 100
india ANDR Nellai 76
london city-a xstreet 89
london city-a binroad 100
the data is displayed in this format. How i am trying to display data.
SQL & PL/SQL :: To Display Data In Range Format
Apr 25, 2012I have a table where multiple combination of records are store and i want to display data in range format as below, there is any way to group data as below.
create table ot_shop_Rec ( item varchar2(12), it_name varchar2(20),rev number, qty number)
drop table ot_shop_rec
insert into ot_shop_rec values ( '1018001-1001', 'COL',0,10);
insert into ot_shop_rec values ( '1018001-1002', 'COL',0,10);
insert into ot_shop_rec values ( '1018001-1001', 'GRID',0,10);
insert into ot_Shop_rec values ('1018001-1003','COL',0,10);
I WANT THE OUTPUT IN REPORT LIKE
ITEM RANGE DESC QTY REV
1018001-1001 - 1018001-1003 COL 30 0
1018001-1001 GRID 10 0
Reports & Discoverer :: How To Get Profile Values To Display In RDF Report
Jul 3, 2012how I can profile values to be displayed in RDF report.Here is what I have in my before report trigger
srw.USER_EXIT ('FND SRWINIT');
apps.fnd_client_info.set_org_context(FND_GLOBAL.ORG_ID);
:CP_Fnd_User :=FND_GLOBAL.USER_NAME;
:CP_CompanyName := FND_PROFILE.VALUE('xx');
When I print the value of the user name it gets printed fine.But when I print the place holder column value for the profile I get null.
Reports & Discoverer :: How To Present Report In XLS Format With Proper Column Headings
Dec 12, 2011I 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
Reports & Discoverer :: Display Text Item In Second Page Of Report
Jul 12, 2010I have a Report With Group G_Emp, having Columns Eno, Ename etc. in a Repeating frame R_1 and I have put A frame below this repeating frame R_1 with a Text Item Just for Displaying Comments, so just i want to display this Text Item in the second page and the Employee details in the first page, the restriction is that the Text item should not print in the first page.
View 2 Replies View RelatedReports & Discoverer :: Change Number Of Column Display According To The Condition
Apr 18, 2012Recently I am facing a problem while working with Oracle reports 2.5.
My requirement is:
there is a report in which there are 5 columns right now. Now what i want is, whenever a condition will satisfy , a new column should be also display in that report otherwise it must be stay as it is.
Previously : a b c d
Now if a=1 : a b z c d
else
a b c d
where a,b,c,d,z are columns.
Reports & Discoverer :: Hide One Frame And Display Other Depending On Parameter Value
Aug 22, 2010I want to hide one frame and display the other depending on the parameter value . How could i make that ?
View 1 Replies View RelatedReports & Discoverer :: Formatting - Display Value Of Field In Single Line
Oct 20, 2010I have developed one report but need one formatting suggestion. There is one field called "DESCRIPTION", I want the value of this field to be displayed in a single line. Now the big values are wrapped into multiple line.
Now,
DISPLAY
----------------
This is a Oracle
Report.
I want,
DISPLAY
------------------------
This is a Oracle Report.
Maximum size of "DISPLAY" field is VARCHAR2(240).
Reports & Discoverer :: Unable To Open Report In Microsoft Office Excel Format
Jul 6, 2010I m trying to open Report in Microsoft Office Excel format with below code.
declare
v_report_nameVARCHAR2(100) := 'F:IrfanNewReportsCurrency.rdf';
v_formatVARCHAR2(12):= 'SPREADSHEET';
begin
Web.Show_Document([URL]......);
end;
when my report run I received one message window File download after that this below error window appear & data can't show in proper format.
Reports & Discoverer :: Special Characters Coming In Text Output Format Of Oracle?
Jan 27, 2012I have developed one rdf in Text Output Format.In this some special characters is coming for Text Output format of rdf.Shall i do any adjustments in layout? How to remove these special characters?
View 3 Replies View Related