OT Crystal Reports

Yahoo Archive
1
Is there a way of by-passing the "sysprogress" password when running compiled Crystal Reports. I'm running Vantage 6.1, Progress 9.1D.

Thanks,
Abe Klassen
2
I'm writing an efficiency report in Crystal and have a couple of issues I could use some direction on.

(1) I am selecting the jobs by their ship date (ShipHead.ShipDate), if there are multiple ship dates per job how can I select the latest ship date?

(2) If the job is shipped complete 3 or more days ago but the job is not closed I want to insert a warning flag. Is there a way to calculate the difference between ShipHead.ShipDate and the current date?

Any help would be greatly appreciated.

Thank you,
Abe Klassen

[Non-text portions of this message have been removed]
3
(1). Try using the summary formula Maximum on the ShipDate That
should get you the Last date.

(2). Use DateDiff() put in 'd' for the interval that will get you
days CurrentDate for the Today's date and then Shipdate. It should
look something like this.
DateDiff('d',CurrentDate,{ShipHead.ShipDate})

Hope that helps.
Shari

--- In vantage@yahoogroups.com, "Abe Klassen" <ak@m...> wrote:
> I'm writing an efficiency report in Crystal and have a couple of
issues I could use some direction on.
>
> (1) I am selecting the jobs by their ship date
(ShipHead.ShipDate), if there are multiple ship dates per job how
can I select the latest ship date?
>
> (2) If the job is shipped complete 3 or more days ago but the job
is not closed I want to insert a warning flag. Is there a way to
calculate the difference between ShipHead.ShipDate and the current
date?
>
> Any help would be greatly appreciated.
>
> Thank you,
> Abe Klassen
>
> [Non-text portions of this message have been removed]
4
Thank you very much Shari, that's exactly what I was looking for.

Abe
----- Original Message -----
From: fselliott1
To: vantage@yahoogroups.com
Sent: Wednesday, September 29, 2004 5:18 PM
Subject: [Vantage] Re: OT Crystal Reports


(1). Try using the summary formula Maximum on the ShipDate That
should get you the Last date.

(2). Use DateDiff() put in 'd' for the interval that will get you
days CurrentDate for the Today's date and then Shipdate. It should
look something like this.
DateDiff('d',CurrentDate,{ShipHead.ShipDate})

Hope that helps.
Shari

--- In vantage@yahoogroups.com, "Abe Klassen" <ak@m...> wrote:
> I'm writing an efficiency report in Crystal and have a couple of
issues I could use some direction on.
>
> (1) I am selecting the jobs by their ship date
(ShipHead.ShipDate), if there are multiple ship dates per job how
can I select the latest ship date?
>
> (2) If the job is shipped complete 3 or more days ago but the job
is not closed I want to insert a warning flag. Is there a way to
calculate the difference between ShipHead.ShipDate and the current
date?
>
> Any help would be greatly appreciated.
>
> Thank you,
> Abe Klassen
>
> [Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links


Yahoo! Groups Sponsor
ADVERTISEMENT





------------------------------------------------------------------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



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