Crystal Report XI - Last User Login Report

Thank you very much. This worked perfect.

--- In vantage@yahoogroups.com, "Joe Rojas" <jrojas@...> wrote:
>
> I also do something similar with a part trans report.
>
> This is what I use: ToText(DateAdd("s",
> {BAQReportResult.PartTran.SysTime},
{BAQReportResult.PartTran.SysDate}),
> "MM/dd/yyyy hh:mm:ss tt")
>
>
>
> Joe Rojas
>
> Information Technology Manager
>
> Symmetry Medical TNCO
>
> 15 Colebrook Blvd
>
> Whitman MA 02382
>
> 781.447.6661 x7506
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of randyduly
> Sent: Tuesday, November 06, 2007 12:46 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Crystal Report XI - Last User Login Report
>
>
>
> I am creating a report that uses the "Last Time" from the UserFile
> table. This field is an integer field. So I am assuming that this
time
> is the number of seconds since Midnight. If this is the case how do
I
> change this to time of day (ex. 30 seconds would be 12:30 a.m.).
>
> Thanks in advance.
>
> Randy
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
I am creating a report that uses the "Last Time" from the UserFile
table. This field is an integer field. So I am assuming that this time
is the number of seconds since Midnight. If this is the case how do I
change this to time of day (ex. 30 seconds would be 12:30 a.m.).

Thanks in advance.

Randy
We are currently running Vantage 6 on progress.

On a very high level can someone provide the path of least resistance to
get to 8 on a MS SQL box?



Is this possible?



Thanks,



Rob Fiddelke

International Cybernetics







[Non-text portions of this message have been removed]
This shows military time. I have mine set for the partTran but just
substitute PartTran.SysTime for your situation. Make a formula
field with the following.

WhilePrintingRecords;
NumberVar Sec := {PartTran.SysTime};
NumberVar Hours := Truncate (Sec / 3600);
NumberVar Minutes:= Truncate(Remainder ( Sec,3600) / 60);
ToText ( Hours, '####') + ':'+
ToText ( Minutes,'00')

--- In vantage@yahoogroups.com, "randyduly" <randy.duly@...> wrote:
>
> I am creating a report that uses the "Last Time" from the UserFile
> table. This field is an integer field. So I am assuming that this
time
> is the number of seconds since Midnight. If this is the case how
do I
> change this to time of day (ex. 30 seconds would be 12:30 a.m.).
>
> Thanks in advance.
>
> Randy
>
Rob -



I can share my experiences with a Progress to SQL conversion if you would
like to contact me off list at: calvin@...



There were pros and cons to the conversion and I'm not 100% sure our method
was the best but we're on SQL now.



HTH,

Calvin Dekker

Misha Services

Tel: 630-675-9102

Email: calvin@...









From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Rob Fiddelke
Sent: Tuesday, November 06, 2007 6:07 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Progress to MS SQL



We are currently running Vantage 6 on progress.

On a very high level can someone provide the path of least resistance to
get to 8 on a MS SQL box?

Is this possible?

Thanks,

Rob Fiddelke

International Cybernetics

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
I also do something similar with a part trans report.

This is what I use: ToText(DateAdd("s",
{BAQReportResult.PartTran.SysTime}, {BAQReportResult.PartTran.SysDate}),
"MM/dd/yyyy hh:mm:ss tt")



Joe Rojas

Information Technology Manager

Symmetry Medical TNCO

15 Colebrook Blvd

Whitman MA 02382

781.447.6661 x7506



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of randyduly
Sent: Tuesday, November 06, 2007 12:46 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Report XI - Last User Login Report



I am creating a report that uses the "Last Time" from the UserFile
table. This field is an integer field. So I am assuming that this time
is the number of seconds since Midnight. If this is the case how do I
change this to time of day (ex. 30 seconds would be 12:30 a.m.).

Thanks in advance.

Randy





[Non-text portions of this message have been removed]