locked
Number formatting in ProClarity RRS feed

  • Question

  • Hi, all

     

    Could you please explain how does ProClarity determine the number format to use for grids?

    We have a grid created and published in ProClarity. The regional settings on the client machine are set to Serbian(Latin) and for other applications (PerofmancePoint and Excel), the numbers are displayed correctly according to the regional settings of the client machine: '.' for the thousands separator and ',' for the decimals separator.

    ProClarity seems to ignore the regional settings: if we try to set the number format in ProClarity using Grid properties -> grid values to display -> Format -> number, then Web professional displays the numbers using the defined in regional settings separators ('.' for the thousands separator and ',' for the decimals separator) which is the needed functionality, but Web standard (and PPS published reports) still have the old default separator: ',' for thousands and '.' for decimals. Republishing the book does not help.

    Could you please advise us on which settings to change in order to overwrite default number format in ProClarity?

     

    Thanks!

    Thursday, August 14, 2008 8:45 AM

Answers

  • Formatting in the thin client is based on the user's selected (or assigned) default language, and not on browser encoding or regional settings on the client machine.  When a language pack is installed on PAS, the user then has the choice of whether they would like to have the PAS default language, or the lanaguage from one of the language packs.  If they would like a different language, that can be assigned to them in the Admin Tool (or they can choose it themselves from the PAS home page at http://machine/pas via a dropdown on the left).  There is also the option of just installing the particular language version of PAS that all users would like and sending them to that instance of PAS, which will of course have that language as the default.

     

     ProClarity 6.3 product suite is available in the following 17 languages:

    =====================================================

    1. Japanese

    2. Brazilian

    3. Chinese (Traditional)

    4. Italian

    5. Danish

    6. Dutch

    7. Korean

    8. Swedish

    9. Czech

    10. Polish

    11. Russian

    12. Finnish

    13. Portuguese

    14. French

    15. German

    16. Spanish

    17. English

     

    Monday, August 25, 2008 11:54 PM

All replies

  •  

    Hi danydd,

     

    Thanks for posting your inquiry.  Do the regional settings differ between the client experiencing the formatting issue and the PAS server?  Or, if you load the same page on the PAS server itself does the formatting appear the same as the client or does it appear as the server's regional currency settings?

    Tuesday, August 19, 2008 11:49 PM
  •  

    Hi, Sean

     

    Yes, the regional settings differ between the PAS server and the clients. Also, there is no difference when opening PAS report pages on different machines - it seems to me that client regional settings are not taken into consideration by PAS when rendering reports.

    Monday, August 25, 2008 6:08 AM
  • Formatting in the thin client is based on the user's selected (or assigned) default language, and not on browser encoding or regional settings on the client machine.  When a language pack is installed on PAS, the user then has the choice of whether they would like to have the PAS default language, or the lanaguage from one of the language packs.  If they would like a different language, that can be assigned to them in the Admin Tool (or they can choose it themselves from the PAS home page at http://machine/pas via a dropdown on the left).  There is also the option of just installing the particular language version of PAS that all users would like and sending them to that instance of PAS, which will of course have that language as the default.

     

     ProClarity 6.3 product suite is available in the following 17 languages:

    =====================================================

    1. Japanese

    2. Brazilian

    3. Chinese (Traditional)

    4. Italian

    5. Danish

    6. Dutch

    7. Korean

    8. Swedish

    9. Czech

    10. Polish

    11. Russian

    12. Finnish

    13. Portuguese

    14. French

    15. German

    16. Spanish

    17. English

     

    Monday, August 25, 2008 11:54 PM
  • Hi,

     

    We had the same issue with trying to display grids for German clients with the correct separators and export to Excel.

    A combination of installing the German language pack, and setting the web standard client to use German, and then setting the number format in the BB to Grid properties -> grid values to display -> Format -> number solved the problem.

    Web Standard displayed numbers with the correct separator and also exports to Excel.

     

    What we don't seem to be able to overcome is if the grid has a mixture of numbers and percetnages. We can't then set the grid properties to number. Any advice appreciated.

     

    Thanks in advance. 

     

    Tuesday, September 16, 2008 9:22 AM
  • Have you tried setting the grid formatting to "Custom" and confirming that the formatting at the cube level is correct?

     

    Tuesday, September 16, 2008 8:38 PM