Simple RB question

I got it, I grouped by every column and told it print once

Thomas Wojewoda


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Caughey
Sent: Wednesday, August 17, 2005 11:42 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Simple RB question

Any chance the Job Assembly table is somehow involved? Messes me up
every time with I don't filter for level zero when getting job costs.
End up with one job for each assembly level. I see the number of
"repeats" are variable as if different number of assembly levels on the
jobs.
-Todd C.

-----Original Message-----
From: Thomas Wojewoda [mailto:twojewoda@...]
Sent: Wednesday, August 17, 2005 11:33 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Simple RB question


It looks like this:

JobHead
Printed: 08/17/05 11:30


JobNum PartNum JCDept Description
031632R MM52118-01 1919S
1919-Secondary
031632R 1919S
1919-Secondary
031665 fr60217-00 1919S
1919-Secondary
031665 1919S
1919-Secondary
031758-1 7260087-1 1919S
1919-Secondary
031758-1 1919S
1919-Secondary
032045 45042 1919S
1919-Secondary
032045 1919S
1919-Secondary
032045 1919S
1919-Secondary
032045 1919S
1919-Secondary
032045 1919S
1919-Secondary
032045 1919S
1919-Secondary
032045 1919S
1919-Secondary
032045 1919S
1919-Secondary
032045 1919S
1919-Secondary
032045 1919S
1919-Secondary
032045 1919S
1919-Secondary
032045 1919S
1919-Secondary
032045 1919S
1919-Secondary
032145R3 T97CJ071E 1919S
1919-Secondary
032145R3 1919S
1919-Secondary
032145R3 1919S
1919-Secondary
032145R3 1919S
1919-Secondary
032145R3 1919S
1919-Secondary
032145R3 1919S
1919-Secondary
032145R3 1919S
1919-Secondary
032206R D75-98312-6U 1919S
1919-Secondary
032248 5001718 1919S
1919-Secondary
032312R C65-11332-6U 1919S
1919-Secondary
032312R 1919S
1919-Secondary
032321 319695 1919S
1919-Secondary
032321 1919S
1919-Secondary
032321 1919S
1919-Secondary
032321 1919S
1919-Secondary
032321 1919S
1919-Secondary
032321 1919S
1919-Secondary
032321 1919S
1919-Secondary
032321 1919S
1919-Secondary
032321 1919S
1919-Secondary
032321 1919S
1919-Secondary
032390 t97cf065f 1919S
1919-Secondary
032390 1919S
1919-Secondary
032390 1919S
1919-Secondary
032390 1919S
1919-Secondary
032391 1919S
1919-Secondary
032391 1919S
1919-Secondary
032392 t97cf565f 1919S
1919-Secondary
032392 1919S
1919-Secondary
032666 24-7702 1919S
1919-Secondary
032666 1919S
1919-Secondary
032666 1919S
1919-Secondary
032666 1919S
1919-Secondary
032666 1919S
1919-Secondary

Page 1

Thomas Wojewoda


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Shirley Graver
Sent: Wednesday, August 17, 2005 11:28 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Simple RB question

Do your sorts match up with your groups?

shirley



********************
This transmission may contain information that is privileged,
confidential and/or exempt from disclosure under applicable law. If you
are not the intended recipient, you are hereby notified that any
disclosure, copying, distribution, or use of the information contained
herein (including any reliance thereon) is STRICTLY PROHIBITED. If you
received this transmission in error, please immediately contact the
sender and destroy the material in its entirety, whether in electronic
or hard copy format. Thank you.






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



_____

YAHOO! GROUPS LINKS



* Visit your group " vantage
<http://groups.yahoo.com/group/vantage> " on the web.


* 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
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
Yahoo! Groups Links
How do I get rid of repetitions?
What I mean is, I've made a report for active parts in a list of job
costing departments by pulling them from the LaborDTL and JobHead
tables. The report comes out fine, but every part (job) lists more than
once in the report, since it has more than one operation done in that
department. How do I filter the results so it shows me the part (job)
number only once?

Thomas Wojewoda
IS Manager
Principal Manufacturing Corp.
2800 South 19th Ave
60155 Broadview IL
phone: (708) 865 7500 ext 544
fax: (708) 865 7632
cell: (708) 259 4864
http://www.principalmfg.com



********************
This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you.





[Non-text portions of this message have been removed]
Sort And Group on Job Number, add Group line for Job number, add data fields
you want to display, turn off printing of record row.


Patrick Winter

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Thomas Wojewoda
Sent: Wednesday, August 17, 2005 10:26 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Simple RB question

How do I get rid of repetitions?
What I mean is, I've made a report for active parts in a list of job costing
departments by pulling them from the LaborDTL and JobHead tables. The report
comes out fine, but every part (job) lists more than once in the report,
since it has more than one operation done in that department. How do I
filter the results so it shows me the part (job) number only once?

Thomas Wojewoda
IS Manager
Principal Manufacturing Corp.
2800 South 19th Ave
60155 Broadview IL
phone: (708) 865 7500 ext 544
fax: (708) 865 7632
cell: (708) 259 4864
http://www.principalmfg.com



********************
This transmission may contain information that is privileged, confidential
and/or exempt from disclosure under applicable law. If you are not the
intended recipient, you are hereby notified that any disclosure, copying,
distribution, or use of the information contained herein (including any
reliance thereon) is STRICTLY PROHIBITED. If you received this transmission
in error, please immediately contact the sender and destroy the material in
its entirety, whether in electronic or hard copy format. Thank you.





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



------------------------ Yahoo! Groups Sponsor --------------------~-->
<font face=arial size=-1><a
href="http://us.ard.yahoo.com/SIG=12hmlmmsj/M=362329.6886308.7839368.1510227
/D=groups/S=1705007183:TM/Y=YAHOO/EXP=1124299524/A=2894321/R=0/SIG=11dvsfulr
/*http://youthnoise.com/page.php?page_id=1992
">Fair play? Video games influencing politics. Click and talk
back!</a>.</font>
--------------------------------------------------------------------~->

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
Yahoo! Groups Links
The simplest way is to set up a GROUP by part number. Then delete the
detail line. You have changing/multiple records referencing your part
number which is causing the "repeats". You just aren't displaying the
changing/multiple field in your report.

Shirley Graver
Rubber Associates

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Thomas Wojewoda
Sent: Wednesday, August 17, 2005 11:26 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Simple RB question

How do I get rid of repetitions?
What I mean is, I've made a report for active parts in a list of job
costing departments by pulling them from the LaborDTL and JobHead
tables. The report comes out fine, but every part (job) lists more than
once in the report, since it has more than one operation done in that
department. How do I filter the results so it shows me the part (job)
number only once?

Thomas Wojewoda
IS Manager
Principal Manufacturing Corp.
2800 South 19th Ave
60155 Broadview IL
phone: (708) 865 7500 ext 544
fax: (708) 865 7632
cell: (708) 259 4864
http://www.principalmfg.com



********************
This transmission may contain information that is privileged, confidential
and/or exempt from disclosure under applicable law. If you are not the
intended recipient, you are hereby notified that any disclosure, copying,
distribution, or use of the information contained herein (including any
reliance thereon) is STRICTLY PROHIBITED. If you received this transmission
in error, please immediately contact the sender and destroy the material in
its entirety, whether in electronic or hard copy format. Thank you.





[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/.
<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



SPONSORED LINKS

Technical
<http://groups.yahoo.com/gads?t=ms&k=Technical+support&w1=Technical+support&
w2=Vantage&w3=Database&w4=Database+management+software&w5=Membership+databas
e+software&w6=Church+database+software&c=6&s=148&.sig=D_JdAFeHAoeH6OugOKk1Yg
> support
Vantage
<http://groups.yahoo.com/gads?t=ms&k=Vantage&w1=Technical+support&w2=Vantage
&w3=Database&w4=Database+management+software&w5=Membership+database+software
&w6=Church+database+software&c=6&s=148&.sig=8zJYQk3edGWFMUVgup9jKw>
Database
<http://groups.yahoo.com/gads?t=ms&k=Database&w1=Technical+support&w2=Vantag
e&w3=Database&w4=Database+management+software&w5=Membership+database+softwar
e&w6=Church+database+software&c=6&s=148&.sig=PnI9nhHllVsjEbHxRXs1IQ>

Database
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Technic
al+support&w2=Vantage&w3=Database&w4=Database+management+software&w5=Members
hip+database+software&w6=Church+database+software&c=6&s=148&.sig=fKR9gtx-Yh-
u9MWSh0_-hA> management software
Membership
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Technic
al+support&w2=Vantage&w3=Database&w4=Database+management+software&w5=Members
hip+database+software&w6=Church+database+software&c=6&s=148&.sig=Nu4StMQZ8LT
26M5TzRGQlg> database software
Church
<http://groups.yahoo.com/gads?t=ms&k=Church+database+software&w1=Technical+s
upport&w2=Vantage&w3=Database&w4=Database+management+software&w5=Membership+
database+software&w6=Church+database+software&c=6&s=148&.sig=UAiQi3Ftbp7Qnq6
ys_yZxg> database software

_____

YAHOO! GROUPS LINKS

* Visit your group "vantage <http://groups.yahoo.com/group/vantage> "
on the web.

* 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 Service
<http://docs.yahoo.com/info/terms/> .

_____


Tracking #: 8654FFDF13CFA54A9D6F184B4E3F3597E6164D5A


[Non-text portions of this message have been removed]
That's my problem, I'm not printing any details and still I get
multiples.

Thomas Wojewoda


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Shirley Graver
Sent: Wednesday, August 17, 2005 10:44 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Simple RB question

The simplest way is to set up a GROUP by part number. Then delete the
detail line. You have changing/multiple records referencing your part
number which is causing the "repeats". You just aren't displaying the
changing/multiple field in your report.

Shirley Graver
Rubber Associates

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of
Thomas Wojewoda
Sent: Wednesday, August 17, 2005 11:26 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Simple RB question

How do I get rid of repetitions?
What I mean is, I've made a report for active parts in a list of job
costing departments by pulling them from the LaborDTL and JobHead
tables. The report comes out fine, but every part (job) lists more than
once in the report, since it has more than one operation done in that
department. How do I filter the results so it shows me the part (job)
number only once?

Thomas Wojewoda
IS Manager
Principal Manufacturing Corp.
2800 South 19th Ave
60155 Broadview IL
phone: (708) 865 7500 ext 544
fax: (708) 865 7632
cell: (708) 259 4864
http://www.principalmfg.com



********************
This transmission may contain information that is privileged,
confidential
and/or exempt from disclosure under applicable law. If you are not the
intended recipient, you are hereby notified that any disclosure,
copying,
distribution, or use of the information contained herein (including any
reliance thereon) is STRICTLY PROHIBITED. If you received this
transmission
in error, please immediately contact the sender and destroy the material
in
its entirety, whether in electronic or hard copy format. Thank you.





[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/.
<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



SPONSORED LINKS

Technical
<http://groups.yahoo.com/gads?t=ms&k=Technical+support&w1=Technical+supp
ort&
w2=Vantage&w3=Database&w4=Database+management+software&w5=Membership+dat
abas
e+software&w6=Church+database+software&c=6&s=148&.sig=D_JdAFeHAoeH6OugOK
k1Yg
> support
Vantage
<http://groups.yahoo.com/gads?t=ms&k=Vantage&w1=Technical+support&w2=Van
tage
&w3=Database&w4=Database+management+software&w5=Membership+database+soft
ware
&w6=Church+database+software&c=6&s=148&.sig=8zJYQk3edGWFMUVgup9jKw>
Database
<http://groups.yahoo.com/gads?t=ms&k=Database&w1=Technical+support&w2=Va
ntag
e&w3=Database&w4=Database+management+software&w5=Membership+database+sof
twar
e&w6=Church+database+software&c=6&s=148&.sig=PnI9nhHllVsjEbHxRXs1IQ>

Database
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Tec
hnic
al+support&w2=Vantage&w3=Database&w4=Database+management+software&w5=Mem
bers
hip+database+software&w6=Church+database+software&c=6&s=148&.sig=fKR9gtx
-Yh-
u9MWSh0_-hA> management software
Membership
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Tec
hnic
al+support&w2=Vantage&w3=Database&w4=Database+management+software&w5=Mem
bers
hip+database+software&w6=Church+database+software&c=6&s=148&.sig=Nu4StMQ
Z8LT
26M5TzRGQlg> database software
Church
<http://groups.yahoo.com/gads?t=ms&k=Church+database+software&w1=Technic
al+s
upport&w2=Vantage&w3=Database&w4=Database+management+software&w5=Members
hip+
database+software&w6=Church+database+software&c=6&s=148&.sig=UAiQi3Ftbp7
Qnq6
ys_yZxg> database software

_____

YAHOO! GROUPS LINKS

* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> "
on the web.

* 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
Service
<http://docs.yahoo.com/info/terms/> .

_____


Tracking #: 8654FFDF13CFA54A9D6F184B4E3F3597E6164D5A


[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
Yahoo! Groups Links
Do your sorts match up with your groups?

shirley

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Thomas Wojewoda
Sent: Wednesday, August 17, 2005 12:20 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Simple RB question

That's my problem, I'm not printing any details and still I get
multiples.

Thomas Wojewoda


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Shirley Graver
Sent: Wednesday, August 17, 2005 10:44 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Simple RB question

The simplest way is to set up a GROUP by part number. Then delete the
detail line. You have changing/multiple records referencing your part
number which is causing the "repeats". You just aren't displaying the
changing/multiple field in your report.

Shirley Graver
Rubber Associates

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of
Thomas Wojewoda
Sent: Wednesday, August 17, 2005 11:26 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Simple RB question

How do I get rid of repetitions?
What I mean is, I've made a report for active parts in a list of job
costing departments by pulling them from the LaborDTL and JobHead
tables. The report comes out fine, but every part (job) lists more than
once in the report, since it has more than one operation done in that
department. How do I filter the results so it shows me the part (job)
number only once?

Thomas Wojewoda
IS Manager
Principal Manufacturing Corp.
2800 South 19th Ave
60155 Broadview IL
phone: (708) 865 7500 ext 544
fax: (708) 865 7632
cell: (708) 259 4864
http://www.principalmfg.com



********************
This transmission may contain information that is privileged,
confidential
and/or exempt from disclosure under applicable law. If you are not the
intended recipient, you are hereby notified that any disclosure,
copying,
distribution, or use of the information contained herein (including any
reliance thereon) is STRICTLY PROHIBITED. If you received this
transmission
in error, please immediately contact the sender and destroy the material
in
its entirety, whether in electronic or hard copy format. Thank you.





[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/.
<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



SPONSORED LINKS

Technical
<http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Technical+support&w1=Technical+supp>
&k=Technical+support&w1=Technical+supp
ort&
w2=Vantage&w3=Database&w4=Database+management+software&w5=Membership+dat
abas
e+software&w6=Church+database+software&c=6&s=148&.sig=D_JdAFeHAoeH6OugOK
k1Yg
> support
Vantage
<http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Vantage&w1=Technical+support&w2=Van>
&k=Vantage&w1=Technical+support&w2=Van
tage
&w3=Database&w4=Database+management+software&w5=Membership+database+soft
ware
&w6=Church+database+software&c=6&s=148&.sig=8zJYQk3edGWFMUVgup9jKw>
Database
<http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Database&w1=Technical+support&w2=Va>
&k=Database&w1=Technical+support&w2=Va
ntag
e&w3=Database&w4=Database+management+software&w5=Membership+database+sof
twar
e&w6=Church+database+software&c=6&s=148&.sig=PnI9nhHllVsjEbHxRXs1IQ>

Database
<http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Tec>
&k=Database+management+software&w1=Tec
hnic
al+support&w2=Vantage&w3=Database&w4=Database+management+software&w5=Mem
bers
hip+database+software&w6=Church+database+software&c=6&s=148&.sig=fKR9gtx
-Yh-
u9MWSh0_-hA> management software
Membership
<http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Tec>
&k=Membership+database+software&w1=Tec
hnic
al+support&w2=Vantage&w3=Database&w4=Database+management+software&w5=Mem
bers
hip+database+software&w6=Church+database+software&c=6&s=148&.sig=Nu4StMQ
Z8LT
26M5TzRGQlg> database software
Church
<http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Church+database+software&w1=Technic>
&k=Church+database+software&w1=Technic
al+s
upport&w2=Vantage&w3=Database&w4=Database+management+software&w5=Members
hip+
database+software&w6=Church+database+software&c=6&s=148&.sig=UAiQi3Ftbp7
Qnq6
ys_yZxg> database software

_____

YAHOO! GROUPS LINKS

* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> "
on the web.

* 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
Service
<http://docs.yahoo.com/info/terms/> .

_____


Tracking #: 8654FFDF13CFA54A9D6F184B4E3F3597E6164D5A


[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/.
<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 Links









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



_____

YAHOO! GROUPS LINKS

* Visit your group "vantage <http://groups.yahoo.com/group/vantage> "
on the web.

* 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 Service
<http://docs.yahoo.com/info/terms/> .

_____



[Non-text portions of this message have been removed]
It looks like this:

JobHead
Printed: 08/17/05 11:30


JobNum PartNum JCDept Description
031632R MM52118-01 1919S
1919-Secondary
031632R 1919S
1919-Secondary
031665 fr60217-00 1919S
1919-Secondary
031665 1919S
1919-Secondary
031758-1 7260087-1 1919S
1919-Secondary
031758-1 1919S
1919-Secondary
032045 45042 1919S
1919-Secondary
032045 1919S
1919-Secondary
032045 1919S
1919-Secondary
032045 1919S
1919-Secondary
032045 1919S
1919-Secondary
032045 1919S
1919-Secondary
032045 1919S
1919-Secondary
032045 1919S
1919-Secondary
032045 1919S
1919-Secondary
032045 1919S
1919-Secondary
032045 1919S
1919-Secondary
032045 1919S
1919-Secondary
032045 1919S
1919-Secondary
032145R3 T97CJ071E 1919S
1919-Secondary
032145R3 1919S
1919-Secondary
032145R3 1919S
1919-Secondary
032145R3 1919S
1919-Secondary
032145R3 1919S
1919-Secondary
032145R3 1919S
1919-Secondary
032145R3 1919S
1919-Secondary
032206R D75-98312-6U 1919S
1919-Secondary
032248 5001718 1919S
1919-Secondary
032312R C65-11332-6U 1919S
1919-Secondary
032312R 1919S
1919-Secondary
032321 319695 1919S
1919-Secondary
032321 1919S
1919-Secondary
032321 1919S
1919-Secondary
032321 1919S
1919-Secondary
032321 1919S
1919-Secondary
032321 1919S
1919-Secondary
032321 1919S
1919-Secondary
032321 1919S
1919-Secondary
032321 1919S
1919-Secondary
032321 1919S
1919-Secondary
032390 t97cf065f 1919S
1919-Secondary
032390 1919S
1919-Secondary
032390 1919S
1919-Secondary
032390 1919S
1919-Secondary
032391 1919S
1919-Secondary
032391 1919S
1919-Secondary
032392 t97cf565f 1919S
1919-Secondary
032392 1919S
1919-Secondary
032666 24-7702 1919S
1919-Secondary
032666 1919S
1919-Secondary
032666 1919S
1919-Secondary
032666 1919S
1919-Secondary
032666 1919S
1919-Secondary

Page 1

Thomas Wojewoda


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Shirley Graver
Sent: Wednesday, August 17, 2005 11:28 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Simple RB question

Do your sorts match up with your groups?

shirley



********************
This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you.
That desc field is a part of the JCD desc, and it's not tied to the part
or job, I tried doing it without and same effect

Thomas Wojewoda


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Thomas Wojewoda
Sent: Wednesday, August 17, 2005 11:33 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Simple RB question

It looks like this:

JobHead
Printed: 08/17/05 11:30


JobNum PartNum JCDept Description
031632R MM52118-01 1919S
1919-Secondary
031632R 1919S
1919-Secondary
031665 fr60217-00 1919S
1919-Secondary
031665 1919S
1919-Secondary
031758-1 7260087-1 1919S
1919-Secondary
031758-1 1919S
1919-Secondary
032045 45042 1919S
1919-Secondary
032045 1919S
1919-Secondary
032045 1919S
1919-Secondary
032045 1919S
1919-Secondary
032045 1919S
1919-Secondary
032045 1919S
1919-Secondary
032045 1919S
1919-Secondary
032045 1919S
1919-Secondary
032045 1919S
1919-Secondary
032045 1919S
1919-Secondary
032045 1919S
1919-Secondary
032045 1919S
1919-Secondary
032045 1919S
1919-Secondary
032145R3 T97CJ071E 1919S
1919-Secondary
032145R3 1919S
1919-Secondary
032145R3 1919S
1919-Secondary
032145R3 1919S
1919-Secondary
032145R3 1919S
1919-Secondary
032145R3 1919S
1919-Secondary
032145R3 1919S
1919-Secondary
032206R D75-98312-6U 1919S
1919-Secondary
032248 5001718 1919S
1919-Secondary
032312R C65-11332-6U 1919S
1919-Secondary
032312R 1919S
1919-Secondary
032321 319695 1919S
1919-Secondary
032321 1919S
1919-Secondary
032321 1919S
1919-Secondary
032321 1919S
1919-Secondary
032321 1919S
1919-Secondary
032321 1919S
1919-Secondary
032321 1919S
1919-Secondary
032321 1919S
1919-Secondary
032321 1919S
1919-Secondary
032321 1919S
1919-Secondary
032390 t97cf065f 1919S
1919-Secondary
032390 1919S
1919-Secondary
032390 1919S
1919-Secondary
032390 1919S
1919-Secondary
032391 1919S
1919-Secondary
032391 1919S
1919-Secondary
032392 t97cf565f 1919S
1919-Secondary
032392 1919S
1919-Secondary
032666 24-7702 1919S
1919-Secondary
032666 1919S
1919-Secondary
032666 1919S
1919-Secondary
032666 1919S
1919-Secondary
032666 1919S
1919-Secondary

Page 1

Thomas Wojewoda


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Shirley Graver
Sent: Wednesday, August 17, 2005 11:28 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Simple RB question

Do your sorts match up with your groups?

shirley



********************
This transmission may contain information that is privileged,
confidential and/or exempt from disclosure under applicable law. If you
are not the intended recipient, you are hereby notified that any
disclosure, copying, distribution, or use of the information contained
herein (including any reliance thereon) is STRICTLY PROHIBITED. If you
received this transmission in error, please immediately contact the
sender and destroy the material in its entirety, whether in electronic
or hard copy format. Thank you.







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
Yahoo! Groups Links
That GROUP LINR function rings a bell I just can't remember where the
function is.

Thomas Wojewoda


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of pjw@...
Sent: Wednesday, August 17, 2005 10:38 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Simple RB question

Sort And Group on Job Number, add Group line for Job number, add data
fields
you want to display, turn off printing of record row.


Patrick Winter

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of
Thomas Wojewoda
Sent: Wednesday, August 17, 2005 10:26 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Simple RB question

How do I get rid of repetitions?
What I mean is, I've made a report for active parts in a list of job
costing
departments by pulling them from the LaborDTL and JobHead tables. The
report
comes out fine, but every part (job) lists more than once in the report,
since it has more than one operation done in that department. How do I
filter the results so it shows me the part (job) number only once?

Thomas Wojewoda
IS Manager
Principal Manufacturing Corp.
2800 South 19th Ave
60155 Broadview IL
phone: (708) 865 7500 ext 544
fax: (708) 865 7632
cell: (708) 259 4864
http://www.principalmfg.com



********************
This transmission may contain information that is privileged,
confidential
and/or exempt from disclosure under applicable law. If you are not the
intended recipient, you are hereby notified that any disclosure,
copying,
distribution, or use of the information contained herein (including any
reliance thereon) is STRICTLY PROHIBITED. If you received this
transmission
in error, please immediately contact the sender and destroy the material
in
its entirety, whether in electronic or hard copy format. Thank you.





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



------------------------ Yahoo! Groups Sponsor --------------------~-->
<font face=arial size=-1><a
href="http://us.ard.yahoo.com/SIG=12hmlmmsj/M=362329.6886308.7839368.151
0227
/D=groups/S=1705007183:TM/Y=YAHOO/EXP=1124299524/A=2894321/R=0/SIG=11dvs
fulr
/*http://youthnoise.com/page.php?page_id=1992
">Fair play? Video games influencing politics. Click and talk
back!</a>.</font>
--------------------------------------------------------------------~->

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
Yahoo! Groups Links









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
Yahoo! Groups Links
Any chance the Job Assembly table is somehow involved? Messes me up every time with I don't filter for level zero when getting job costs. End up with one job for each assembly level. I see the number of "repeats" are variable as if different number of assembly levels on the jobs.
-Todd C.

-----Original Message-----
From: Thomas Wojewoda [mailto:twojewoda@...]
Sent: Wednesday, August 17, 2005 11:33 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Simple RB question


It looks like this:

JobHead
Printed: 08/17/05 11:30


JobNum PartNum JCDept Description
031632R MM52118-01 1919S
1919-Secondary
031632R 1919S
1919-Secondary
031665 fr60217-00 1919S
1919-Secondary
031665 1919S
1919-Secondary
031758-1 7260087-1 1919S
1919-Secondary
031758-1 1919S
1919-Secondary
032045 45042 1919S
1919-Secondary
032045 1919S
1919-Secondary
032045 1919S
1919-Secondary
032045 1919S
1919-Secondary
032045 1919S
1919-Secondary
032045 1919S
1919-Secondary
032045 1919S
1919-Secondary
032045 1919S
1919-Secondary
032045 1919S
1919-Secondary
032045 1919S
1919-Secondary
032045 1919S
1919-Secondary
032045 1919S
1919-Secondary
032045 1919S
1919-Secondary
032145R3 T97CJ071E 1919S
1919-Secondary
032145R3 1919S
1919-Secondary
032145R3 1919S
1919-Secondary
032145R3 1919S
1919-Secondary
032145R3 1919S
1919-Secondary
032145R3 1919S
1919-Secondary
032145R3 1919S
1919-Secondary
032206R D75-98312-6U 1919S
1919-Secondary
032248 5001718 1919S
1919-Secondary
032312R C65-11332-6U 1919S
1919-Secondary
032312R 1919S
1919-Secondary
032321 319695 1919S
1919-Secondary
032321 1919S
1919-Secondary
032321 1919S
1919-Secondary
032321 1919S
1919-Secondary
032321 1919S
1919-Secondary
032321 1919S
1919-Secondary
032321 1919S
1919-Secondary
032321 1919S
1919-Secondary
032321 1919S
1919-Secondary
032321 1919S
1919-Secondary
032390 t97cf065f 1919S
1919-Secondary
032390 1919S
1919-Secondary
032390 1919S
1919-Secondary
032390 1919S
1919-Secondary
032391 1919S
1919-Secondary
032391 1919S
1919-Secondary
032392 t97cf565f 1919S
1919-Secondary
032392 1919S
1919-Secondary
032666 24-7702 1919S
1919-Secondary
032666 1919S
1919-Secondary
032666 1919S
1919-Secondary
032666 1919S
1919-Secondary
032666 1919S
1919-Secondary

Page 1

Thomas Wojewoda


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Shirley Graver
Sent: Wednesday, August 17, 2005 11:28 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Simple RB question

Do your sorts match up with your groups?

shirley



********************
This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you.





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



_____

YAHOO! GROUPS LINKS



* Visit your group " vantage <http://groups.yahoo.com/group/vantage> " on the web.


* 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 Service <http://docs.yahoo.com/info/terms/> .


_____




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