TSQLTimeStamp on Xaxis in frxChart

Hello,

I am using an frxChart in an frxReport with a numeric variable as function of a TSQLTimeStamp field which is on the X-axis (bottom axis).
It seems I can only put it on the Xaxis using the 'Text' option, otherwise a get a conversion error (this is because the internal series data are text strings I think).

So Ok, I use the Text option instead. But I see that the resulting datetime format of the original
field does not correspond to the original field DisplayFormat, while in the text elements in the report it does.

I discovered that the frxChart series obtains its data in the form of strings in TfrxDBDataset.GetValue
in the line v := TSQLTimeStampField(Fields.Objects).AsDateTime. It does not use the field's displayformat, so what I get is a default
dd-mm-yy hh:mm:ss format. I want just mm-dd-yy instead.

So how can I control the datetime display format of the x axis labels?

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.