Crystal Help

just a thought if you dont get a response from this group go to:
http://groups.yahoo.com/group/crystalreportsusersgroup/ would be the
a specific domain for ur query.



--- In vantage@yahoogroups.com, "Chris Crosta" <chris@...> wrote:
>
> Can anyone tell me how to select only the most recent transaction
record
> for an operation. I have a sub report that lists every operation
a job
> will go through with a formula field that gives the status of the
> operation.
>
>
>
> if {LaborDtl.ActiveTrans}=True
>
> Then "In Progress" & "-" & Totext({LaborDtl.ClockInDate}&"
> "&{LaborDtl.ClockinTime}&" "&{EmpBasic.Name})
>
>
>
> Else if {LaborDtl.ActiveTrans}=False
>
> Then "Work Stopped"& "-" & totext({LaborDtl.ClockInDate}&"
> "&{LaborDtl.ClockOutTime}&" "&{EmpBasic.Name})
>
> Else ""
>
>
>
> Problem is that when my operators don't complete the operation on
the
> first clock in I end up with multiple transactions showing up for
each
> operation and I only need to see the most recent for each
operation.
>
>
>
> Thanks,
>
> Chris
>
>
>
> [Non-text portions of this message have been removed]
>
Maybe if you group your detail from Insert/Group... then set your
formula from there. Hope it helps in some way.

--- In vantage@yahoogroups.com, "Chris Crosta" <chris@...> wrote:
>
> Can anyone tell me how to select only the most recent transaction
record
> for an operation. I have a sub report that lists every operation
a job
> will go through with a formula field that gives the status of the
> operation.
>
>
>
> if {LaborDtl.ActiveTrans}=True
>
> Then "In Progress" & "-" & Totext({LaborDtl.ClockInDate}&"
> "&{LaborDtl.ClockinTime}&" "&{EmpBasic.Name})
>
>
>
> Else if {LaborDtl.ActiveTrans}=False
>
> Then "Work Stopped"& "-" & totext({LaborDtl.ClockInDate}&"
> "&{LaborDtl.ClockOutTime}&" "&{EmpBasic.Name})
>
> Else ""
>
>
>
> Problem is that when my operators don't complete the operation on
the
> first clock in I end up with multiple transactions showing up for
each
> operation and I only need to see the most recent for each
operation.
>
>
>
> Thanks,
>
> Chris
>
>
>
> [Non-text portions of this message have been removed]
>
Maybe I am underthinking this, but I believe you could set a group based
on the operation, suppress the details, set a condition in your
if-then-else to test for the most recent transaction, and execute.



So basically;



if {LaborDtl.ActiveTrans, maxtrandate} = True then..



Else {LaborDtl.ActiveTrans, maxtrandate} = false then..



Bruce Butler

IT Manager

Knappe & Koester, Inc.

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Chris Crosta
Sent: Tuesday, February 14, 2006 7:07 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Help



Can anyone tell me how to select only the most recent transaction record
for an operation. I have a sub report that lists every operation a job
will go through with a formula field that gives the status of the
operation.



if {LaborDtl.ActiveTrans}=True

Then "In Progress" & "-" & Totext({LaborDtl.ClockInDate}&"
"&{LaborDtl.ClockinTime}&" "&{EmpBasic.Name})



Else if {LaborDtl.ActiveTrans}=False

Then "Work Stopped"& "-" & totext({LaborDtl.ClockInDate}&"
"&{LaborDtl.ClockOutTime}&" "&{EmpBasic.Name})

Else ""



Problem is that when my operators don't complete the operation on the
first clock in I end up with multiple transactions showing up for each
operation and I only need to see the most recent for each operation.



Thanks,

Chris



[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/.
<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




SPONSORED LINKS

Manufacturing software
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Database
+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA>

Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ>

Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Data
base+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A>

Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Database+
marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg>

Database management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw>

Database marketing software
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manu
facturing+software&w2=Membership+database+software&w3=Database+mortgage+
software&w4=Pda+database+software&w5=Database+management+software&w6=Dat
abase+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw>



_____

YAHOO! GROUPS LINKS



* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .



_____



[Non-text portions of this message have been removed]
I believe if you group by operation, then Date descending, then Time
descending and suppress detail. Any detail fields that you drag into
the Time group header section will be the last record (descending Sort).
Any detail fields that you drag into the Time group footer section will
be the first record (descending Sort). This is reversed if the time
sort is ascending.

Hope this helps.

Dale E. Schuerman
Senior Consultant
RAM Software Systems, Inc.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Bruce Butler
Sent: Wednesday, February 15, 2006 12:05 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Help

Maybe I am underthinking this, but I believe you could set a group based
on the operation, suppress the details, set a condition in your
if-then-else to test for the most recent transaction, and execute.



So basically;



if {LaborDtl.ActiveTrans, maxtrandate} = True then..



Else {LaborDtl.ActiveTrans, maxtrandate} = false then..



Bruce Butler

IT Manager

Knappe & Koester, Inc.

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Chris Crosta
Sent: Tuesday, February 14, 2006 7:07 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Help



Can anyone tell me how to select only the most recent transaction record
for an operation. I have a sub report that lists every operation a job
will go through with a formula field that gives the status of the
operation.



if {LaborDtl.ActiveTrans}=True

Then "In Progress" & "-" & Totext({LaborDtl.ClockInDate}&"
"&{LaborDtl.ClockinTime}&" "&{EmpBasic.Name})



Else if {LaborDtl.ActiveTrans}=False

Then "Work Stopped"& "-" & totext({LaborDtl.ClockInDate}&"
"&{LaborDtl.ClockOutTime}&" "&{EmpBasic.Name})

Else ""



Problem is that when my operators don't complete the operation on the
first clock in I end up with multiple transactions showing up for each
operation and I only need to see the most recent for each operation.



Thanks,

Chris



########################################################################
Attention:
This email message is privileged and confidential. If you are not the
intended recipient please delete the message and notify the sender.
Any views or opinions presented are solely those of the author.

This email message has been scanned for Viruses and Content and cleared
by MailMarshal SMTP

For more information go to http://www.ramsys.com
########################################################################
LaborDtl.ClockInMinute contains minutes past base date, so this alone will
sort date and time.
Good luck,
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Dale Schuerman
Sent: Wednesday, February 15, 2006 1:37 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Help


I believe if you group by operation, then Date descending, then Time
descending and suppress detail. Any detail fields that you drag into
the Time group header section will be the last record (descending Sort).
Any detail fields that you drag into the Time group footer section will
be the first record (descending Sort). This is reversed if the time
sort is ascending.

Hope this helps.

Dale E. Schuerman
Senior Consultant
RAM Software Systems, Inc.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Bruce Butler
Sent: Wednesday, February 15, 2006 12:05 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Help

Maybe I am underthinking this, but I believe you could set a group based
on the operation, suppress the details, set a condition in your
if-then-else to test for the most recent transaction, and execute.



So basically;



if {LaborDtl.ActiveTrans, maxtrandate} = True then..



Else {LaborDtl.ActiveTrans, maxtrandate} = false then..



Bruce Butler

IT Manager

Knappe & Koester, Inc.

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Chris Crosta
Sent: Tuesday, February 14, 2006 7:07 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Help



Can anyone tell me how to select only the most recent transaction record
for an operation. I have a sub report that lists every operation a job
will go through with a formula field that gives the status of the
operation.



if {LaborDtl.ActiveTrans}=True

Then "In Progress" & "-" & Totext({LaborDtl.ClockInDate}&"
"&{LaborDtl.ClockinTime}&" "&{EmpBasic.Name})



Else if {LaborDtl.ActiveTrans}=False

Then "Work Stopped"& "-" & totext({LaborDtl.ClockInDate}&"
"&{LaborDtl.ClockOutTime}&" "&{EmpBasic.Name})

Else ""



Problem is that when my operators don't complete the operation on the
first clock in I end up with multiple transactions showing up for each
operation and I only need to see the most recent for each operation.



Thanks,

Chris



########################################################################
Attention:
This email message is privileged and confidential. If you are not the
intended recipient please delete the message and notify the sender.
Any views or opinions presented are solely those of the author.

This email message has been scanned for Viruses and Content and cleared
by MailMarshal SMTP

For more information go to http://www.ramsys.com
########################################################################


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 Links
Dale,

Thank you very much that worked out great.



_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Dale Schuerman
Sent: Wednesday, February 15, 2006 10:37 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Help



I believe if you group by operation, then Date descending, then Time
descending and suppress detail. Any detail fields that you drag into
the Time group header section will be the last record (descending Sort).
Any detail fields that you drag into the Time group footer section will
be the first record (descending Sort). This is reversed if the time
sort is ascending.

Hope this helps.

Dale E. Schuerman
Senior Consultant
RAM Software Systems, Inc.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Bruce Butler
Sent: Wednesday, February 15, 2006 12:05 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Help

Maybe I am underthinking this, but I believe you could set a group based
on the operation, suppress the details, set a condition in your
if-then-else to test for the most recent transaction, and execute.



So basically;



if {LaborDtl.ActiveTrans, maxtrandate} = True then..



Else {LaborDtl.ActiveTrans, maxtrandate} = false then..



Bruce Butler

IT Manager

Knappe & Koester, Inc.

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Chris Crosta
Sent: Tuesday, February 14, 2006 7:07 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Help



Can anyone tell me how to select only the most recent transaction record
for an operation. I have a sub report that lists every operation a job
will go through with a formula field that gives the status of the
operation.



if {LaborDtl.ActiveTrans}=True

Then "In Progress" & "-" & Totext({LaborDtl.ClockInDate}&"
"&{LaborDtl.ClockinTime}&" "&{EmpBasic.Name})



Else if {LaborDtl.ActiveTrans}=False

Then "Work Stopped"& "-" & totext({LaborDtl.ClockInDate}&"
"&{LaborDtl.ClockOutTime}&" "&{EmpBasic.Name})

Else ""



Problem is that when my operators don't complete the operation on the
first clock in I end up with multiple transactions showing up for each
operation and I only need to see the most recent for each operation.



Thanks,

Chris



########################################################################
Attention:
This email message is privileged and confidential. If you are not the
intended recipient please delete the message and notify the sender.
Any views or opinions presented are solely those of the author.

This email message has been scanned for Viruses and Content and cleared
by MailMarshal SMTP

For more information go to http://www.ramsys.com
########################################################################


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/.
<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




SPONSORED LINKS

Manufacturing software
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Database
+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA>

Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ>

Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Data
base+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A>

Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Database+
marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg>

Database management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw>

Database marketing software
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manu
facturing+software&w2=Membership+database+software&w3=Database+mortgage+
software&w4=Pda+database+software&w5=Database+management+software&w6=Dat
abase+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw>



_____

YAHOO! GROUPS LINKS



* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .



_____



[Non-text portions of this message have been removed]
Try this, from Crystal website:

Displaying only the record with the closest date to a parameter, for
each group

http://support.businessobjects.com/library/kbase/articles/c2005926.asp

Joe

--- In vantage@yahoogroups.com, "Chris Crosta" <chris@...> wrote:
>
> Can anyone tell me how to select only the most recent transaction
record
> for an operation. I have a sub report that lists every operation a
job
> will go through with a formula field that gives the status of the
> operation.
>
>
>
> if {LaborDtl.ActiveTrans}=True
>
> Then "In Progress" & "-" & Totext({LaborDtl.ClockInDate}&"
> "&{LaborDtl.ClockinTime}&" "&{EmpBasic.Name})
>
>
>
> Else if {LaborDtl.ActiveTrans}=False
>
> Then "Work Stopped"& "-" & totext({LaborDtl.ClockInDate}&"
> "&{LaborDtl.ClockOutTime}&" "&{EmpBasic.Name})
>
> Else ""
>
>
>
> Problem is that when my operators don't complete the operation on
the
> first clock in I end up with multiple transactions showing up for
each
> operation and I only need to see the most recent for each operation.
>
>
>
> Thanks,
>
> Chris
>
>
>
> [Non-text portions of this message have been removed]
>