Thank you, Troy. It worked perfectly.
Mario Aguirre
Lakin General
-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Thursday, May 09, 2002 11:02 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Report Builder and Unique records
Sort and group at some "unique" level (like part or order) and then report
in a group footer. Inhibit printing of record group.
-Todd C.
-----Original Message-----
From: Mario Aguirre [mailto:maguirre@...]
Sent: Thursday, May 09, 2002 10:46 AM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Report Builder and Unique records
Hi Group!
We do not associate orders with jobs. If I wanted to know the lowest price I
am selling for a part produced, when I link the invoice detail to job
assembly or job header, I get the same record duplicated as many times as
records matched in the invoice detail table. In Access, I could modify the
query to display unique values. Is there a similar function in Report
Builder? I took a look at a Unique function in the help file and gave me a
headache.
Any ideas? Thank you all in advance.
Mario Aguirre
ILakin General
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/M=194081.2053425.3521449.1829184/D=egroupweb/S=17050071
83:HM/A=1036975/R=0/*http://www.ediets.com/start.cfm?code=3225> Click Here!
<http://us.adserver.yahoo.com/l?M=194081.2053425.3521449.1829184/D=egroupmai
l/S=1705007183:HM/A=1036975/rand=744254359>
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]
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/
Mario Aguirre
Lakin General
-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Thursday, May 09, 2002 11:02 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Report Builder and Unique records
Sort and group at some "unique" level (like part or order) and then report
in a group footer. Inhibit printing of record group.
-Todd C.
-----Original Message-----
From: Mario Aguirre [mailto:maguirre@...]
Sent: Thursday, May 09, 2002 10:46 AM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Report Builder and Unique records
Hi Group!
We do not associate orders with jobs. If I wanted to know the lowest price I
am selling for a part produced, when I link the invoice detail to job
assembly or job header, I get the same record duplicated as many times as
records matched in the invoice detail table. In Access, I could modify the
query to display unique values. Is there a similar function in Report
Builder? I took a look at a Unique function in the help file and gave me a
headache.
Any ideas? Thank you all in advance.
Mario Aguirre
ILakin General
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/M=194081.2053425.3521449.1829184/D=egroupweb/S=17050071
83:HM/A=1036975/R=0/*http://www.ediets.com/start.cfm?code=3225> Click Here!
<http://us.adserver.yahoo.com/l?M=194081.2053425.3521449.1829184/D=egroupmai
l/S=1705007183:HM/A=1036975/rand=744254359>
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]
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/