Re: Remote Access / Crystal Report

Dale E. Reed Jr. ( (no email) )
Fri, 17 Jul 1998 15:31:10 -0700

Olivier Astier (Echoweb) wrote:
>
> Hi all,
> I have 2 questions and hope that someone can help me.
>
> 1)Is there a way to control remote access to the Emerald database? I would
> like to specify the IP adress that have granted access to the database. I
> guess I can do that with SQL but I don't know how.

I don't know is this is possible.

> 2)I created a report (with CR 4.5) containing the "serverports.calldate"
> field. With SQL this field contains the date and the time (ie : Jun 18 1998
> 12:51PM) but Crystal Report only display the date (ie : 06/18/98). How can I
> display the time of the call ?

In the report options, in the SQL Section there is a checkbox to
convert date/time to date. Uncheck that option.

-- Dale E. Reed Jr.  (daler@iea-software.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |   http://www.iea-software.com