Chart X-Axis Date Label

[Pierre]

I have the x-axis as a date field.  No matter how I adjust the formatting, it shows Date and Time as the label.  I only want the DATE.  I have used the following format strings but it totally ignores any settings: {0:d} and {0:M/d/yyyy}

[Pierre]

bump

[Chavdar]

Hi,

We were unable to reproduce the problem. Please, check out the attached screenshot and our report definition. In order to continue investigating the issue, could you, please, send to us your report file in a support ticket so that we can check whether we are not missing something?

All the best,
Chavdar
the Telerik team

[Lukasz]

Hi,

I have the same problem. I've downloaded your example and from what I see I use Category Scale on xAxis.

My data source is a dll with only one function:

public class Reporting
{
    public List<KeyValuePair<DateTime, decimal>> GetData()
}

I created graph in designer, and attached Field.Key as Category and Sum(Value) as Values.
I can format yAxis, but xAxis react only to angle change.

No error messages in designer log file.
Any idea?

[Nasko]

Hello Lukasz,

There is a GraphAxis.LabelFormat property which you can use in order to format the X axis labels.
For more information on how to use the property, please check this video.

The report from the provided video is attached in this post. You will need the latest version of Telerik Reporting (8.1.14.804) in order to open it in the designer and the AdventureWorks sample database in order to run it.

Regards,
Nasko
Telerik

 

 

[Lukasz]

Hi Nasko,

thx for your reply but it turns out that you cannot format xAxis when it's type is category series. I had to change it to DateTime series and create expression for series.<name>.X property. Then you can format dates on xaxis.

Regards,
Łukasz

[Nasko]

Hello Lukasz,

You are correct that you need to change the scale type to DateTimeScale in order to format the dates. This action is shown in the provided video in my previous post.
It is not possible to format the axis labels when the scale is CategoryScale, since then the labels are strings and not dates.

Regards,
Nasko
Telerik