Grouping and Decimal characters in rtf templates.
2015-10-11 Views:4
Hi guys and girls, I'm really struggling with a problem here regarding the decimal characters for the prices in my output. I'm using XML Publisher 5.6.3. My goal is to control the grouping and decimal character from my template. The numbers in the XM
I’m really struggling with a problem here regarding the decimal characters for the prices in my output.
I'm using XML Publisher 5.6.3.
My goal is to control the grouping and decimal character from my template.
The numbers in the XML data file can either be 10.000,00 or 10,000.00. The format is handled by the users nls_numeric_characters profile option.
The output of the template shall be based on the locale and not the data generated by Oracle Reports. For example: Reports to US customers shall show the numbers in the following format 10,000.00. Reports to our European customers shall show the numbers in this format 10.000,00.
How can I achieve this in my templates? Can it be achieved at all?
Thank you in advance.
Kenneth Kristoffersen
Edited by: Kenneth_ on May 19, 2009 1:30 AM
Thank you for your reply.
The problem is that the report is generating the output based on the users profile option nls_numeric_characters.
I have tried to override the users profile option in the before report trigger without any luck. I can alter selects so the query gets the numbers in the right format but then I would have to go through all queryes and reports which seem a bit wrong? Especially for the standard Oracle reports.
BR Kenneth
Grouping and Decimal characters in rtf templates.
Category:DefaultRelease time:2015-10-11Views:130
Hi guys and girls, I'm really struggling with a problem here regarding the decimal characters for the prices in my output. I'm using XML Publisher 5.6.3. My goal is to control the grouping and decimal character from my template. The numbers in the XM[More]
Data of one group not getting displayed (in rtf template)
Category:DefaultRelease time:2015-10-11Views:130
Hi We have build one rtf template it has 2 sectrions one is main section where data is being displayed with out any issues. where as for Sub section data is not getting displayed though there is data in xml file 1) Main section <[email protected]:G_O[More]
How to use special characters in rtf template?
Category:DefaultRelease time:2015-10-11Views:130
Hi, We are using .rtf template to print an invoice in pdf format. Now the requirement to put special character under footer section as below. "New York • London • Houston • Berlin • Vienna • Sydney • São Paulo • Singapore " I use same in rtf tem[More]
Trouble with Group By in RTF Template
Category:DefaultRelease time:2015-10-11Views:130
Hello All, I'm very new at RTF Template building, and I've spent hours trying to figure this out with no avail. I'm using BIP Desktop add-in for Word to load in my XML data and create some tables and charts. Right now I'm able to create a detail leve[More]
Issue in grouping in RTF template
Category:DefaultRelease time:2015-10-11Views:130
HI ALL, I have a requirement as below. The report header part contains : Order number, Email_address, the report body part contains the details for each order like item number, item name Again the line section is based on the another group, so it sho[More]
RTF Template: sums with nested groups
Category:DefaultRelease time:2015-10-11Views:130
Hi all, i've got quite a pickle of a problem it seems ... my data structure looks something like this: <COMPANY> --<STORE> ----<DEPARTMENT> ------<ITEM></ITEM> ----</DEPARTMENT> --</STORE> </COMPANY> multipl[More]
Not able to use @section and Sort within a group in RTF Template
Category:DefaultRelease time:2015-10-11Views:130
When i try to use sort with [email protected] in my template, the Output Post processor is throwing the following exception Caused by: oracle.xdo.parser.v2.XSLException: <Line 31, Column 84>: XML-22047: (Error) Invalid instantiation of 'xsl:sor[More]
Reseting page number in Word RTF template for BI Publisher PDF generation
Category:DefaultRelease time:2015-10-11Views:130
Hi! Apex 4.0.2, Oracle 10.2.0.4, BIP 10.2 Bills are created based on Word RTF file with BI Publisher. Reszulting file is one big PDF file, which has many pages. Word RTF template is grouped on BILLS.ID field with page break option. So one BILLS.ID ma[More]
Page Protect in RTF Template
Category:DefaultRelease time:2015-10-11Views:130
I have a RTF template in which I have the following defined: header text start:body body text 1 for each g_group text table end g_group body text 2 **** Page protect this end body footer text I would like to do something like a page protect on the "b[More]
- 1 Youtube can not refresh
- 2 Sample application Pet Store
- 3 Mac Pro 2.66 dual core xeon & FCX
- 4 How to create a table with events in smartforms?
- 5 How do I get my calendar on my ipad (3) to sync with my calendar on my iphone 4s? Please help driving me nuts!!
- 6 How do I transfer my mac mini data to a new mac mini?
- 7 Can I recover emails that were blocked when my storage was full?
- 8 Question about my account
- 9 A few questions about this "cure"
- 10 My iphone 4 rear camera is blurry and i do not know why.
- How do I configure the Airport utility to allow more than one rule per port?
- How to generate XML from SQL query
- Can an iPad be backed up to two Macs?
- How can I buy more than one photo album in iPhoto?
- Is there a way to make a mobile number clickable in an inDesign PDF document, that will open a Texting or Instant Messaging Application?
- ID3 Tags Failed to Import?
- Error while creating delivery docuemnt
- IC intermittent SAPSQL_ARRAY_INSERT_DUPREC error after changing business partner
- Error while making joins between ODS in a Infoset
- Computed page item no longer working after upgrade to 1.6