Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
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 23:53 Go to next message
A R is currently offline A RFriend
Messages: 104
Registered: April 2012
Senior Member
How to display zero value in the bar chart value series.

Attached the sample file and report design.

Thanks in advance

AR

Report message to a moderator

Re: How to display zero value [message #871056 is a reply to message #870854] Thu, 10 May 2012 16:56 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member
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

Report message to a moderator

Re: How to display zero value [message #871057 is a reply to message #870854] Thu, 10 May 2012 16:56 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member
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

Report message to a moderator

Re: How to display zero value [message #871058 is a reply to message #870854] Thu, 10 May 2012 16:56 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member
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

Report message to a moderator

Re: How to display zero value [message #871060 is a reply to message #870854] Thu, 10 May 2012 16:56 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member
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

Report message to a moderator

Re: How to display zero value [message #871062 is a reply to message #870854] Thu, 10 May 2012 16:56 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member
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

Report message to a moderator

Re: How to display zero value [message #871063 is a reply to message #870854] Thu, 10 May 2012 16:56 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member
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

Report message to a moderator

Re: How to display zero value [message #871066 is a reply to message #870854] Thu, 10 May 2012 16:56 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member
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

Report message to a moderator

Re: How to display zero value [message #871068 is a reply to message #870854] Thu, 10 May 2012 16:56 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member
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

Report message to a moderator

Re: How to display zero value [message #871069 is a reply to message #870854] Thu, 10 May 2012 16:56 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member
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

Report message to a moderator

Re: How to display zero value [message #871071 is a reply to message #870854] Thu, 10 May 2012 16:56 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member
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

Report message to a moderator

Re: How to display zero value [message #871107 is a reply to message #871062] Thu, 10 May 2012 21:12 Go to previous messageGo to next message
A R is currently offline A RFriend
Messages: 104
Registered: April 2012
Senior Member
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

Report message to a moderator

Re: How to display zero value [message #871251 is a reply to message #871107] Fri, 11 May 2012 16:08 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member
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

Report message to a moderator

Re: How to display zero value [message #871305 is a reply to message #871251] Fri, 11 May 2012 20:35 Go to previous messageGo to next message
A R is currently offline A RFriend
Messages: 104
Registered: April 2012
Senior Member
Thanks Jason Smile

It really works without issue.

Happy Weekend My dear friend

Amarnath

Report message to a moderator

Re: How to display zero value [message #1693100 is a reply to message #871251] Tue, 21 April 2015 17:36 Go to previous messageGo to next message
Keerthi Nandakumar is currently offline Keerthi NandakumarFriend
Messages: 4
Registered: April 2015
Junior Member
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

Report message to a moderator

Re: How to display zero value [message #1693295 is a reply to message #1693100] Thu, 23 April 2015 01:20 Go to previous messageGo to next message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member
You should be able to do just like the above code in the afterdatasetfilled method only changing 0 values to 1.

Michael

Developer Evangelist, Silanis

Report message to a moderator

Re: How to display zero value [message #1693352 is a reply to message #871058] Thu, 23 April 2015 12:32 Go to previous messageGo to next message
kshirod mishra is currently offline kshirod mishraFriend
Messages: 50
Registered: March 2015
Member
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 151 times)

Report message to a moderator

Re: How to display zero value [message #1693384 is a reply to message #1693295] Thu, 23 April 2015 15:48 Go to previous messageGo to next message
Keerthi Nandakumar is currently offline Keerthi NandakumarFriend
Messages: 4
Registered: April 2015
Junior Member
you mean
-----------------------

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

Report message to a moderator

Re: How to display zero value [message #1693993 is a reply to message #1693384] Wed, 29 April 2015 21:10 Go to previous messageGo to next message
Keerthi Nandakumar is currently offline Keerthi NandakumarFriend
Messages: 4
Registered: April 2015
Junior Member
Actually that worked, thanks!!!

Report message to a moderator

Re: How to display zero value [message #1711296 is a reply to message #1693993] Wed, 14 October 2015 16:15 Go to previous message
Keerthi Nandakumar is currently offline Keerthi NandakumarFriend
Messages: 4
Registered: April 2015
Junior Member
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.

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 20:34:46 GMT 2024

Powered by FUDForum. Page generated in 0.04246 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly