Scatter Line graph does not draw data line with date time format

Stimulsoft Reports.WPF discussion
Post Reply
hbdibit
Posts: 9
Joined: Sun Oct 02, 2016 11:38 pm

Scatter Line graph does not draw data line with date time format

Post by hbdibit »

Hello Stimulsoft,

I am generating a scatter line report, where I am plotting a value over time.

However, I have noticed if the date time format is not in a specific format the line does not draw.

attached is a PDF of what I mean.

also attached is an MRT and the related csv data files

Thanks
Craig
Attachments
Test_DateFormat.mrt
(33.01 KiB) Downloaded 208 times
Report.pdf
(103.11 KiB) Downloaded 262 times
report upper AM_PM.csv
(8.77 KiB) Downloaded 196 times
report lower am_pm.csv
(8.77 KiB) Downloaded 211 times
report a.m._p.m..csv
(9.03 KiB) Downloaded 220 times
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Scatter Line graph does not draw data line with date time format

Post by HighAley »

Hello.

All columns have a string type.
The dates are loaded as strings too.
There is no information about the format of the date and time.
So the date could not be loaded right.
Please, change the type of the column to DateTime and change the value to `yyyy-MM-dd hh:mm:ss` format.

Thank you.
hbdibit
Posts: 9
Joined: Sun Oct 02, 2016 11:38 pm

Re: Scatter Line graph does not draw data line with date time format

Post by hbdibit »

I see now. The datetime was being passed into the report as a DateTime format (the csv were just an example, our real report was using datetimes) but I just had to use the Format property on the XAxis to manipulate the viewing of the data.

the format used was dd/MM/yyyy hh:mm:ss.fff tt (the tt would be windows deterministic. above it was split with using AM/PM, am/pm and a.m./p.m.

without the specific formatting on the labels, the report would not display the line for the a.m./p.m. abbreviations

Thanks
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Scatter Line graph does not draw data line with date time format

Post by HighAley »

Hello.

We are always glad to help you.
Let us know if you need any help.

Thank you.
Post Reply