|
Re: How to display zero value [message #871056 is a reply to message #870854] |
Thu, 10 May 2012 16:56 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 #871251 is a reply to message #871107] |
Fri, 11 May 2012 16:08 |
|
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 #1711296 is a reply to message #1693993] |
Wed, 14 October 2015 16:15 |
Keerthi Nandakumar 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.
|
|
|
Powered by
FUDForum. Page generated in 0.79704 seconds