Reports & Discoverer :: Oracle Report Dynamic Text Movement

Jan 11, 2011

I have one report requirement like below diagrams, My report having one repeating frame and one dynamic LOGO field. My repeating frame have 2 field say item_no, and item_name. This repeating frame will grow based on the items say min 1 to max 8 items.

My dynamic logo has some min and max movement position, Say in the below diagram my dynamic logo min movement position is line no 6 and max movement position is 9.

Suppose i have only 1 or 2 or 3 or 4 or 5 items then LOGO should fit in the line no 6, if i have 6 items then logo should come in the 7th line, if i have 7 items then logo should come in the 8th line ect.,like that max 8 item will come in the report, if items are 8 then logo should fit in the 9th line number.
----------------
1|*****ITEM1****|
2|**************|
3|**************|
4|**************|
5|**************|
6|*****LOGO*****|-- MIN LOGO POSITION
7|**************|
[code]......

View 1 Replies


ADVERTISEMENT

Reports & Discoverer :: From Report To Text File

Dec 24, 2010

I'm working on a report (written with Oracle report builder 6i) for the SMS system.I want the the report results (list of mobile numbers) to be outputted directly into a text file.I have accomplished that with the following parameters:

DESTYPE = File
DESNAME = C:file_name
MODE = character

this work well for the first time but in the subsequent runs, the report rewrite the same file deleting the result from the run before.can I manage to have each run result written in separate file with the name formatted in specific way like (sms_parametervalue_date) or something. or at least is it possible to change the system parameter DESNAME via user parameter at runtime, so I can input the new file name into the parameter form.

View 1 Replies View Related

Reports & Discoverer :: Dynamic Image In Report Without Using BLOB?

Jan 18, 2006

I have students pics in a folder. I want to display it in report using studentID.

View 6 Replies View Related

Reports & Discoverer :: How To Create Text File Of Report In 10g

Mar 18, 2013

How to create text file of report in 10g ? In reports 6i having default option in menu bar(mail). When clicking the mail option in reorts 6i it will attached to the outlook and we can sent. but in reports 10g not having that Option . It is possible in reports 10g?

View 2 Replies View Related

Reports & Discoverer :: Display Text Item In Second Page Of Report

Jul 12, 2010

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

Reports & Discoverer :: Text Bold - Format Particular Word In Oracle Reports At Runtime?

Nov 2, 2010

I 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..?

View 10 Replies View Related

Reports & Discoverer :: Oracle Reports Text Formatting As Runtime?

Aug 26, 2013

I need the below output in oracle reports 6i.

this is a testing string retrieved from database.

now what i need is that to make bold the specific words in a string came from database.

View 2 Replies View Related

Reports & Discoverer :: Create A Report By Using One Field / Text As Columns Name In Layout But Display All Columns

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

Reports & Discoverer :: Special Characters Coming In Text Output Format Of Oracle?

Jan 27, 2012

I 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

Reports & Discoverer :: BarCode Report Oracle 10g

May 12, 2011

I have created a report which generates barcode, it is working fine in development environment.(Report Builder 10.1.2.0.2) but when i place it on Application server and want to call it from there, it terminates with error. and error log is

Terminated with error: REP-1401: 'beforereport': Fatal PL/SQL error occurred. ORA-39565: Message 39565 not found; product=RDBMS; facility=ORA

View 10 Replies View Related

Reports & Discoverer :: Oracle 6i Report With Layout

Oct 12, 2010

I have made a report with the layout in report it self only.but its showing error

REP-1219: 'F_27' has no size -- length or width is zero.
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-1219: 'F_27' has no size -- length or width is zero.

if have tried to solve this but it showing error for other field a same error. i am sending a my rdf .

View 1 Replies View Related

Reports & Discoverer :: Convert Oracle Report To PDF?

May 15, 2013

what is the code for converting oracle reports to pdf.

View 11 Replies View Related

Reports & Discoverer :: Character Report In Oracle 10g Like 6i?

Apr 15, 2011

Can I make charatcer report in 10g web application like 6i

View 1 Replies View Related

Reports & Discoverer :: Oracle Report Engine Error

Jul 4, 2013

I m trying to run reports from my application developed using Oracle FORMS6i but the report engine does not show any job. Platform Information: Microsoft Windows Server 2012 Version 6.2 (64 bit).

View 2 Replies View Related

Reports & Discoverer :: Control Print Job From Oracle Report?

Sep 23, 2005

How I control hte print job from Oracle Report. The problem is that If I do a report and print out, there should not be allowed to any user to print again. Here I also want to control the user list who can print a report.

[URL]

View 5 Replies View Related

Reports & Discoverer :: How To Do Water Mark In Oracle Report 2.1

Sep 30, 2011

how to do water mark in oracle report 2.1

View 8 Replies View Related

Reports & Discoverer :: Convert Oracle Report To Excel Format

Nov 10, 2012

i 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 "

View 5 Replies View Related

Reports & Discoverer :: Exit Adobe Report Oracle Application

Oct 17, 2010

Iam using Oracle DB 10g on HP-UX and accessing reports from windows based server as pdf format , After generating report i can save a copy only no exit option from reports and force to exit with shift+f4.

View 4 Replies View Related

Reports & Discoverer :: Page Total In Oracle Tabular Report

Nov 17, 2011

How to get page wise total on every page and grand total on last page in oracle tabular report. I have tried by placing summary column at report level and its reset property to page wise and print job on all page but last but it did not work .

View 2 Replies View Related

Reports & Discoverer :: Oracle Report 10g - Sorting In Break Order

Nov 30, 2010

Is there a way to short a Matrix report? The query shorts correctly in PLSQL but not in the generated report file.

There are columns like Date,Device,Operator Id etc and the report should be able to short depending on the requirement. For example,

it should be able to short by device, or by Date or both. I tried sorting in the 'Break order' but doesn't come out as required.

View 6 Replies View Related

Reports & Discoverer :: How To Create Password Protected Report File In Oracle 11g

Dec 21, 2011

I want to create pdf file of a report with password protection for security reason with. eg. Employee A is logged to run rep1. The pdf file created to his desk with his userid & password.

View 1 Replies View Related

Reports & Discoverer :: Oracle Report Builder 11g Stops When Destype Is File

Jul 9, 2013

In Oracle Report Builder 11g whenever i set destype to file report Builder Stops.

View 15 Replies View Related

Reports & Discoverer :: Create Password Protected PDF Report Using Bursting In Oracle

Feb 21, 2012

i want to create password protected pdf report using bursting in oracle for each new pdf i want new password..but password should be dyanamic for each pdf.

View 1 Replies View Related

Reports & Discoverer :: Oracle 10g Report Printing On Line Matrix Printer?

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

Reports & Discoverer :: Convert Number From Arabic To English In Oracle Report Builder

Aug 5, 2011

how can convert number from Arabic to English in oracle report builder

View 2 Replies View Related

Reports & Discoverer :: Getting Query Text From Reports?

Aug 4, 2010

Am looking for some stuff that allows me to get the query text of a query in Oracle Reports. Something like : get_query_text(query_name IN VARCHAR2);

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







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