Creating reports and dashboards | Stimulsoft community forum

Hello!

I am building a report that includes a line chart showing the average numerical value for a grouping of records. I am trying to chart two series, each representing a different population. It is working as expected except that one of my lines has 2 null values; however rather than NOT plotting a point for those groups, a zero is being charted. This behavior is not acceptable as it indicates a HUGE problem, where one does not exist. Can you please advise how to remove these zeros from my chart?!?!?

I believe I am using version: 2010.2.745 from 2 August 2010

Thank you so much for your help!

Hello,

Please send us your .MRT file with database for analysis.

Thank you.

Dear all,

I have that same problem posted at 14 de janeiro de 2011 : Line chart displaying null values as zeros. I am building a report that includes a line chart showing the average numerical value for a grouping of records. So, how to remove these zeros from my chart?

I am using Stimulsoft Report .NET (last version)

Thank you. Regards,

Marcio

Hello,

Can you please send us a sample report template with data or a simple test project, which reproduces the issue?

Thank you.

A sample report..

Thanks!







ConexãoTeste
Password=mafeisa@7;Persist Security Info=True;Data Source=localhost;Integrated Security=False;Initial Catalog=GSS;User ID=marciorente
ConexãoTeste




FonteDeDados1

descricao,System.String
programado,System.Decimal

30

FonteDeDados1
ConexãoTeste

select eixo.descricao + convert(varchar,year(getdate())) as descricao,
eixo.numero_mes as mes_relatorio,
year(relatorios.data_relatorio) as ano_relatorio,
isnull((select isnull(prog.valor_programado,0) from rel_desembolso_programado_acumulado prog where prog.ano_programado= year(relatorios.data_relatorio) and prog.contratos_id = contratos.id and prog.mes_programado = eixo.numero_mes),0) as programado
FROM
contratos, relatorios, desembolso_eixo_x as eixo
where contratos.id = 1
and year(relatorios.data_relatorio) = year(getdate())
order by eixo.numero_mes


FonteDeDados2

descricao,System.String
programado_ac,System.Decimal

30

FonteDeDados2
ConexãoTeste

select descricao + convert(varchar,year(getdate())-1) as descricao,
0 as mes_relatorio, 0 as ano_relatorio, null as programado_ac from desembolso_eixo_x where id=1
union all
select eixo.descricao + convert(varchar,year(getdate())) as descricao,
eixo.numero_mes as mes_relatorio,
year(relatorios.data_relatorio) as ano_relatorio,
isnull(prgac.valor_programado_acumulado,0) as programado_ac
FROM
rel_desembolso_programado_acumulado prgac,
contratos, relatorios, desembolso_eixo_x as eixo
where contratos.id = 1
and year(relatorios.data_relatorio) = year(getdate())
and prgac.ano_programado= year(relatorios.data_relatorio)
and prgac.contratos_id = contratos.id and prgac.mes_programado = eixo.numero_mes


FonteDeDados3

descricao,System.String
mes_relatorio,System.Int32
ano_relatorio,System.Int32
realizado_ac_reaj,System.Decimal

30

FonteDeDados3
ConexãoTeste

select eixo.descricao + convert(varchar,year(getdate())-1) as descricao,
eixo.numero_mes as mes_relatorio,
year(relatorios.data_relatorio) as ano_relatorio,
total.total_realizado_acum as realizado_ac_reaj
FROM
contratos, relatorios, desembolso_eixo_x as eixo, total_acumulado_anual total
where contratos.id = 1
and total.contratos_id = contratos.id
and total.ano=year(relatorios.data_relatorio)-1
and year(relatorios.data_relatorio) = year(getdate())
and eixo.numero_mes = 0
union all
select eixo.descricao + convert(varchar,year(getdate())) as descricao,
eixo.numero_mes as mes_relatorio,
year(relatorios.data_relatorio) as ano_relatorio,
reac.valor_reajustado_acumulado as realizado_ac_reaj
FROM contratos, relatorios,
desembolso_eixo_x as eixo
LEFT JOIN rel_desembolso_realizado_acumulado reac on eixo.numero_mes = reac.mes_realizado
and reac.ano_realizado = year(getdate())
and reac.contrato_id = 1
where contratos.id = 1
and year(relatorios.data_relatorio) = year(getdate())
and eixo.numero_mes > 0
order by eixo.numero_mes


FonteDeDados4

descricao,System.String
numero_mes,System.Int32

30

FonteDeDados4
ConexãoTeste

select descricao + convert(varchar,year(getdate())) as descricao, numero_mes from desembolso_eixo_x






EngineV2




None;Black;2;Solid;False;4;Black
Transparent


True

95, 95, 95
GradientBrush,[255:255:255],[255:255:255],90



100, 95, 95, 95
100, 95, 95, 95



Silver
Gainsboro
False



100, 95, 95, 95
100, 95, 95, 95



[10:145:145:145]



[10:145:145:145]




60
95, 95, 95
Tahoma,8

95, 95, 95



95, 95, 95
Tahoma,12,Bold





95, 95, 95
Tahoma,8

95, 95, 95


95, 95, 95
Tahoma,12,Bold





95, 95, 95
Tahoma,8

95, 95, 95



95, 95, 95
Tahoma,12,Bold





95, 95, 95
Tahoma,8

95, 95, 95



95, 95, 95
Tahoma,12,Bold



[255:255:255]
0,0,19,6.7

FonteDeDados3.realizado_ac_reaj,EqualTo,_x0030_,,Numeric,Red,Transparent,Arial_x002C_8,True,False,,,None




FonteDeDados1


95, 95, 95
GradientBrush,[255:255:255],[255:255:255],90

Arial,8
95, 95, 95
10, 10
95, 95, 95
Arial,14,Bold

Chart1




FonteDeDados1.descricao
28, 45, 65
GlareBrush,[128:145:165],[178:195:215],0,0.5,1





Black
White
Arial,7
Black
SeriesTitle
8, 6
-

FromSeries
Séries 1
FonteDeDados1.programado


FonteDeDados2.descricao


171, 123, 122

21, 0, 0
[221:173:172]


71, 23, 22
[255:223:222]


Black
White
Arial,7
Black
8, 6
True
-

Séries 2
FonteDeDados2.programado_ac
RightYAxis


FonteDeDados3.descricao


155, 167, 129

5, 17, 0
[205:217:179]


55, 67, 29
[255:255:229]


Black
White
Arial,7
Black
8, 6
True
-

Séries 3
FonteDeDados3.realizado_ac_reaj




8, 6
-





[95:95:95]
Tahoma,12,Bold




b032dc82b0664f2a841e5b97296ab2ee
1,1,1,1
Page1
29.7
21


Arial,100
[50:0:0:0]





System.Dll
System.Drawing.Dll
System.Windows.Forms.Dll
System.Data.Dll
System.Xml.Dll
Stimulsoft.Controls.Dll
Stimulsoft.Base.Dll
Stimulsoft.Report.Dll

Report
7/22/2011 2:28:33 PM
7/12/2011 2:32:59 PM
C:\StimulSoft\Relatorios\Report_teste.mrt
2418a8c40dee48889ac763ef83da7514
Report
Centimeters
2011.1.1000
using System;
using System.Drawing;
using System.Windows.Forms;
using System.Data;
using Stimulsoft.Controls;
using Stimulsoft.Base.Drawing;
using Stimulsoft.Report;
using Stimulsoft.Report.Dialogs;
using Stimulsoft.Report.Components;

namespace Reports
{
public class Report : Stimulsoft.Report.StiReport
{
public Report() {
this.InitializeComponent();
}

#region StiReport Designer generated code - do not modify
#endregion StiReport Designer generated code - do not modify
}
}

CSharp

Hello,

Sorry, can you provide data for your report, which reproduces the issue?

Thank you.

Dears,

Perhaps I am in same situation.

I have table with decimal (nullable) column. Some of the records may contain 0(zero) values, some of them may contain null values. It is important for me to show "0" if it is really zero, and do not show null values as zero. If I set "Hide zeros" property to True then all zeros hidden, otherwise null values are showed as "0". At the bottom of report I made some average calculations on this column, so putting string value is not the solution.

How can I accomplish this task?

Hello.

tynar wrote:Perhaps I am in same situation.

I have table with decimal (nullable) column. Some of the records may contain 0(zero) values, some of them may contain null values. It is important for me to show "0" if it is really zero, and do not show null values as zero. If I set "Hide zeros" property to True then all zeros hidden, otherwise null values are showed as "0". At the bottom of report I made some average calculations on this column, so putting string value is not the solution.

How can I accomplish this task?

Please, send us a sample report template with data for analysis.

Thank you.

Hi,

What was the workaround for this issue?

I use SS 2011.1.919.

Regards

Hello.

mihiri1 wrote:What was the workaround for this issue?

I use SS 2011.1.919.

Please, describe our issue more detailed.

Thank you.