665Ecko .
asked on
Help with X axis Date/Time formatting via SSRS, Noobie
Hi Guys,
I am straight out of school and working on my first SSRS report via SQL server 2012. It is pretty small with only 3 lines of data.
I have an issue with the date/time formatting on the X-axis of my line graph.
My SQL Query has the following format: YYYY-DD-MM HH:MM:SEC. (Ex, 2018-02-08 13:35:37:363), however when I preview the line graph in SSRS, the X axis is formatted as MM:dd:YYYY and I am not getting the time stamp.
Attached are quick illustrations of what I am looking at. As my SQL skills and formatting are entry level, any help would be appreciated.
Thanks.
Graph.JPG
SQL.JPG
I am straight out of school and working on my first SSRS report via SQL server 2012. It is pretty small with only 3 lines of data.
I have an issue with the date/time formatting on the X-axis of my line graph.
My SQL Query has the following format: YYYY-DD-MM HH:MM:SEC. (Ex, 2018-02-08 13:35:37:363), however when I preview the line graph in SSRS, the X axis is formatted as MM:dd:YYYY and I am not getting the time stamp.
Attached are quick illustrations of what I am looking at. As my SQL skills and formatting are entry level, any help would be appreciated.
Thanks.
Graph.JPG
SQL.JPG
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
All the best.