Skip to Content
0
Former Member
Oct 24, 2012 at 08:10 PM

How do I get the date AND TIME to show up in a report?

191 Views

I'm working with Crystal Reports for Visual Studio 2010. The data is in a SQL Server 2005 database. The field is a datetime field, within the database/table. It has both date and time in it. But my report refuses to see that field as anything other than a date field. Huh??? According to this article on C# Corner, there should be a Date, a Time and a Date And Time tab when customizing the display. No there isn't; the only data type tab I see, when I try to customize it, is Date.

So, how do I get the date and time to show up from a datetime field returned by the stored procedure, when CR for VS 2010 only wants to treat it as a Date field???