Having issues trying to remove time formatting from the x-axis 'category label format. Tried several formats but don't see a change on the outputted report - always showing my category dates as date WITH the time. STUPID! have already spent too much time on this & will take at least another day to get an answer, assuming no further info is required.
7 Answers, 1 is accepted
The labels on the X axis are defined by groups. When you are using a CategoryScale for the X axis (default), these group labels are represented as strings. These strings are not of type DateTime, which is why any date formatting will not be applied. In order to change this behavior you need to switch to a DateTimeScale and set the XAxis.X property, as described in the How to: Change the Axis Scale help article.
Then you can change the format (remove the time part) using the Format Property or the Format() text function.
The steps suggested in the provided How to: Change the Axis Scale help article work correctly when tested on our end:
"How to change the axis scale to DateTime:
1. On the design surface, click on the axis.
The selected axis properties are listed in the Property Browser.
2. In the Misc section for Scale select the DateTime Scale option.
3. Set the Groupings and Series.X/X0/Y/Y0 expressions to a DateTime field."
Please check this video for reference.
In case you need further advise, please open a new support ticket where you can attach a runnable sample report exhibiting the issue. We will be able to provide further suggestions once we review your scenario.
I have created a line graph in telerik report designer 2016, which is working fine, but the series on the graph shows data lines from bottom to top and i want to show series data from top to bottom, please guide me how can i do the same.
Please test moving the XAxis on top by setting the Yaxis.Scale's CrossAxisPositions - add new cross position AtMaximum.
If you need further help, please post the code for generating the Graph item, including test data in CSV format.
Telerik by Progress