VS.NET 2003 - DateTime field only showing up as Date in Crystal 
Author Message
 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>



Tue, 08 Nov 2005 04:38:41 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. VB .Net 2003 Standard or VS .Net 2003 Pro for Smart Devices

2. VS.NET 2003 project back to VS.NET 2002

3. Upgrading to VS.Net 2003 from VS.Net 2002

4. VS.NET 2003 - Date Modified Never Changes!?

5. Crystal 8 vs version in visual studio.net 2003

6. VB.Net Editor keystrokes lag/slow to respond (VS.NET 2003)

7. VS .NET 2002 upgrade to 2003 and CR.NET

8. Any news on VS 2003 release date?

9. VB datagrid scrolling problem in VS.Net 2003

10. ANN: The CodeSMART 2003 Add-in for VS .NET Was Updated

11. VS.net 2003 and college version

12. upgrading to VS.Net 2003

 

 
Powered by phpBB® Forum Software