
VS.NET 2003 - DateTime field only showing up as Date in Crystal
I'm using VS.NET 2003 and several
Crystal Reports in my projects. All my
reports are utilizing .XSD xml files that describe the dataset for the
report. I just created a new XSD file with a couple of the fields being of
type xs:dateTime. I've created a report and added a database to it which
points at the XSD file. It works fine except that when I place one of the
dateTime fields onto the report, it thinks they are just date fields. No
time portion.
The XSD file was created by simply dragging/dropping a VIEW from the Server
Explorer onto the XSD designer window in VS.NET.
Here is the XSD contents. The fields causing problems are the StartTime and
EndTime.
Any ideas?
TIA,
Mark
-----------------------------------
<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="RouteScheduleDataSet"
targetNamespace=" http://www.*-*-*.com/ ;
elementFormDefault="qualified" attributeFormDefault="qualified"
xmlns=" http://www.*-*-*.com/ ;
xmlns:mstns=" http://www.*-*-*.com/ ;
xmlns:xs=" http://www.*-*-*.com/ ;
xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
<xs:element name="RouteScheduleDataSet" msdata:IsDataSet="true">
<xs:complexType>
<xs:choice maxOccurs="unbounded">
<xs:element name="vw_EmployeeScheduleReport">
<xs:complexType>
<xs:sequence>
<xs:element name="empname"
msdata:ReadOnly="true" type="xs:string" minOccurs="0" />
<xs:element name="RouteNum"
msdata:ReadOnly="true" type="xs:string" minOccurs="0" />
<xs:element name="FleetNum" type="xs:string"
minOccurs="0" />
<xs:element name="TaskDescription"
type="xs:string" minOccurs="0" />
<xs:element name="AMNoonPM" type="xs:string"
minOccurs="0" />
<xs:element name="StartTime" type="xs:dateTime"
minOccurs="0" />
<xs:element name="EndTime" type="xs:dateTime"
minOccurs="0" />
<xs:element name="GuaranteedHours"
type="xs:float" minOccurs="0" />
<xs:element name="Sunday" type="xs:boolean" />
<xs:element name="Monday" type="xs:boolean" />
<xs:element name="Tuesday" type="xs:boolean" />
<xs:element name="Wednesday" type="xs:boolean"
/>
<xs:element name="Thursday" type="xs:boolean" />
<xs:element name="Friday" type="xs:boolean" />
<xs:element name="Saturday" type="xs:boolean" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
</xs:element>
</xs:schema>