Months with zeroed values do not appear in the line chart...

[Jair RC]

Hello...

I have a line chart that displays values from month to month. For example, from May to December. However, some months have no values, then the graph is omitting those months. As a result, are missing from the graph the columns of months that have values zero. The dataset returns every month, including those who have values zero.
How to solve this problem?

Regards,

Jair RC
Joinville / SC / Brazil

[Edward]

Hi Jair,

Please make sure that for each month there is a row with '0' value in the DataSource, otherwise there is no to render line chart correctly.

Thank you.

[Jair RC]

Hello, Edward

So when I run the stored procedure directly in the database, all the columns show the value zero (see code below). But when I generate the report, the columns which have zeros, do not appear.

In the example below, the months Aug, Sep and Dec will not appear on the chart, because the two lines are zero.

Code: Select all

CLASSE                        Jun   Jul   Ago  Set   Out   Nov  Dez
OCORRÊNCIAS DE EQUIPAMENTO      1     0     0    0     0     3    0
CORRÊNCIAS OPERACIONAIS         2     3     0    0     1     1    0

I've tried everything but could not solve this problem.

Regards
Jair RC
Joinville/SC/Brazil

[Andrew]

Hello,

Unfortunately, our charts does not support the mode you described and are always rendered in sequence. You may filter data previously and remove months with zero from sequence.

Thank you.