I meant resend email...need my vacation now...
M. Manasa Reddy
manasa@...
P: 630-806-2000
F: 630-806-2001
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Manasa Reddy
Sent: Thursday, May 22, 2008 8:49 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re:Crystal Reports help
Debbie, thanks for the reply...I was starting to think to report this
email!
I'll give it a shot.
M. Manasa Reddy
manasa@... <mailto:manasa%40weldcoa.com>
P: 630-806-2000
F: 630-806-2001
________________________________
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Debbie Stokes
Sent: Thursday, May 22, 2008 4:50 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re:Crystal Reports help
Hi there,
You asked how to get the latest BOM rev in a crystal report. You could
try this (I didn't test it but i think it will be ok) :
Group by part, put the part rev records in the detail area. order the
detail by either rev num, approved date or effective date - whichever
orders the data for you with the required row at the end. Now put your
required row in the group footer row and hide the detail area. This
should then only show the last record.
kind regards
Debbie Stokes
Vantage Administrator
Hilo-PSS Group
01793 647136
************************************************************************
************************************************************************
************************************************************************
*******************************************************
This email is intended for the addressee only and may contain
information that is privileged and confidential. If you are not the
intended recipient, you must not copy, distribute or take any
action in reliance on it. If this email has been sent to you in error,
please notify us immediately by telephone.
This has been transmitted by -
Hilo-PSS Group
Murdock Road
Dorcan Industrial Estate
Swindon
SN3 5HY
Company Registration No: 01028915.
The views within this email are those of the author and not
necessarily those of Planned Storage Systems Ltd.
** This email has been scanned for viruses, vandals and malicious
content **
************************************************************************
************************************************************************
************************************************
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
M. Manasa Reddy
manasa@...
P: 630-806-2000
F: 630-806-2001
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Manasa Reddy
Sent: Thursday, May 22, 2008 8:49 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re:Crystal Reports help
Debbie, thanks for the reply...I was starting to think to report this
email!
I'll give it a shot.
M. Manasa Reddy
manasa@... <mailto:manasa%40weldcoa.com>
P: 630-806-2000
F: 630-806-2001
________________________________
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Debbie Stokes
Sent: Thursday, May 22, 2008 4:50 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re:Crystal Reports help
Hi there,
You asked how to get the latest BOM rev in a crystal report. You could
try this (I didn't test it but i think it will be ok) :
Group by part, put the part rev records in the detail area. order the
detail by either rev num, approved date or effective date - whichever
orders the data for you with the required row at the end. Now put your
required row in the group footer row and hide the detail area. This
should then only show the last record.
kind regards
Debbie Stokes
Vantage Administrator
Hilo-PSS Group
01793 647136
************************************************************************
************************************************************************
************************************************************************
*******************************************************
This email is intended for the addressee only and may contain
information that is privileged and confidential. If you are not the
intended recipient, you must not copy, distribute or take any
action in reliance on it. If this email has been sent to you in error,
please notify us immediately by telephone.
This has been transmitted by -
Hilo-PSS Group
Murdock Road
Dorcan Industrial Estate
Swindon
SN3 5HY
Company Registration No: 01028915.
The views within this email are those of the author and not
necessarily those of Planned Storage Systems Ltd.
** This email has been scanned for viruses, vandals and malicious
content **
************************************************************************
************************************************************************
************************************************
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]