Number formatting in BIRT.

torjoshi · 2011-05-03T13:34:07+00:00

Hi, I am a newbie to BIRT, developing a few repors. Report requires to support multiple functionality for numbers. To list - * Rounding * Average * Formatting of numbers - commas, decimal padding with 0. * Flipping colors for negative numbers, red if negative. * Adding…

torjoshi

Hi, 
 
I am a newbie to BIRT, developing a few repors. Report requires to support multiple functionality for numbers. To list - 
 
<ul class='bbc'><li> Rounding</li><li> Average</li><li> Formatting of numbers - commas, decimal padding with 0.</li><li> Flipping colors for negative numbers, red if negative.</li><li> Adding brackets around negative numbers. </li><li> Getting running total of values in columns. Example, if I have 1,2,3 as values for a column, the running total would be 1, 3, 6.</li></ul>
 
There are 2 possibilities that I have on mind - Java (datasource) or BIRT(rptDesign). In case of the datasource approach, I need to write the code and maintain it. 
 
I am requesting recommendation from experts as to which one would cater to my requirements. 
 
Thank you. 
 
RJ

Find more posts tagged with

Comments

mwilliams

Hi RJ,

The Running total and the Averages can be done with aggregations. The rounding, formatting, and adding brackets can be done with the NumberFormat section in the property editor. The negative numbers being red can be set up as a highlight on your table. Hope this helps.