Reports & Discoverer :: Arabic Font In Discoverer 10g
Oct 1, 2013
we have upgraded our discoverer from 3i to 4i and from 4i to 10g. After that we faced a strange problem related to arabic font
when opening discoverer desktop and open the list of the saved reports. some reports that was saved by an Arabic name are display by name '????'(question marks)
also another issue when opening it . It open normal but some columns that are Arabic are displayed in this way (ßÇÑÊ-ÇíÌíÈÊ Êáì ßÇÑÏ- ÝÆÉ 100 Ìã). so i must change the column font from "tahoma" to "arial" or any other font that support Arabic.
- my NLS_lANG =american_america.ar8mswin1256
- this problem didnot happens on the discoverer 3i
View 4 Replies
ADVERTISEMENT
Aug 8, 2011
I have a report that use &totalpages. output PDF, font unicode is error (Mã) but two last page's font is OK (Mã).
View 2 Replies
View Related
Apr 11, 2012
I need to change the font face from following lov value for parameter form, How?
SELECT DISTINCT CODE_ENTRY.VILLAGE_NAME, CODE_ENTRY.UNIONN_NAME
FROM CODE_ENTRY
View 4 Replies
View Related
Oct 6, 2010
We Implemented Unicode facility in our application, in forms its working fine. But, while running report in pdf arabicCharacters are not displaying Properly.
we did the following settings in uifont.ali
[ PDF:Subset ]
Arial..Italic.Bold.. = "Arialbi.ttf"
Arial...Bold.. = "Arialbd.ttf"
Arial..Italic... = "Ariali.ttf"
[code]...
View 3 Replies
View Related
Feb 6, 2012
I am generating a arabic report in Report Builder 6.0.8.11.3...It shows ok in report builder but when i generate PDF it shows garbage charachers.
NLS_Lang = ARABIC_SAUDI ARABIA.AR8MSWIN1256
report_path = c:windowfonts
in uifont.ali there are entries of fonts in PDF section.
View 5 Replies
View Related
Jan 21, 2012
I have a problem with arabic number in oracle report 11g. I made all the steps of 10g but it is still not working the characters(sentences in arabic are working fine) but number are not:
Steps:
1- Adding arabic fonts in uifont.ali file.
2- adding c:windowsfonts to Froms_path, Reports_path in Regedit
3- add parameter REPORTS_ARABIC_NUMBERAL IN regedit and making it's value CONTEXT.
View 5 Replies
View Related
Feb 23, 2012
I have below text stored in a DB table, am querying the same text in SQL Developer and am getting the correct reading order
Correct Data
Arabic : %بوليستر 70%, قطن 30
English : 70% Polyester, 30% Cotton
But in Oracle report am getting the wrong data like below
Wrong Data
Arabic : بوليستر 70%, قطن
30%
English : 30% Polyester 70% Cotton
View 6 Replies
View Related
Aug 5, 2011
how can convert number from Arabic to English in oracle report builder
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
Jun 23, 2010
When I try to manage the report the Discoverer application frozen.
View 5 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
Jul 5, 2010
how to Run a Discoverer Reports in a Forms Menu.
View 2 Replies
View Related
Jun 17, 2008
While executing the query i got an error saying "ORA-0092 - invalid sql query"
SELECT
S.user_je_source_nameSource,
B.nameBatch_Name,
B.default_effective_dateBatch_Eff_date,
B.posted_dateBatch_Posted_Date,
B.default_period_nameBatch_Period,
[code].......
View 2 Replies
View Related
Nov 29, 2011
We are using Discoverer 10g, apps mode EUL. I have assigned administrator privileges to System Administrator responsibility using EUL_US as well as SYSADMIN (re-did with SYSADMIN, just in case). I have 2 Business Areas in EUL and gave access to both of them to System Administrator responsibility and the userid TESTER (this user already has System Administrator responsibility assigned to it). But when I login to Administrator using TESTER and System Administrator, I don't see any business Areas available to select.
View 3 Replies
View Related
Nov 14, 2010
I want to set font properties of Arabic text.
View 1 Replies
View Related
Mar 11, 2007
I am using Oracle Discoverer Plus and I have some columns in the database table that periodically take the zero value. I have to use that column to divide other values. Is there any way I can handle this to show "0" when it is divided by zero?
Discoverer Plus shows that PL/SQL functions can be used in calculations. But I can't find the Register PL/ SQL function option in the Tools menu.
View 6 Replies
View Related
Aug 8, 2013
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.
View 5 Replies
View Related
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
Oct 14, 2010
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?
View 3 Replies
View Related
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
Mar 25, 2013
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.
View 1 Replies
View Related
May 24, 2010
how to create Oracle Reports with Java Barcodes.
View 8 Replies
View Related
Jun 9, 2006
While accessing the reports i am getting the following error
Rep - 51002 : Bind to Reports Server rep_wwubh01ap45 failed.
I have checked the file $ORACLE_HOME/reports/conf rwservelet.properties. The parameter SERVER=rep_wwubh01ap45 was present in that file.
View 1 Replies
View Related
Jul 19, 2011
We have a reports proces which we want to produce a report where the browser windows doest not display, or if it does, quickly closes after the report is completed.We are using Forms Version 10.1.2.0.2, Oracle Database 10g Release 10.2.0.4.0, OS is Windows XP Pro SP3
We have tried the below, but the primary application window closes, not the report server window.
- http - removed due to form message:You cannot use links until you have posted more than 5 messages.
WEB.SHOW_DOCUMENT(://'|| :global.Report_Server_Name ||
'/reports/rwservlet?cmdkey=ky10i&report='||v_rep_object||'.rdf' ||
'¶mform=no&desformat=pdf&destype=file&desname='||v_file_dir||
'&P_VOU_ID='||'883100000000000005565047129970'||
[code]...
We have modified the forms trigger to produce the report as shown below, but get the error:
FRM-41213: Unable to connect to the Report Server
Current theory is the connection to the database is lacking the user id and password since the cmdkey is not specified. How can we specify the cmdkey when using the run_report_object?
= = = = = = = = = = = = = = = = = = = = = =
DECLARE
v_rep_tx VARCHAR2(100);
v_RepStatus VARCHAR2(2000) := '';
v_rep_idREPORT_OBJECT;
v_repVARCHAR2(100);
[code]...
View 1 Replies
View Related
Mar 19, 2013
I'm using Report Builder 9.0.4.0.33.
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.
View 3 Replies
View Related
Feb 23, 2011
Is there a way to call an oracle report (version 9i) from a stored procedure?
View 2 Replies
View Related
Feb 10, 2012
Any way to automate a job to execute several Oracle Reports to run at the end of every month and either email them to a list of people or possibly save them to a location on a network drive.
At first, I started out with 2 avenues of thought:
1) The following link raised the option of an Oracle Scheduler, but from my research, the scheduler only runs database jobs, shell scripts, batch files, etc.:
[URL]......
2) I was thinking about possibly creating a database job of some sort to call the reports, but from the following link, I've determined that one cannot create+call a stored/database procedure to run Oracle Report files. So there goes my second hope.
[URL].......
So, it appears that the scheduler won't meet my requirements and now I think I'm almost out of options.
My last resort is creating a database job that queries required information and spooling the data + various formatting "stuff" into a txt file. Then, that txt file would be my report. This seems a little savage and I would like to think that there's a ay to automatically run an .REP against a database and save an electronic copy of the report somewhere.
Is it possible to automate the execution of Oracle Reports and then saving the report in a particular format (xls/pdf/rtf/etc.)?
View 1 Replies
View Related
Jun 16, 2011
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.
View 23 Replies
View Related
