3 Replies Latest reply: Jan 9, 2014 10:04 AM by CInglez RSS

    Number Formar Mask on Oracle Reports 11g

    CInglez

      Hi. My forms and reports were showing the american format mask for numbers, like "123,123.45", and we needed to use the brazilian format, which would be "123.123,45". I could solve it changing NLS_LANG on my default.env in Oracle Forms, but the reports are still showing me the american mask.

       

      I tried to set NLS_LANG at reports.sh, but nothing changed. Where should I configure the correct language for the reports server? I tried to find it in other posts, but no success.

       

      Server O.S.= Oracle Enterprise Linux 5.9 64 bit

      Forms & Reports Services 11.1.2.1

       

      Thanks in advance.

        • 1. Re: Number Formar Mask on Oracle Reports 11g
          CInglez

          Update: It worked when I out the following line on reports.sh:

           

          NLS_NUMERIC_CHARACTERS=",."; export NLS_NUMERIC_CHARACTERS


          The problem is that this is at system-level, all users must have the same format mask. In forms, as I configure it on the env file, I can have multiple configurations. Is there another way to solve this issue?


          Thanks

          • 2. Re: Number Formar Mask on Oracle Reports 11g
            JuliusZ

            Hi,

             

            You can create the environment for reports as well as for forms. This is done in the <REPORTS_SERVER>.conf file in <Oracle_Home>/reports/conf/. The whole section in this file would look something like this (depending on your actual values):

             

               <environment id="BRAZILIAN">
                  <envVariable name="REPORTS_PATH" value="<copy_from_the_current_environment>"/>
                  <envVariable name="NLS_LANG" value="BRAZILIAN PORTUGUESE_BRAZIL.WE8MSWIN1252"/>
                  <envVariable name="NLS_DATE_FORMAT" value="DD/MM/YYYY"/>
                  <envVariable name="NLS_NUMERIC_CHARACTERS" value=",."/>
               </environment>

             

            Good luck,

            JuliusZ

            • 3. Re: Number Formar Mask on Oracle Reports 11g
              CInglez

              How to we choose the environment when running reports?

               

              Thanks