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..?
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?
The 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.
i have created a report in dis report i created bind parameters..how to capture these parameters into a table(for this i hav created a new table) means if i pass delivery_id at runtime
i need to insert this value into what ever i hav created table next time if i pass same value i need to update that record where should i write dis code in a report and can any one send script for this.
I am using windows 7 and running report from report builder 6i. I got this message error report builder has stopped working. And when i press on show problem details i got this info
Problem signature: Problem Event Name:APPCRASH Application Name:RWBLD60.EXE Application Version:3.0.0.0 Application Timestamp:39c93f24 Fault Module Name:UIW60.DLL [code].......
Read our privacy statement online:
[URL]........
If the online privacy statement is not available, please read our privacy statement offline:
I just want to know whether we can mask salary column of number datatype into text ,like we used to_char(to_date(<column_name>,'j'),'jsp') in sql? for example
I want to use superscript / subscript just like in word in rdf (oracle 8i / reports 6) for creating a footnote. for e.g. reserch1 . 1 should appear on top . is it possible to in reports to do that.
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]......
I have had a request to add the word "continued" if a field has to print on more than one page. For example, if there are values associated with a city, and these values and city must print on another page, the user would like the word "continued" on the second, third, etc iteration of the city.
example:
page 1 Fort Worth value value value
THEN next page, continuing the rest of Fort Worth's values:
page 2 Fort Worth continued <--the word "continued" added for next pg value value value
I want to change database login in report at runtime.
For Example. I have created and run a menu by using database login "ABC/xxx" and want to run a report through this menu directly (Without using form) by different data base login i.e "xyz/ddd".
what is the sol. except passing user id at report call i.e rwrun60 parameter.
My user would like to have a way to attach files to database records. For simplicity, we'll say that each employee in the database could have 0-many file attachments associated with them. I know how to make this part work using Oracle Forms.
So that's the easy part for me. The tough part is that they want to be able to run an Oracle Report on our application server (displays as a PDF, also downloadable as a PDF) and have links on this report to the attachments that they uploaded using the forms process above.
For the idea of storing the files on a folder somewhere, I simply created a text object on the report that had it's hyperlink property pointing to the file location. Done.. opens fine.
However, I want to be able to have the option of storing these files in the database instead, just in case we can't go with the shared folder idea. I'm not sure how to make this work. I can store a blob in the database.. but how do I link to that blob on the report for them to be able to download it? Is this even possible?
how to create a download link on the Oracle Report that let's them download a file out of the database.
Currently some jobs created in WBT scripting need to converted into oracle,plsql.There is one job in WBT scripting, which will invoke the oracle reports inside and generate the PDF files in the destination path as follows:
a = runhide("c:Program FilesInternet Exploreriexplore.exe", "http://pscm9722:7778/reports/rwservlet?USERID=%LOGONINFO%+server=rep_pscm9722+destype=file+desname=D:ORACLE10G\%CCALLRptName%+desformat=PDF+PARAMFORM=no+report=PCCALL.RDF") a = runhide("c:Program FilesInternet Exploreriexplore.exe", "http://pscm9722:7778/reports/rwservlet?
[code]...
Now, i want to convert this into oracle,plsql? Is it possible or not?
I migrated a Oracle 6i Report to Oracle Report 9i so I'm trying to execute a this report in the Run Web Layout, but this doesn't bring me any information, how can i run this reports in the Web layout?
When i run this report en the Paper Layout it's bring me data. When a run the report just bring me a blank web page.
I am creating a report which generates the data to a PDF/CSV based on users Input.When I create the report using Report Builder and execute the report,Delimited data appears in a PDF layout.
But if I add the below code in After Parameter Form trigger,the column headers keeps repeating with the data.
function AfterPForm return boolean is begin IF :P_DESTYPE = 'CSV' THEN :MODE :='DEFAULT'; :DESFORMAT:='DELIMITED'; Elsif :P_DESTYPE = 'PDF' THEN :DESTYPE := 'CACHE'; :DESFORMAT:='PDF'; END IF; return (TRUE); end; [code]....
But the PDF output seems fine where the header is shown only once.I could see many posts regarding this in Oracle reports 6i wherein delimited_hdr=no is used in Command Line but I would like to know the work around in Oracle reports 10g.
I 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
I 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.
