Amicuk Programming Answers

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

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

The replay answer
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

Go to See the other 5 answers

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]

Problem with Cross-tab report (RTF Template) null values, current-group()

Category:DefaultRelease time:2015-10-11Views:130

Hi, experts! I generate Cross-tab report using RTF Tamlpate and I have problem with grouping. My XML file have to be with one group only because I want to using dynamic regrouping inside the RTF template. Here is my data structure (XML file):(Look th[More]

Printing Chinese characters in XML Publisher - using RTF Template

Category:DefaultRelease time:-0001-11-30Views:130

Hi All, I have to build RTF template for invoices report. When i run the report for US/UK operating units , it is working fine. But when i run the report for China invoice. Chinese characters were displaying like ????? Can any one help me how to fix[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, 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]

Hi I have added the currency field in the existing ALV report. The final internal table having the currency field and it has value. Curreny field is not displaying in output. Pls help Below is my ALV code for currency. PERFORM FILL_FIELDCAT USING 'WA [More]
how can i connect my mac book pro with retina display 2014 Mid to 5.1 channel? what is the connector am i to use? i wonder if anybody could probably let me know? I use Hercules found here http://www.hercules [More]
At last, I want to play music stored on my Mac Mini through our home stereo, wirelessly if possible. We have an old snow ABS, but the Mini has an Airport Extreme card. The stereo is within 15 feet of the Mini, though a cable run would be a pain. Coul [More]
Hi! Gurus,      This is Amar Srinivas Eli.I am workig on Production Support project. Here I got one issue related to Message Monitoring. Actually user send one information from Store Front Site to P31 R3 system via XI means XI Production System right [More]
I occur an error when starting the AXIS - welcome page (index.jsp): org.apache.jasper.JasperException: Can't find bundle for base name i18n, locale de_DE Has anybody an idea what this could be due to? Thanks in advance.Hi Bluemccarty, Unfortunately, [More]
I received PSE 13 a few days ago (I was previously using v. 11) and I am trying to figure out how to set preferences as they relate to opening files. I have a bunch of old JPEG photos that were taken with a point-and-shoot and which never had to do a [More]
Hello, I have created database on Windows Server 2008, 11g R2 64 bit. Everything went good, but it didn't create the EM console. I drop the repository console and tried to create it again, but, I got this error: C:\Windows\system32>emca -config dbcon [More]
My Macbook takes ages to wake from sleep *when its on mains power* and has been left for a few hours. In contrast, it will wake instantly when on battery power, as my old 2005 ibook did. However when on mains when you open the lid, you get a progress [More]
My Firefox is NOT connecting to the Internet. It's like it is blocked and isolated from the web. I've tried restarting with add-ons disabled, Safe-Mode and reinstalling. Nothing has worked. This is the second time this has happened to Me in the last [More]
I have a couple of Cisco SF 300 8P and 24 P Switches. I have voice and Data VLAN configured as : Data VLAN : Default Voice VLAN : VLAN 20 I have different DHCP servers as for Data VLAN we have physical server which is co [More]