I would link INVOICES to Customer (invoices being the main table) then
SORT and Group by Customers with a secondary sort on invoice date,
create an aggregate field on the invoice (MAX (invoice date). Delete the
record line for the invoices so that only the Customer name and your
aggregate field shows. Then create a calculated field: IF(MAX(INVOICE
DATE) >= TARGET DATE, TRUE, FALSE). Then set your visible band lines to
conditional printing and user your true false calculation to print out
the customer name and purchase date. Simple. (Oh yeah, you can put
all your printing fields in to the group footer and delete the extra's
so you get a nice neat single space report)
Shirley Graver
Sys Admin
Rubber Associates inc
-----Original Message-----
From: Todd Hofert [mailto:thofert@...]
Sent: Wednesday, September 24, 2003 1:11 PM
To: Vantage List (E-mail)
Subject: [Vantage] RB Help
I am trying to create a report that will list all customers who have not
purchased from us in the last year. I am having trouble figuring out how
to tell RB how to identify those customers. Does anyone have
suggestions?
Thanks
Todd Hofert
IT Director
Spartan Graphics, Inc.
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/M=194081.3897168.5135684.1261774/D=egroupweb/S=1705
007183:HM/A=1706996/R=0/SIG=11p5b9ris/*http:/www.ediets.com/start.cfm?co
de=30509&media=atkins> click here
<http://us.adserver.yahoo.com/l?M=194081.3897168.5135684.1261774/D=egrou
pmail/S=:HM/A=1706996/rand=390580421>
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
Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.
Tracking #: 385B74C308B0FE418230BF7E9CE930070D776260
[Non-text portions of this message have been removed]
SORT and Group by Customers with a secondary sort on invoice date,
create an aggregate field on the invoice (MAX (invoice date). Delete the
record line for the invoices so that only the Customer name and your
aggregate field shows. Then create a calculated field: IF(MAX(INVOICE
DATE) >= TARGET DATE, TRUE, FALSE). Then set your visible band lines to
conditional printing and user your true false calculation to print out
the customer name and purchase date. Simple. (Oh yeah, you can put
all your printing fields in to the group footer and delete the extra's
so you get a nice neat single space report)
Shirley Graver
Sys Admin
Rubber Associates inc
-----Original Message-----
From: Todd Hofert [mailto:thofert@...]
Sent: Wednesday, September 24, 2003 1:11 PM
To: Vantage List (E-mail)
Subject: [Vantage] RB Help
I am trying to create a report that will list all customers who have not
purchased from us in the last year. I am having trouble figuring out how
to tell RB how to identify those customers. Does anyone have
suggestions?
Thanks
Todd Hofert
IT Director
Spartan Graphics, Inc.
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/M=194081.3897168.5135684.1261774/D=egroupweb/S=1705
007183:HM/A=1706996/R=0/SIG=11p5b9ris/*http:/www.ediets.com/start.cfm?co
de=30509&media=atkins> click here
<http://us.adserver.yahoo.com/l?M=194081.3897168.5135684.1261774/D=egrou
pmail/S=:HM/A=1706996/rand=390580421>
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
Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.
Tracking #: 385B74C308B0FE418230BF7E9CE930070D776260
[Non-text portions of this message have been removed]