Crystal Report question

Todd,

> Can anyone tell me how
> I would select records based on the current month -1, current month
> -2,
> current month -3 etc and then how to apply the appropriate month name
> to
> the month?

The easiest thing to do would be something like:

{Table.FieldName} in CurrentDate - 356 to CurrentDate

As far as displaying the month name, look no further than the MonthName
function.

MonthName({Table.FieldName})

Take care,
--
Adam Ellis <aellis@...>
SaberLogic
Hey everyone!

I'm creating a modified version of the Labor Edit report in Crystal. I noticed that in Crystal when I select a parameter of 1 day, it only pulls in the data from that day. Well, we have a 2nd shift and it does not include the data from the midnight overlap. I noticed that the Labor Edit report in Vantage does include the midnight overlap in its data. Any ideas as to how I create a formula to include the data from the 2nd shift midnight overlap?

Thanks!

Wendy Bowen
Network Administrator
Schmald Tool & Die, Inc.
(810) 743-1600 ext.323
wpursche@...

[Non-text portions of this message have been removed]
I'm not familiar with the Labor Edit report in Crystal, but I've ran
into this particular problem many times.

In the LaborDtl table, payrolldate is the pay date, and clockindate
is the date clocked on to job. They may be different as you've found
out. If you want only labor that will be attributed to the pay date,
only use payrolldate in the filter.

HTH

Lonnie




--- In vantage@y..., "Wendy Bowen \(Pursche\)" <wpursche@s...> wrote:
> Hey everyone!
>
> I'm creating a modified version of the Labor Edit report in
Crystal. I noticed that in Crystal when I select a parameter of 1
day, it only pulls in the data from that day. Well, we have a 2nd
shift and it does not include the data from the midnight overlap. I
noticed that the Labor Edit report in Vantage does include the
midnight overlap in its data. Any ideas as to how I create a formula
to include the data from the 2nd shift midnight overlap?
>
> Thanks!
>
> Wendy Bowen
> Network Administrator
> Schmald Tool & Die, Inc.
> (810) 743-1600 ext.323
> wpursche@s...
>
> [Non-text portions of this message have been removed]
Wayne & Lonnie,

Doh! Thanks! I didn't even think about that.

Wendy Bowen
Network Administrator
Schmald Tool & Die, Inc.
(810) 743-1600 ext.323
wpursche@...
----- Original Message -----
From: lonniedrew
To: vantage@yahoogroups.com
Sent: Monday, February 25, 2002 11:26 AM
Subject: [Vantage] Re: Crystal Report question


I'm not familiar with the Labor Edit report in Crystal, but I've ran
into this particular problem many times.

In the LaborDtl table, payrolldate is the pay date, and clockindate
is the date clocked on to job. They may be different as you've found
out. If you want only labor that will be attributed to the pay date,
only use payrolldate in the filter.

HTH

Lonnie




--- In vantage@y..., "Wendy Bowen \(Pursche\)" <wpursche@s...> wrote:
> Hey everyone!
>
> I'm creating a modified version of the Labor Edit report in
Crystal. I noticed that in Crystal when I select a parameter of 1
day, it only pulls in the data from that day. Well, we have a 2nd
shift and it does not include the data from the midnight overlap. I
noticed that the Labor Edit report in Vantage does include the
midnight overlap in its data. Any ideas as to how I create a formula
to include the data from the 2nd shift midnight overlap?
>
> Thanks!
>
> Wendy Bowen
> Network Administrator
> Schmald Tool & Die, Inc.
> (810) 743-1600 ext.323
> wpursche@s...
>
> [Non-text portions of this message have been removed]


Yahoo! Groups Sponsor
ADVERTISEMENT




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

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


[Non-text portions of this message have been removed]
I have a customer who has partnumbers with spaces in them.
Example: '12345 Blah Blah Blah'
This customer wants their partnumber barcoded on our packing slip
and shipping label. Is there a way that I can embed a comma
where the spaces are using crystal reports?
When I bar code the above with spaces, it cannot be scanned.
Any help would be appreciated.
thanks,


[Non-text portions of this message have been removed]
If their part numbers are in a fixed format (like a SSN), you could do
the following:

PartNumber = 12345 67890

"*" + mid(PartNumber, 1, 5) + "," + mid(PartNumber, 7, 5) + "*"

Something like the above might work.


Gary L. Kacher
Database Manager
Giddens Industries
glk@...


----------
From: PLAMAN DICK
Reply To: vantage@yahoogroups.com
Sent: Friday, March 22, 2002 9:28 AM
To: 'Vantage (vantage@yahoogroups.com)'
Subject: [Vantage] Crystal Report question

I have a customer who has partnumbers with spaces in them.
Example: '12345 Blah Blah Blah'
This customer wants their partnumber barcoded on our packing slip
and shipping label. Is there a way that I can embed a comma
where the spaces are using crystal reports?
When I bar code the above with spaces, it cannot be scanned.
Any help would be appreciated.
thanks,


[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

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/



[Non-text portions of this message have been removed]
I am trying to write a Crystal Report that will show me the average use
of a group of parts for the preceding 12 months. This report must be run
each month and has to show the rolling 12 month average. I need to be
able to list the month names and the quantity used for that month and
then include the average for the 12 months listed. I would like to
create formulas that will grab the data and put it in the appropriate
month totals without having to edit date ranges. Can anyone tell me how
I would select records based on the current month -1, current month -2,
current month -3 etc and then how to apply the appropriate month name to
the month?

Thank You

Todd Hofert
IT Director
Spartan Graphics, Inc.


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