Vendor Payment Report

Sounds like that would work, too. Thanks for the idea. -Kara

> -----Original Message-----
> From: dans@... [SMTP:dans@...]
> Sent: Thursday, March 28, 2002 1:11 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Vendor Payment Report
>
> Can't you just sort by Vendor, then check date. Then put the fields in
> the
> Date band line and suppress the record line. This should report all of
> the
> information from the latest date.
>
> -----Original Message-----
> From: Kara Stoller [mailto:kstoller@...]
> Sent: Thursday, March 28, 2002 12:38 PM
> To: 'vantage@yahoogroups.com'
> Subject: [Vantage] Vendor Payment Report
>
>
> I am trying to create a RB report that shows all of our vendors and the
> last
> check we sent them -check date and check amount. I created an aggregate
> field to catch the maximum check date. How would I get it to return the
> matching check amount? I know you can't use maximum again, or you'll just
> get the highest dollar amount.
>
> Thanks,
> Kara
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
> HYPERLINK
> "http://rd.yahoo.com/M=217097.1902236.3412362.1261774/D=egroupweb/S=170500
> 71
> 83:HM/A=999859/R=0/*http://service.bfast.com/bfast/click?bfmid=29150849&si
> te
> id=39282504&bfpage=account"
> HYPERLINK
> "http://us.adserver.yahoo.com/l?M=217097.1902236.3412362.1261774/D=egroupm
> ai
> l/S=1705007183:HM/A=999859/rand=303403977"
>
> 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: HYPERLINK
> "http://groups.yahoo.com/group/vantage/files/."http://groups.yahoo.com/gro
> up
> /vantage/files/.
> (2) To search through old msg's goto: HYPERLINK
> "http://groups.yahoo.com/group/vantage/messages"http://groups.yahoo.com/gr
> ou
> p/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto: HYPERLINK
> "http://groups.yahoo.com/group/vantage/links"http://groups.yahoo.com/group
> /v
> antage/links
>
> Your use of Yahoo! Groups is subject to the HYPERLINK
> "http://docs.yahoo.com/info/terms/"Yahoo! Terms of Service.
>
>
>
> ---
> Incoming mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.343 / Virus Database: 190 - Release Date: 3/22/2002
>
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.343 / Virus Database: 190 - Release Date: 3/22/2002
>
>
>
> [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/
>
I am trying to create a RB report that shows all of our vendors and the last
check we sent them -check date and check amount. I created an aggregate
field to catch the maximum check date. How would I get it to return the
matching check amount? I know you can't use maximum again, or you'll just
get the highest dollar amount.

Thanks,
Kara
You could create a calculated variable IIF(CheckDate = MaxCheckDate,
CheckAmount, 0) you may have to make MaxCheckDate a prepass aggregate

-----Original Message-----
From: Kara Stoller [mailto:kstoller@...]
Sent: Thursday, March 28, 2002 11:38 AM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Vendor Payment Report



I am trying to create a RB report that shows all of our vendors and the last
check we sent them -check date and check amount. I created an aggregate
field to catch the maximum check date. How would I get it to return the
matching check amount? I know you can't use maximum again, or you'll just
get the highest dollar amount.

Thanks,
Kara


Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=217097.1902236.3412362.1261774/D=egroupweb/S=17050071
83:HM/A=999859/R=0/*http://service.bfast.com/bfast/click?bfmid=29150849&site
id=39282504&bfpage=account>

<http://us.adserver.yahoo.com/l?M=217097.1902236.3412362.1261774/D=egroupmai
l/S=1705007183:HM/A=999859/rand=303403977>

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
<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
<http://groups.yahoo.com/group/vantage/links>

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]
Works beautifully, thanks. -Kara

> -----Original Message-----
> From: Giallombardo, Ed [SMTP:egiallombardo@...]
> Sent: Thursday, March 28, 2002 12:56 PM
> To: 'vantage@yahoogroups.com'
> Subject: RE: [Vantage] Vendor Payment Report
>
> You could create a calculated variable IIF(CheckDate = MaxCheckDate,
> CheckAmount, 0) you may have to make MaxCheckDate a prepass aggregate
>
> -----Original Message-----
> From: Kara Stoller [mailto:kstoller@...]
> Sent: Thursday, March 28, 2002 11:38 AM
> To: 'vantage@yahoogroups.com'
> Subject: [Vantage] Vendor Payment Report
>
>
>
> I am trying to create a RB report that shows all of our vendors and the
> last
> check we sent them -check date and check amount. I created an aggregate
> field to catch the maximum check date. How would I get it to return the
> matching check amount? I know you can't use maximum again, or you'll just
> get the highest dollar amount.
>
> Thanks,
> Kara
>
>
> Yahoo! Groups Sponsor
>
> ADVERTISEMENT
>
> <
> <http://rd.yahoo.com/M=217097.1902236.3412362.1261774/D=egroupweb/S=170500
> 71>
> 83:HM/A=999859/R=0/*
> <http://service.bfast.com/bfast/click?bfmid=29150849&site>
> id=39282504&bfpage=account>
>
> <
> <http://us.adserver.yahoo.com/l?M=217097.1902236.3412362.1261774/D=egroupm
> ai>
> l/S=1705007183:HM/A=999859/rand=303403977>
>
> 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>
> < <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>
> < <http://groups.yahoo.com/group/vantage/links>>
>
> 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]
>
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
> <http://rd.yahoo.com/M=217097.1902236.3412362.1261774/D=egroupweb/S=170500
> 7183:HM/A=999859/R=0/*http://service.bfast.com/bfast/click?bfmid=29150849&
> siteid=39282504&bfpage=account>
>
> <http://us.adserver.yahoo.com/l?M=217097.1902236.3412362.1261774/D=egroupm
> ail/S=1705007183:HM/A=999859/rand=475023386>
>
> 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
> <http://docs.yahoo.com/info/terms/>.
Can't you just sort by Vendor, then check date.� Then put the fields in the
Date band line and suppress the record line.� This should report all of the
information from the latest date.

-----Original Message-----
From: Kara Stoller [mailto:kstoller@...]
Sent: Thursday, March 28, 2002 12:38 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Vendor Payment Report


I am trying to create a RB report that shows all of our vendors and the last
check we sent them -check date and check amount.� I created an aggregate
field to catch the maximum check date.� How would I get it to return the
matching check amount?� I know you can't use maximum again, or you'll just
get the highest dollar amount.

Thanks,
Kara


Yahoo! Groups Sponsor
ADVERTISEMENT
HYPERLINK
"http://rd.yahoo.com/M=217097.1902236.3412362.1261774/D=egroupweb/S=17050071
83:HM/A=999859/R=0/*http://service.bfast.com/bfast/click?bfmid=29150849&site
id=39282504&bfpage=account"
HYPERLINK
"http://us.adserver.yahoo.com/l?M=217097.1902236.3412362.1261774/D=egroupmai
l/S=1705007183:HM/A=999859/rand=303403977"

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: HYPERLINK
"http://groups.yahoo.com/group/vantage/files/."http://groups.yahoo.com/group
/vantage/files/.�
(2) To search through old msg's goto: HYPERLINK
"http://groups.yahoo.com/group/vantage/messages"http://groups.yahoo.com/grou
p/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: HYPERLINK
"http://groups.yahoo.com/group/vantage/links"http://groups.yahoo.com/group/v
antage/links

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



---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.343 / Virus Database: 190 - Release Date: 3/22/2002



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.343 / Virus Database: 190 - Release Date: 3/22/2002



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