Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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: 3
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
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
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: 46
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 6 times)
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: 3
Registered: April 2015
Junior Member
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 21:10 Go to previous message
Keerthi Nandakumar is currently offline Keerthi NandakumarFriend
Messages: 3
Registered: April 2015
Junior Member
Actually that worked, thanks!!!
Previous Topic:Footer at bottom of last page only in BIRT PDF report
Next Topic:Error: Connection is not open.
Goto Forum:
  


Current Time: Sun Aug 02 06:24:10 GMT 2015

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

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