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
Scatter Line graph does not draw data line with date time format
Scatter Line graph does not draw data line with date time format
- Attachments
-
- Test_DateFormat.mrt
- (33.01 KiB) Downloaded 222 times
-
- Report.pdf
- (103.11 KiB) Downloaded 280 times
-
- report upper AM_PM.csv
- (8.77 KiB) Downloaded 212 times
-
- report lower am_pm.csv
- (8.77 KiB) Downloaded 227 times
-
- report a.m._p.m..csv
- (9.03 KiB) Downloaded 235 times
Re: Scatter Line graph does not draw data line with date time format
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.
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.
Re: Scatter Line graph does not draw data line with date time format
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
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
Re: Scatter Line graph does not draw data line with date time format
Hello.
We are always glad to help you.
Let us know if you need any help.
Thank you.
We are always glad to help you.
Let us know if you need any help.
Thank you.