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>