Eclipse Community Forums: BIRT » How to display zero value

Home » Archived » BIRT » How to display zero value (How to display zero value in the bar chart value series.)

How to display zero value [message #870854]

Wed, 09 May 2012 19:53

Eclipse User

How to display zero value in the bar chart value series.

Attached the sample file and report design.

Thanks in advance

AR

Attachment: new_report.rptdesign
(Size: 43.67KB, Downloaded 604 times)
Attachment: test.csv
(Size: 0.14KB, Downloaded 295 times)
Attachment: Output I need.jpg
(Size: 106.04KB, Downloaded 584 times)
Attachment: Output I need.jpg
(Size: 95.33KB, Downloaded 490 times)

Re: How to display zero value [message #871056 is a reply to message #870854]

Thu, 10 May 2012 12:56

Eclipse User

Select the y-axis scale on the third tab of the chart wizard. Enter 0
as a minimum value and check the show values outside axis range check
box. See attached screenshot.

Jason

On 5/9/2012 7:53 PM, Amar Reddy wrote:
> How to display zero value in the bar chart value series.
>
> Attached the sample file and report design.
>
> Thanks in advance
>
> AR

Attachment: showzerovalues.png
(Size: 57.63KB, Downloaded 752 times)

Re: How to display zero value [message #871057 is a reply to message #870854]

Thu, 10 May 2012 12:56

Eclipse User

Attachment: showzerovalues.png
(Size: 57.63KB, Downloaded 472 times)

Re: How to display zero value [message #871058 is a reply to message #870854]

Thu, 10 May 2012 12:56

Eclipse User

Attachment: showzerovalues.png
(Size: 57.63KB, Downloaded 490 times)

Re: How to display zero value [message #871060 is a reply to message #870854]

Thu, 10 May 2012 12:56

Eclipse User

Attachment: showzerovalues.png
(Size: 57.63KB, Downloaded 497 times)

Re: How to display zero value [message #871062 is a reply to message #870854]

Thu, 10 May 2012 12:56

Eclipse User

Attachment: showzerovalues.png
(Size: 57.63KB, Downloaded 406 times)

Re: How to display zero value [message #871063 is a reply to message #870854]

Thu, 10 May 2012 12:56

Eclipse User

Attachment: showzerovalues.png
(Size: 57.63KB, Downloaded 437 times)

Re: How to display zero value [message #871066 is a reply to message #870854]

Thu, 10 May 2012 12:56

Eclipse User

Attachment: showzerovalues.png
(Size: 57.63KB, Downloaded 423 times)

Re: How to display zero value [message #871068 is a reply to message #870854]

Thu, 10 May 2012 12:56

Eclipse User

Attachment: showzerovalues.png
(Size: 57.63KB, Downloaded 442 times)

Re: How to display zero value [message #871069 is a reply to message #870854]

Thu, 10 May 2012 12:56

Eclipse User

Attachment: showzerovalues.png
(Size: 57.63KB, Downloaded 434 times)

Re: How to display zero value [message #871071 is a reply to message #870854]

Thu, 10 May 2012 12:56

Eclipse User

Attachment: showzerovalues.png
(Size: 57.63KB, Downloaded 451 times)

Re: How to display zero value [message #871107 is a reply to message #871062]

Thu, 10 May 2012 17:12

Eclipse User

Hi Jason,

Thanks for the response. It worked for me. Here I am facing one problem in case of few reports, that is : " The fisrt bar is missing from the chart".

Please suggest. For ur ref here I am attaching screen capture.

Thanks in advance

AR

Attachment: issue_may10.jpg
(Size: 47.73KB, Downloaded 461 times)

Re: How to display zero value [message #871251 is a reply to message #871107]

Fri, 11 May 2012 12:08

Eclipse User

Is the value for Planning and Analyze a null? If so add this script to
the chart:
function afterDataSetFilled(series, dataSet, icsc)
{
var list = dataSet.getValues();

for ( i=0; i<list.length; i=i+1)
{
if ( list[i] == null )
{
list[i]= 0;
}
}
}

Jason

On 5/10/2012 5:12 PM, Amar Reddy wrote:
> Hi Jason,
>
> Thanks for the response. It worked for me. Here I am facing one problem in case of few reports, that is : " The fisrt bar is missing from the chart".
>
> Please suggest. For ur ref here I am attaching screen capture.
>
> Thanks in advance
>
> AR

Re: How to display zero value [message #871305 is a reply to message #871251]

Fri, 11 May 2012 16:35

Eclipse User

Thanks Jason Smile

It really works without issue.

Happy Weekend My dear friend

Amarnath

Re: How to display zero value [message #1693100 is a reply to message #871251]

Tue, 21 April 2015 13:36

Eclipse User

Hello,
I need the chart to change a value on X-axis if "0" to "1" , so that I can display a small width of the bar graph for 0 value instead of a blank column.
How do I achieve this? I will not be jeopardizing the data because another column will accurately display the actual value as text.
I am using BIRT RCP designer 4.4.2
Please see attachment for example.

Thanks

Attachment: Birt chart example-01.jpg
(Size: 22.42KB, Downloaded 344 times)

Re: How to display zero value [message #1693295 is a reply to message #1693100]

Wed, 22 April 2015 21:20

Eclipse User

You should be able to do just like the above code in the afterdatasetfilled method only changing 0 values to 1.

Re: How to display zero value [message #1693352 is a reply to message #871058]

Thu, 23 April 2015 08:32

Eclipse User

Hi Jasson ,

I am trying the same to show the zero value in Y -Axis but the data set is not allowing me do generate any report. Details screen shot has been attached below . Please find the same and do the needful. I have tried taking all types of data types but still it showing the same error. i.e "Can covert the data type : to value of double type"

Thanks % Regards:
kshirod Mishra

Attachment: Eclipse.docx
(Size: 199.07KB, Downloaded 188 times)

Re: How to display zero value [message #1693384 is a reply to message #1693295]

Thu, 23 April 2015 11:48

Eclipse User

you mean
-----------------------

if ( list[i] == 0 )
{
list[i]= 1;
}
-----------------------
?? I tried this to no luck.

Re: How to display zero value [message #1693993 is a reply to message #1693384]

Wed, 29 April 2015 17:10

Eclipse User

Actually that worked, thanks!!!

Re: How to display zero value [message #1711296 is a reply to message #1693993]

Wed, 14 October 2015 12:15

Eclipse User

Hello,
The script above worked for me at that time, and months later when i open up my report design file, this part of the script has mysteriously vanished. So has some visibility settings, sorting etc
Instead I find the below for 'onRender' for the chart:
----------------------------------------------------------------------------
function afterDataSetFilled( series, dataSet, icsc )
{
if(series.getSeriesIdentifier() != ""){
if(dataSet.getValues()[0] == 0){
dataSet.getValues()[0] = 1;
icsc.getExternalContext().getScriptable().setPersistentGlobalVariable(series.getSeriesIdentifier(),"not null");
}
}
}
function beforeDrawDataPointLabel( dph, label, icsc )
{
if(icsc.getExternalContext().getScriptable().getPersistentGlobalVariable(dph.getSeriesDisplayValue()) != null){
label.getCaption().setValue("0");
}
}
/**
* Called before populating the series dataset using the DataSetProcessor.
*
* @param series
* Series
* @param idsp
* IDataSetProcessor
* @param icsc
* IChartScriptContext
*/

function beforeDataSetFilled( series, idsp, icsc )
{
}
----------------------------------------------------------------------------
But this script does not display a small bar for 0 values.
I tried adding:
----------------------
function afterDataSetFilled(series, dataSet, icsc)
{
var list = dataSet.getValues();

for ( i=0; i<list.length; i=i+1)
{
if ( list[i] == 0 )
{
list[i]= 1;
}
}
}
----------------------
Not working. Why do you think this happened? I am positive I have not made these changes. How do I go back to fixing the 0 value on the chart.

Thanks a lot for your help.

Previous Topic:	XML values not enlisting
Next Topic:	BIRT 4.5 XLSX Export using ExcelEmitter.TemplateFile

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jul 23 08:32:19 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter