Help with X axis Date/Time formatting via SSRS, Noobie

665Ecko .
665Ecko . used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Business Intelligence Developer and Analyst
Top Expert 2015
Commented:
It should not create any issue related to format until you are having same format from database.

Please go refer screenshot and rdl file attached. It will help you to solve issue in your rdl.

Comment if you need any other help.

DateOnAxis.PNGDateWithTimeOnAxis.rdl
665Ecko .Controls System Engineer

Author

Commented:
Perfect, thanks again for the assist.

All the best.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial