|
|
Rank: Member
Groups: Member
Joined: 6/10/2009
Posts: 24
Location: Joinville, Brazil
|
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
|
|
Rank: Advanced Member
Groups: Administration, Stimulsoft Team
Joined: 6/9/2006
Posts: 2,617
|
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.
|
|
Rank: Member
Groups: Member
Joined: 6/10/2009
Posts: 24
Location: Joinville, Brazil
|
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: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
|
|
Rank: Advanced Member
Groups: Stimulsoft Team
Joined: 6/9/2006
Posts: 1,133
|
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.
|
|
|
Guest |
