Received: from mailhost.ind.ameritech.net (mpdr0.indianapolis.in.ameritech.net
	[206.141.239.94]) by hub.org (8.9.3/8.9.3) with ESMTP id OAA05909
	for <pgsql-interfaces@postgresql.org>;
	Mon, 24 Jan 2000 14:20:25 -0500 (EST)
	(envelope-from richards@rsa.net)
Received: from columbia ([206.141.240.240]) by mailhost.ind.ameritech.net
	(InterMail v4.01.01.07 201-229-111-110) with SMTP
	id <20000124192000.UHNG16930.mailhost.ind.ameritech.net@columbia>
	for <pgsql-interfaces@postgresql.org>;
	Mon, 24 Jan 2000 14:20:00 -0500
Message-ID: <001a01bf66a0$b9ebc4a0$0400a8c0@columbia>
From: "Donald J. Richards" <richards@rsa.net>
To: <pgsql-interfaces@postgresql.org>
Subject: Complications with Crystal Reports
Date: Mon, 24 Jan 2000 14:25:03 -0500
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0017_01BF6676.CD8E91B0"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2014.211
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211

This is a multi-part message in MIME format.

------=_NextPart_000_0017_01BF6676.CD8E91B0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,

ODBC DRIVER VERSION:  6.40.0006
DATABASE VERSION:  6.5.2

    I am trying to create some simple reports in Crystal Reports and =
when I bring in the data of type TIME from the database Crystal sees it =
as a STRING type.  With this I cannot do any summation or charting of =
times.  Do you have any suggestions or has anyone run into this before?  =
Has anyone used Crystal with PostgreSQL before and been able to use the =
TIME type.   Any and all help would be greatly appreciated.

                                            Thanks,
                                                        Don Richards
                                                        Integrated =
Process Systems


------=_NextPart_000_0017_01BF6676.CD8E91B0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2014.210" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3D"Times New Roman" size=3D2>
<DIV><FONT face=3D"Times New Roman" size=3D2>Hi,</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3D"Times New Roman" size=3D2>ODBC DRIVER VERSION:&nbsp;=20
6.40.0006</FONT></DIV>
<DIV><FONT face=3D"Times New Roman" size=3D2>DATABASE VERSION:&nbsp;=20
6.5.2</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3D"Times New Roman" size=3D2>&nbsp;&nbsp;&nbsp; I am =
trying to=20
create some simple reports in Crystal Reports and when I bring in the =
data of=20
type TIME from the database Crystal sees it as a STRING type.&nbsp; With =
this I=20
cannot do any summation or charting of times.&nbsp; Do you have any =
suggestions=20
or has anyone run into this before?&nbsp; Has anyone used Crystal with=20
PostgreSQL before and been able to use the TIME type.&nbsp;&nbsp; Any =
and all=20
help would be greatly appreciated.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3D"Times New Roman" size=3D2>&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;=20
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;=20
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;=20
&nbsp;&nbsp;&nbsp; Thanks,</FONT></DIV>
<DIV><FONT face=3D"Times New Roman" size=3D2>&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;=20
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;=20
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;=20
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp; Don=20
Richards</FONT></DIV>
<DIV><FONT face=3D"Times New Roman" size=3D2>&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;=20
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;=20
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;=20
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;=20
Integrated Process Systems</FONT></DIV>
<DIV>&nbsp;</DIV></FONT></DIV></BODY></HTML>

------=_NextPart_000_0017_01BF6676.CD8E91B0--