Hi to All,

I have a line chart with dual Axes.
I was using a date field from database to drive the x axis with a date format dd.mm.yy.
The scales Y1 and Y2 where setup to Auto-scale (min value, max value, major interval, minor steps).

In order to be able to display the month in text (Jan) in two langages, I've changed the date field (db field) and put an formula that contains

Select Month({DB_datefield})

Case 12:
"Dec "+ ToText ({DB_datefield},'yyyy')
... and so on for all months

The display of x-axis is working as expected but the autoscale for y and y2 axes does not start well.

Before changing the date field (on change) the y1 was starting at 100 and after I've changed with the formula the y is starting at 200.

Is someone able to help ??

Thanks

Chris

Hi,

Thank you for your answer.
I understand but when I run the same report with another time range, longer, the y axis is as expected and the lines displayed properly and the dates (MMM YYYY) are well formatted in the x axis.
The problem is really the y axis, where start the 1st point of the line.

Is it possible to change the display of the x axis label ?

Thank you

Hi,

Yes you're right, the chart display is the same as with the formula.
The first point of my line is starting at 202, the second point is at 100.2.
It's like CR is making the sum of the 1st and 2nd point.

As I see I can't put any formula in Chart Expert-->Data-->Show Value(s).

I've tried to replace in Chart Expert-->Data-->Show Values the db_field with an formula, but it does not work.

Do you have any idea how to avoid CR to sum the 1st and 2nd values ?

Thanks

It's a line chart with only one line.
The x axis display dates.
The y axis display performance in %.
The value are displayed with the line.

When I'm running the report with a larger date range (at least 10years) it display correctly the line and the x + y axis.
In this case I'm running the report on 3 years it seems that the 1st + 2nd values are summed and displayed as one point (markers only).

When I'm getting the value from db (excel) data are ok.
The data are displayed by month, except the 1st value is (example):
30.01.2000 100
31.01.2000 100.29
29.01.2000 100.90
and then one value per month until end date.

Thanks

The solution is to change the 1st date, and put the value in a previous month, like :
31.12.1999 100
31.01.2000 100.29

If by grouping by month has the described effect, so by changing the month will solve this case.
I'm checking a way to change the 1st date in CR, if you have any idea you're welcome.

Thank you DBlank.

Chris