Crystal Reports - A nudge needed

Yahoo Archive
1
I would create a formula called Cutoff Date= currentdate-60

Then in the selection criteria if you were looking and Order Dates
for example, I'd choose Order Date >= Cutoff Date

Then I also like to refernce the Cutoff Date underneath the title so
users know what criteria was used to filter the data.

Brian Stenglein
Clow Stamping Co.


--- In vantage@yahoogroups.com, "Matt Caldwell" <matt@...> wrote:
>
> I am new to Crystal Reports, and am needing to pull a report for the
> last 60 days. What is the correct syntax to accomplish this? SQL
is
> easy, it is "Between GetDate()-60 and GetDate()". Crystal is not
SQL.
> I have googled it, but don't have a solution yet. Could one of you
> Guru's give me a nudge in the right direction?
>
>
>
> Matt Caldwell
> Technical Support Analyst
>
> KERUSSO
> P.O. Box 32
> Berryville, AR 72616
> Phone: 800-424-0943 Ext. 231
> Fax: 870-423-3568
> Web Site: http://www.kerusso.com
> ******************************************************************
> CONFIDENTIALITY STATEMENT:
> This message, from Kerusso Inc., contains information
> which is privileged and confidential and is solely for the use of
> the intended recipient. If you are not the intended recipient, be
> aware that any review, disclosure, copying, distribution, or use
> of the contents of this message is strictly prohibited. If you have
> received this in error, please destroy it and notify us immediately
> at: 800-424-0943
> ******************************************************************
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
2
I am new to Crystal Reports, and am needing to pull a report for the
last 60 days. What is the correct syntax to accomplish this? SQL is
easy, it is "Between GetDate()-60 and GetDate()". Crystal is not SQL.
I have googled it, but don't have a solution yet. Could one of you
Guru's give me a nudge in the right direction?



Matt Caldwell
Technical Support Analyst

KERUSSO
P.O. Box 32
Berryville, AR 72616
Phone: 800-424-0943 Ext. 231
Fax: 870-423-3568
Web Site: http://www.kerusso.com
******************************************************************
CONFIDENTIALITY STATEMENT:
This message, from Kerusso Inc., contains information
which is privileged and confidential and is solely for the use of
the intended recipient. If you are not the intended recipient, be
aware that any review, disclosure, copying, distribution, or use
of the contents of this message is strictly prohibited. If you have
received this in error, please destroy it and notify us immediately
at: 800-424-0943
******************************************************************





[Non-text portions of this message have been removed]
3
Here is a report for 60 days out. I'd imagine you could just change it
from + 60 to - 60. Let me know how this works for you.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Matt Caldwell
Sent: Thursday, February 07, 2008 1:02 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Reports - A nudge needed



I am new to Crystal Reports, and am needing to pull a report for the
last 60 days. What is the correct syntax to accomplish this? SQL is
easy, it is "Between GetDate()-60 and GetDate()". Crystal is not SQL.
I have googled it, but don't have a solution yet. Could one of you
Guru's give me a nudge in the right direction?

Matt Caldwell
Technical Support Analyst

KERUSSO
P.O. Box 32
Berryville, AR 72616
Phone: 800-424-0943 Ext. 231
Fax: 870-423-3568
Web Site: http://www.kerusso.com <http://www.kerusso.com>
******************************************************************
CONFIDENTIALITY STATEMENT:
This message, from Kerusso Inc., contains information
which is privileged and confidential and is solely for the use of
the intended recipient. If you are not the intended recipient, be
aware that any review, disclosure, copying, distribution, or use
of the contents of this message is strictly prohibited. If you have
received this in error, please destroy it and notify us immediately
at: 800-424-0943
******************************************************************

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





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