I am actually working on a similar problem. My report is Finished
Goods including Last Transaction Date (STK-CUS). Anyway, How would
you get this "last date" to show in Crystal (I am a new user).
jzabilka@...
--- In vantage@yahoogroups.com, "Frank Zeigafuse" <fzeigafuse@l...>
wrote:
/D=gr
6/D=gr
//comp
6/D=gr
//comp
The email and any files transmitted with it are confidential to the
intended recipient at the e-mail address to which it has been
addressed. It may not be disclosed or used by any other than that
addressee, nor may it be copied in any way. If received in error,
please delete and notify the sender via e-mail or sales@L... quoting
the name of the sender. Messages sent via this medium may be subject
to delays, non-delivery and unauthorized alteration. This e-mail has
been prepared using information believed by the author to be reliable
and accurate. Unless expressly stated otherwise, this e-mail does not
form part of a legally binding contract or agreement between
recipient and Innovative Office Products, Inc.
email, we cannot accept responsibility for any loss or damage arising
from the use of this email or attachments. It is, therefore, your
responsibility to scan attachments (if any).
Goods including Last Transaction Date (STK-CUS). Anyway, How would
you get this "last date" to show in Crystal (I am a new user).
jzabilka@...
--- In vantage@yahoogroups.com, "Frank Zeigafuse" <fzeigafuse@l...>
wrote:
> I would probably use part-tran but I like your idea of notsuppressing
>date for
>
>
> Frank Zeigafuse
>
> Innovative Office Products
>
> General Manager
>
> Direct Phone: 610-559-6369
>
> Email: fzeigafuse@L...
>
>
>
> -----Original Message-----
> From: Todd Caughey [mailto:caugheyt@h...]
> Sent: Wednesday, July 14, 2004 9:32 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Report Builder - report of last purchase
> vendorsturns out
>
>
> I thought I had a report like this and looked for it yesterday but
> I didn't. Also, I was not sure what constitutes "purchase".Whether it is
> PO date or APTran date (when paid). Either way a suggestion wouldbe to
> start with Vendor and Left Outer link down to whichever (PO orTran) in
> order to get vendors with no activity (? for date). Also instead ofshow the
> suppresing records just report at Vendor group footer which will
> last (highest) date from the records.date for
> -Todd C.
>
> -----Original Message-----
> From: Frank Zeigafuse [mailto:fzeigafuse@l...]
> Sent: Wednesday, July 14, 2004 8:17 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Report Builder - report of last purchase
> vendorsfor vendors
>
>
> in crystal I think it would be pretty easy
>
> group by vender
> sort by tran-date descending
>
> suppress each record if tran-date <> max(tran-date) for the vender
>
>
>
> Frank Zeigafuse
>
> Innovative Office Products
>
> General Manager
>
> Direct Phone: 610-559-6369
>
> Email: fzeigafuse@L...
>
>
>
> -----Original Message-----
> From: Lepley, Scott A. [mailto:sal@m...]
> Sent: Tuesday, July 13, 2004 3:48 PM
> To: Online Vantage Users Group (E-mail)
> Cc: Central PA Vantage Users Group (E-mail)
> Subject: [Vantage] Report Builder - report of last purchase date
>purchase date
>
> Does anyone have a Report Builder report that lists the last
> for vendors or can anyone suggest how to build this query as anexport?
>must have
> Regards,
> Scott Lepley
> Systems Administrator
> Mauell Corporation
> Phone: 717-432-8686, ext. 14
> Fax: 717-432-8688
> Email: sal@m...
> Vantage version: 6.10.511
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> already linked your email address to a yahoo id to enable access. )Builder and
> (1) To access the Files Section of our Yahoo!Group for Report
> Crystal Reports and other 'goodies', please goto:http://us.ard.yahoo.com/SIG=129qr37ss/M=295196.4901138.6071305.3001176
> 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
>
> <
>
/D=gr
> oups/S=1705007183:HM/EXP=1089834499/A=2128215/R=0/SIG=10se96mf6/*M=295196.4901138.6071305.3001176/D=groups/S=
> http://comp
> anion.yahoo.com> click here
>
> <
> http://us.adserver.yahoo.com/l?
> :HM/A=2128215/rand=870662248>Service
>
>
> _____
>
> Yahoo! Groups Links
>
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/vantage/
>
>
> * 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
> < http://docs.yahoo.com/info/terms/> .the views
>
>
>
> <www.LCDarms.com> -- Ergonomic mounting solutions for monitors and
> keyboards
>
> This e-mail is from Innovative Office Products, Inc. but expresses
> of the sender and not necessarily the views of the company. Theemail and
> any files transmitted with it are confidential to the intendedrecipient at
> the e-mail address to which it has been addressed. It may not bedisclosed
> or used by any other than that addressee, nor may it be copied inany way.
> If received in error, please delete and notify the sender via e-mail or
> sales@L... quoting the name of the sender. Messages sent via thisalteration.
> medium may be subject to delays, non-delivery and unauthorized
> This e-mail has been prepared using information believed by theauthor to be
> reliable and accurate. Unless expressly stated otherwise, this e-mail does
> not form part of a legally binding contract or agreement betweenrecipient
> and Innovative Office Products, Inc.reasonable
>
> Warning: Although Innovative Office Products, Inc. has taken
> precautions to ensure no viruses are present in this email, wecannot accept
> responsibility for any loss or damage arising from the use of thisemail or
> attachments. It is, therefore, your responsibility to scanattachments (if
> any).must have
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> already linked your email address to a yahoo id to enable access. )Builder and
> (1) To access the Files Section of our Yahoo!Group for Report
> Crystal Reports and other 'goodies', please goto:<http://us.ard.yahoo.com/SIG=129le66mf/M=295196.4901138.6071305.300117
> 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
>
6/D=gr
>oups/S=1705007183:HM/EXP=1089897457/A=2128215/R=0/SIG=10se96mf6/*http:
//comp
> anion.yahoo.com> click hereM=295196.4901138.6071305.3001176/D=groups/S=
>
> <http://us.adserver.yahoo.com/l?
> :HM/A=2128215/rand=271591860>Service
>
>
> _____
>
> Yahoo! Groups Links
>
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/vantage/
>
>
> * 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
> <http://docs.yahoo.com/info/terms/> .must have
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> already linked your email address to a yahoo id to enable access. )Builder and
> (1) To access the Files Section of our Yahoo!Group for Report
> Crystal Reports and other 'goodies', please goto:<http://us.ard.yahoo.com/SIG=129grarda/M=295196.4901138.6071305.300117
> 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
>
>
6/D=gr
>oups/S=1705007183:HM/EXP=1089898318/A=2128215/R=0/SIG=10se96mf6/*http:
//comp
> anion.yahoo.com> click hereM=295196.4901138.6071305.3001176/D=groups/S=
>
> <http://us.adserver.yahoo.com/l?
> :HM/A=2128215/rand=792214618>Service
>
>
> _____
>
> Yahoo! Groups Links
>
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/vantage/
>
>
> * 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
> <http://docs.yahoo.com/info/terms/> .and keyboards
>
>
>
> <www.LCDarms.com> -- Ergonomic mounting solutions for monitors
>the views of the sender and not necessarily the views of the company.
> This e-mail is from Innovative Office Products, Inc. but expresses
The email and any files transmitted with it are confidential to the
intended recipient at the e-mail address to which it has been
addressed. It may not be disclosed or used by any other than that
addressee, nor may it be copied in any way. If received in error,
please delete and notify the sender via e-mail or sales@L... quoting
the name of the sender. Messages sent via this medium may be subject
to delays, non-delivery and unauthorized alteration. This e-mail has
been prepared using information believed by the author to be reliable
and accurate. Unless expressly stated otherwise, this e-mail does not
form part of a legally binding contract or agreement between
recipient and Innovative Office Products, Inc.
>reasonable precautions to ensure no viruses are present in this
> Warning: Although Innovative Office Products, Inc. has taken
email, we cannot accept responsibility for any loss or damage arising
from the use of this email or attachments. It is, therefore, your
responsibility to scan attachments (if any).
>
>
>
> [Non-text portions of this message have been removed]