Sitemap

Amicuk Programming Answers

Grouping and Decimal characters in rtf templates.

2015-10-11   Views:4

Advertisement

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
Advertisement
Hi,
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]

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]

Hot
I installed the oracle xe RPM package on RHEL4. Apparently it succeeded. There were no errors reported and the package is installed. However the GNOME menu doesn't match what the documentation would lead me to expect: "On Linux, click the Application [More]
I have a HP 6500A plus...the printer keeps going off line.  Then when it shows on line it takes a long time to print.How is your computer connected to your printer.  Is it networked do you have other networked devices that work ok? Please mark the po [More]
I am trying to create artwork to map to a globe using the 3D revolve effect...the problem is the shape/layer I'm using to create the "glow" effect (compound path filled with white and a gaussian blur applied): When I create a symbol out of this, [More]
Hi, We had a case where a large report needed to have check boxes. These check boxes would populate a list of id's which we then processed for a specific task. By default APEX doesn't support this. After spending some time on this, I thought I'd post [More]
Using Excel Engage 2008 I added a URL button selected "window option = Open in THIS WINDOW" but when I preview it always opens in another window. Any recommendations how to fix this problem? thank you, Nancy G.If you export to HTML/SWF and open [More]
I have a power mac G5 and its about 7 years old now, it's worked fine before updating iTunes but now I can't get it higher than iTunes 10.3, I recently bought a iPhone 5 thinking it would link no problem as I only use G5 for iTunes and my previous ip [More]
How Loaded Maya Scene in to Java 3D Application ? when I run the application, I get "com.sun.j3d.loaders.ParsingErrorException: Unrecognized token, line 1" . Please help me. import com.sun.j3d.loaders.objectfile.ObjectFile; import com.sun.j3d.lo [More]
Could someone suggest a way to change the font color of a string indicator in a strict type def cluster programmatically? The cluster contains a label that is color-coded to match the function of the data channel represented by that cluster.  The fun [More]
I have an extract structure with field timestamp, which is of type dec and length 15. Now i want to load this value to an infoobject in ODS. But this infoobject is of type char and length 18. when infopackage loading is scheduled it is giving the fol [More]
I have been using Oracle 9.2 and it's cooresponding ODP.NET for ASP.NET web development. I am now started on a new project that is running on a 10g database. I figured I would try out the Visual Tools suite and get the benefit of using ODP.NET and th [More]