Report Builder and Unique records

Yahoo Archive
1
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/
2
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]
3
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]