Datetime axis starting too early

Hi

I have a line chart where the x-axis is tied to a database series containing different dates starting from 1993.

But when I use this series as the category (X) series in a line chart, the axis starts from 1992, even if this year is not even in the database!

How can I make sure that it starts from 1993?

I have tried using a "filter" saying that the dates should be bigger than or equal to 1993 (which all dates already are) but it didn't work.

Find more posts tagged with

Comments

mwilliams

Hi Mihsah,

What version of BIRT are you using? Can you recreate this with the sample database?

Mihsah

I am using Birt 2.3.1. Unfortunately I have not been able to recreate the problem with the sample database.

The dates in my database are the following:
1993-01-01
1993-02-01
1993-03-01
and so on

When I use the simple dates as X-axis there is no problem (it then starts from 1993-01-01). The problem occurs when I change the datetime format on the X-axis on the "format chart" tab.

When I choose the advanced pattern Y in order to only show years, the X-axis starts from 1992. When I choose the pattern Y-M, it starts from 1992-1, 1993-2, 1993-3 and so on.

mwilliams

Mihsah,<br />
<br />
I see something similar when I deselect the "is category axis" for the xaxis. The scale is set to auto in this case, but shows a couple extra months ahead of what it should. This seems like a bug to me. Please search the bugs at <a class='bbc_url' href='http://www.eclipse.org/birt/phoenix/reportabug.php'>BIRT: Reporting Bugs and Requesting Enhancements</a>. If you don't see anything on this already, please log a bug for it. Be sure to include screenshots and a good description. Also, if you could post any bug info you find or post in here, that'd be great. Thanks.