# Report Builder Help
**Category:** [Yahoo Archive](https://www.epiusers.help/c/yahoo-archive/9)
**Created:** 2000-07-31 13:08 UTC
**Views:** 2393
**Replies:** 31
**URL:** https://www.epiusers.help/t/report-builder-help/625
---
## Post #1 by @system
I am creating a report that would list all our shop floor employees (Table:
Empbasic). I want the employee ID, the employee name and supervisors name.
The problem is that the supervisor is specified by their employeeID not
their name. Is there a function I can use to look-up the name of the
supervisor and print it on my reports?
Martin Nijdam (Jr. Ing.)
Suss Woodcraft Int'l
(514) 363-3565
---
## Post #2 by @system
Martin,
Join the EmpBasic table to itself - you will need to create an
alias for the second instance of the table (EmpBasic2). Join on
EmpBasic.Company - EmpBasic2.Company; EmpBasic.SupervisorID -
EmpBasic2.EmpID. The join will be left outer.
have fun,
John
> -----Original Message-----
> From: Martin Nijdam [mailto:martinn@...]
> Sent: Monday, July 31, 2000 10:06 AM
> To: 'vantage@egroups.com'
> Subject: [Vantage] Report Builder Help
I've got a bit of a pickle you could help me with. I'm fine tuning my labor
exception report.
My evening shift ends at midnight (00:00). I want to print a message "out
late" if they the personnel punch after midnight (ex: 00:15). I want to
print "out early" if the personnel punch before midnight (ex: 23:34).
Any idea how I could write the report builder calculated field?
Martin Nijdam (Jr. Ing.)
Suss Woodcraft Int'l
(514) 363-3565
---
## Post #4 by @system
Hi Martin,
Give this a try...Use the IIF statement with your function. It should
go something like this.
IIF(ClockOutTime > 0000, "Out Late", IIF(ClockOutTime < 0000, "Out
Early", "Out At Midnight"))
The statement says If ClockOutTime is past 00:00, "Out Late" will
print. If the first part is false, the statement tests to see if
ClockOutTime is < 00:00. If that is true, "Out Early" will print. If
both tests of the ClockOutTime are false, it must be 00:00, and "Out
At Midnight" will print.
Erik Smalley
IT Manager
Milford Enterprises Inc.
---
## Post #5 by @system
Unfortunatly your statement does not work as both 00.50 (half past midnight)
and 23.50 ( 11:30 PM) are bigger then 0000. Your statement will always print
"Out Late" (unless they punched out exactly at midnight).
The problem in my opinion is that vantage does not have a ClockOutDate field
in the LaborHed table. I really think there is no solution to my problem
unless someone can prove me wrong!!!
Martin Nijdam (Jr. Ing.)
Suss Woodcraft Int'l
(514) 363-3565
> -----Original Message-----
> From: E. Smalley [SMTP:esmalley@...]
> Sent: Tuesday, November 14, 2000 5:06 PM
> To: vantage@egroups.com
> Subject: [Vantage] Re: Report Builder Help
>
> Hi Martin,
>
> Give this a try...Use the IIF statement with your function. It should
> go something like this.
>
> IIF(ClockOutTime > 0000, "Out Late", IIF(ClockOutTime < 0000, "Out
> Early", "Out At Midnight"))
>
> The statement says If ClockOutTime is past 00:00, "Out Late" will
> print. If the first part is false, the statement tests to see if
> ClockOutTime is < 00:00. If that is true, "Out Early" will print. If
> both tests of the ClockOutTime are false, it must be 00:00, and "Out
> At Midnight" will print.
>
> Erik Smalley
> IT Manager
> Milford Enterprises Inc.
>
Martin Try playing around with this statement if the clock out time is less
than the clock in time I added a day to the date..Hope it helps....I use
reportbuilder to export all time and date for employee to import into my
payroll program. I had the same problem with night shift.
If this string is not enough I could send you the whole report file,
iif (ClockOutTime<ClockInTime,string(day(ClockInDate) + 1,"99")
,string(day(ClockInDate),"99"))
> -----Original Message-----
> From: Martin Nijdam [SMTP:martinn@...]
> Sent: Wednesday, November 15, 2000 8:26 AM
> To: 'vantage@egroups.com'
> Subject: RE: [Vantage] Re: Report Builder Help
>
> Unfortunatly your statement does not work as both 00.50 (half past
> midnight)
> and 23.50 ( 11:30 PM) are bigger then 0000. Your statement will always
> print
> "Out Late" (unless they punched out exactly at midnight).
>
> The problem in my opinion is that vantage does not have a ClockOutDate
> field
> in the LaborHed table. I really think there is no solution to my problem
> unless someone can prove me wrong!!!
>
> Martin Nijdam (Jr. Ing.)
> Suss Woodcraft Int'l
> (514) 363-3565
>
> > -----Original Message-----
> > From: E. Smalley [SMTP:esmalley@...]
> > Sent: Tuesday, November 14, 2000 5:06 PM
> > To: vantage@egroups.com
> > Subject: [Vantage] Re: Report Builder Help
> >
> > Hi Martin,
> >
> > Give this a try...Use the IIF statement with your function. It should
> > go something like this.
> >
> > IIF(ClockOutTime > 0000, "Out Late", IIF(ClockOutTime < 0000, "Out
> > Early", "Out At Midnight"))
> >
> > The statement says If ClockOutTime is past 00:00, "Out Late" will
> > print. If the first part is false, the statement tests to see if
> > ClockOutTime is < 00:00. If that is true, "Out Early" will print. If
> > both tests of the ClockOutTime are false, it must be 00:00, and "Out
> > At Midnight" will print.
> >
> > Erik Smalley
> > IT Manager
> > Milford Enterprises Inc.
> >
>
>
> We no longer allow attachments to files. To access/share Report Files,
> please go to the following link: http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you try it, go
> to www.egroups.com, login and be sure to save your password, choose My
> Groups, choose Vantage, then choose Files. If you save the password, the
> link above will work the next time you try it.)
What about changing the equation to where if the "out early" is a range of
beginning for the shift to the minute before the end of shift and doing the
same for "out late" like below.
IIF(ClockOutTime > 00:01 < 16:00, "Out Late", IIF(ClockOutTime < 23:59 <
16:00, "Out
Early", "Out At Midnight"))
Just a thought.
Jim Frice
> -----Original Message-----
> From: Martin Nijdam [mailto:martinn@...]
> Sent: Tuesday, November 14, 2000 4:26 PM
> To: 'vantage@egroups.com'
> Subject: RE: [Vantage] Re: Report Builder Help
>
>
> Unfortunatly your statement does not work as both 00.50 (half
> past midnight)
> and 23.50 ( 11:30 PM) are bigger then 0000. Your statement will
> always print
> "Out Late" (unless they punched out exactly at midnight).
>
> The problem in my opinion is that vantage does not have a
> ClockOutDate field
> in the LaborHed table. I really think there is no solution to my problem
> unless someone can prove me wrong!!!
>
> Martin Nijdam (Jr. Ing.)
> Suss Woodcraft Int'l
> (514) 363-3565
>
> > -----Original Message-----
> > From: E. Smalley [SMTP:esmalley@...]
> > Sent: Tuesday, November 14, 2000 5:06 PM
> > To: vantage@egroups.com
> > Subject: [Vantage] Re: Report Builder Help
> >
> > Hi Martin,
> >
> > Give this a try...Use the IIF statement with your function. It should
> > go something like this.
> >
> > IIF(ClockOutTime > 0000, "Out Late", IIF(ClockOutTime < 0000, "Out
> > Early", "Out At Midnight"))
> >
> > The statement says If ClockOutTime is past 00:00, "Out Late" will
> > print. If the first part is false, the statement tests to see if
> > ClockOutTime is < 00:00. If that is true, "Out Early" will print. If
> > both tests of the ClockOutTime are false, it must be 00:00, and "Out
> > At Midnight" will print.
> >
> > Erik Smalley
> > IT Manager
> > Milford Enterprises Inc.
> >
>
>
> We no longer allow attachments to files. To access/share Report
> Files, please go to the following link:
http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)
I would like to extract the Customer Name out of the description field in
the gljrndtl table. The description for every invoice that hits the sales
account starts with the invoice number then a space and then the Customer
Name. (ie.."IV:00634 THE MILWAUKEE BUCKS). I do this with a replace
function in Lotus but I'm not sure how to do it in RB.
---
## Post #9 by @system
substring(Description,9,10)
9 tells it which character to begin with and 10 says how many characters you
want of it.
You would get The Milwau
Adapt the 10 to how many you need in order to tell one Customer from
another. Only problem is if you deal with a customer and they have multiple
Sold To's and you also need to know the difference.
-----Original Message-----
From: Ed Zywiec [SMTP:
ed.zywiec@...]
Sent: Tuesday, May 22, 2001 4:34 PM
To: '
vantage@yahoogroups.com'
Subject: [Vantage] Report Builder Help
I would like to extract the Customer Name out of the description
field in
the gljrndtl table. The description for every invoice that hits the
sales
account starts with the invoice number then a space and then the
Customer
Name. (ie.."IV:00634 THE MILWAUKEE BUCKS). I do this with a
replace
function in Lotus but I'm not sure how to do it in RB.
To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/Hi,
I know how to get the report Filter into the Title of a report. How do I
get just a part of that expression.
If you create a variable "ReportFilter" using the function "REPORT-FILTER()"
it returns:
"Include all records where JobNum is equal to 007661-5-1" I want to put
just the 007661-5-1 or whatever it happens to be on the report.
If I put "SUBSTRING(REPORT-FILTER(),45,10)" I get a Syntax Error
If I define "rptFilter" to be "REPORT-FILTER()" and put
"SUBSTRING(rptFilter,45,10)" I get the error "REPORT-FILTER() used
indirectly"
Thanks
Dave Cole
Reeder & Kline
[Non-text portions of this message have been removed]
---
## Post #11 by @system
---
## Post #12 by @system
Todd,
Thanks a lot!! Passing it through an aggregate function fixed the problem.
Dave Cole
Reeder & Kline
-----Original Message-----
From: Todd Caughey [mailto:
caugheyt@...]
Sent: Monday, September 23, 2002 11:09 AM
To: '
vantage@yahoogroups.com'
Subject: RE: [Vantage] Report Builder Help
Run the report filter thru an aggregate funciton (such as minimum) and use
the result in the substring.
-Todd C.
-----Original Message-----
From: Cole, Dave [mailto:
dave@...]
Sent: Monday, September 23, 2002 11:07 AM
To: eManfacturing Yahoo Groups (
Vantage@...)
Subject: [Vantage] Report Builder Help
Hi,
I know how to get the report Filter into the Title of a report. How do I
get just a part of that expression.
If you create a variable "ReportFilter" using the function "REPORT-FILTER()"
it returns:
"Include all records where JobNum is equal to 007661-5-1" I want to put
just the 007661-5-1 or whatever it happens to be on the report.
If I put "SUBSTRING(REPORT-FILTER(),45,10)" I get a Syntax Error
If I define "rptFilter" to be "REPORT-FILTER()" and put
"SUBSTRING(rptFilter,45,10)" I get the error "REPORT-FILTER() used
indirectly"
Thanks
Dave Cole
Reeder & Kline
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
<
http://rd.yahoo.com/M=229441.2397090.3822005.1261774/D=egroupweb/S=17050071
<
http://rd.yahoo.com/M=229441.2397090.3822005.1261774/D=egroupweb/S=17050071
>
83:HM/A=1189558/R=0/*
http://www.bmgmusic.com/acq/ee/q6/enroll/mhn/9/
<
http://www.bmgmusic.com/acq/ee/q6/enroll/mhn/9/> >
<
http://us.adserver.yahoo.com/l?M=229441.2397090.3822005.1261774/D=egroupmai
<
http://us.adserver.yahoo.com/l?M=229441.2397090.3822005.1261774/D=egroupmai
>
l/S=:HM/A=1189558/rand=199555454>
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/.
<
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>
<
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>
<
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/ <
http://docs.yahoo.com/info/terms/> > .
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
<
http://rd.yahoo.com/M=229441.2397090.3822005.1261774/D=egroupweb/S=17050071
83:HM/A=1189560/R=0/*
http://www.bmgmusic.com/acq/ee/q6/enroll/mhn/10/>
<
http://us.adserver.yahoo.com/l?M=229441.2397090.3822005.1261774/D=egroupmai
l/S=:HM/A=1189560/rand=496140607>
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]
I need to create a job report that will sort by the people, or the
person list in the job header. The job needs to show under each
person. So some jobs will be listed under one person and then again
under another person. I did a calculation to look for matches on the
personlist field, but once it finds the first match in the
calculation it doesn't look any more. I'm using the personlist in the
job header, should I use something else or should I do a different
calculation.
Any help would be greatly appreciated.
Thanks,
Helen
Niven Marketing
---
## Post #14 by @system
Start with the Person table as the master then left outter to jobs check
with an 'IF Statement' to see if the person is in the jobhead.person
delimited list. Works like sales rep report provided on the epicor site.
Will be slow to run but should work.
Patrick Winter
-----Original Message-----
From: hebarna [mailto:
hbarna@...]
Sent: Wednesday, July 30, 2003 10:22 AM
To:
vantage@yahoogroups.com
Subject: [Vantage] Report Builder Help
I need to create a job report that will sort by the people, or the
person list in the job header. The job needs to show under each
person. So some jobs will be listed under one person and then again
under another person. I did a calculation to look for matches on the
personlist field, but once it finds the first match in the
calculation it doesn't look any more. I'm using the personlist in the
job header, should I use something else or should I do a different
calculation.
Any help would be greatly appreciated.
Thanks,
Helen
Niven Marketing
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/Patrick,
Thanks for your input, I set the report up that way but the job only
appears once under one person. It does not appear under all the
people in the person list.
Any ideas?
Thanks,
Helen
--- In vantage@yahoogroups.com, pjw@s... wrote:
> Start with the Person table as the master then left outter to jobs
check
> with an 'IF Statement' to see if the person is in the jobhead.person
> delimited list. Works like sales rep report provided on the epicor
site.
> Will be slow to run but should work.
>
> Patrick Winter
>
>
> -----Original Message-----
> From: hebarna [mailto:hbarna@p...]
> Sent: Wednesday, July 30, 2003 10:22 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Report Builder Help
>
>
>
> I need to create a job report that will sort by the people, or the
> person list in the job header. The job needs to show under each
> person. So some jobs will be listed under one person and then again
> under another person. I did a calculation to look for matches on
the
> personlist field, but once it finds the first match in the
> calculation it doesn't look any more. I'm using the personlist in
the
> job header, should I use something else or should I do a different
> calculation.
>
> Any help would be greatly appreciated.
>
> Thanks,
>
> Helen
> Niven Marketing
>
>
>
>
> 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/
Helen
My mistake, the IF statement is probably just getting you the first entry in
the string, which gives you just one listing of a job.
Try designing it like the sales rep report on epicors web site. Epicor used
the LOOKUP command so yours would look something like:
LOOKUP(Person.PersonID,JobHead.PersonList,"~~")
The you can conditionally print the line only when there is data.
Patrick Winter
-----Original Message-----
From: hebarna [mailto:
hbarna@...]
Sent: Thursday, July 31, 2003 8:56 AM
To:
vantage@yahoogroups.com
Subject: [Vantage] Re: Report Builder Help
Patrick,
Thanks for your input, I set the report up that way but the job only
appears once under one person. It does not appear under all the
people in the person list.
Any ideas?
Thanks,
Helen
--- In vantage@yahoogroups.com, pjw@s... wrote:
> Start with the Person table as the master then left outter to jobs
check
> with an 'IF Statement' to see if the person is in the jobhead.person
> delimited list. Works like sales rep report provided on the epicor
site.
> Will be slow to run but should work.
>
> Patrick Winter
>
>
> -----Original Message-----
> From: hebarna [mailto:hbarna@p...]
> Sent: Wednesday, July 30, 2003 10:22 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Report Builder Help
>
>
>
> I need to create a job report that will sort by the people, or the
> person list in the job header. The job needs to show under each
> person. So some jobs will be listed under one person and then again
> under another person. I did a calculation to look for matches on
the
> personlist field, but once it finds the first match in the
> calculation it doesn't look any more. I'm using the personlist in
the
> job header, should I use something else or should I do a different
> calculation.
>
> Any help would be greatly appreciated.
>
> Thanks,
>
> Helen
> Niven Marketing
>
>
>
>
> 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/
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/
Patrick,
I did just that, I've been using Epicor's report. I created that
exact lookup statement, then creatd an if statement that says if the
lookup statement = 1 (meaning it found a match) then print the Person
ID. So I'm grouping on that second calculation, with the record being
the job #'s. But, for example, if I have Jon and Ray in the person
list on the job, it only shows the job# under Jon, and not Ray. I
need the job number to show under every person in the list. I'm still
playing around with it, but any suggestions would be helpful.
Thanks,
Helen
--- In vantage@yahoogroups.com, pjw@s... wrote:
> Helen
>
> My mistake, the IF statement is probably just getting you the first
entry in
> the string, which gives you just one listing of a job.
>
> Try designing it like the sales rep report on epicors web site.
Epicor used
> the LOOKUP command so yours would look something like:
>
> LOOKUP(Person.PersonID,JobHead.PersonList,"~~")
>
> The you can conditionally print the line only when there is data.
>
> Patrick Winter
>
>
> -----Original Message-----
> From: hebarna [mailto:hbarna@p...]
> Sent: Thursday, July 31, 2003 8:56 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Report Builder Help
>
>
> Patrick,
>
> Thanks for your input, I set the report up that way but the job
only
> appears once under one person. It does not appear under all the
> people in the person list.
>
> Any ideas?
>
> Thanks,
>
> Helen
>
> --- In vantage@yahoogroups.com, pjw@s... wrote:
> > Start with the Person table as the master then left outter to jobs
> check
> > with an 'IF Statement' to see if the person is in the
jobhead.person
> > delimited list. Works like sales rep report provided on the epicor
> site.
> > Will be slow to run but should work.
> >
> > Patrick Winter
> >
> >
> > -----Original Message-----
> > From: hebarna [mailto:hbarna@p...]
> > Sent: Wednesday, July 30, 2003 10:22 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Report Builder Help
> >
> >
> >
> > I need to create a job report that will sort by the people, or the
> > person list in the job header. The job needs to show under each
> > person. So some jobs will be listed under one person and then
again
> > under another person. I did a calculation to look for matches on
> the
> > personlist field, but once it finds the first match in the
> > calculation it doesn't look any more. I'm using the personlist in
> the
> > job header, should I use something else or should I do a different
> > calculation.
> >
> > Any help would be greatly appreciated.
> >
> > Thanks,
> >
> > Helen
> > Niven Marketing
> >
> >
> >
> >
> > 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/
>
>
>
> 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/
Patrick,
I wasn't paying attention, I thought that that the result of the
lookup function (1) meant true, but it is returning the position of
what you are looking for. So I changed the if statement to say if it
dosen't equal zero to use the person id, (which it how the Epicor
report works). Now it shows the jobs under each person.
Thanks for your help.
Helen
--- In vantage@yahoogroups.com, "hebarna" <hbarna@p...> wrote:
> Patrick,
>
> I did just that, I've been using Epicor's report. I created that
> exact lookup statement, then creatd an if statement that says if
the
> lookup statement = 1 (meaning it found a match) then print the
Person
> ID. So I'm grouping on that second calculation, with the record
being
> the job #'s. But, for example, if I have Jon and Ray in the person
> list on the job, it only shows the job# under Jon, and not Ray. I
> need the job number to show under every person in the list. I'm
still
> playing around with it, but any suggestions would be helpful.
>
> Thanks,
>
> Helen
>
>
> --- In vantage@yahoogroups.com, pjw@s... wrote:
> > Helen
> >
> > My mistake, the IF statement is probably just getting you the
first
> entry in
> > the string, which gives you just one listing of a job.
> >
>
> > Try designing it like the sales rep report on epicors web site.
> Epicor used
> > the LOOKUP command so yours would look something like:
> >
> > LOOKUP(Person.PersonID,JobHead.PersonList,"~~")
> >
> > The you can conditionally print the line only when there is data.
> >
> > Patrick Winter
> >
> >
> > -----Original Message-----
> > From: hebarna [mailto:hbarna@p...]
> > Sent: Thursday, July 31, 2003 8:56 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re: Report Builder Help
> >
> >
> > Patrick,
> >
> > Thanks for your input, I set the report up that way but the job
> only
> > appears once under one person. It does not appear under all the
> > people in the person list.
> >
> > Any ideas?
> >
> > Thanks,
> >
> > Helen
> >
> > --- In vantage@yahoogroups.com, pjw@s... wrote:
> > > Start with the Person table as the master then left outter to
jobs
> > check
> > > with an 'IF Statement' to see if the person is in the
> jobhead.person
> > > delimited list. Works like sales rep report provided on the
epicor
> > site.
> > > Will be slow to run but should work.
> > >
> > > Patrick Winter
> > >
> > >
> > > -----Original Message-----
> > > From: hebarna [mailto:hbarna@p...]
> > > Sent: Wednesday, July 30, 2003 10:22 AM
> > > To: vantage@yahoogroups.com
> > > Subject: [Vantage] Report Builder Help
> > >
> > >
> > >
> > > I need to create a job report that will sort by the people, or
the
> > > person list in the job header. The job needs to show under each
> > > person. So some jobs will be listed under one person and then
> again
> > > under another person. I did a calculation to look for matches
on
> > the
> > > personlist field, but once it finds the first match in the
> > > calculation it doesn't look any more. I'm using the personlist
in
> > the
> > > job header, should I use something else or should I do a
different
> > > calculation.
> > >
> > > Any help would be greatly appreciated.
> > >
> > > Thanks,
> > >
> > > Helen
> > > Niven Marketing
> > >
> > >
> > >
> > >
> > > 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/
> >
> >
> >
> > 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 knew you were close to getting it running.
Patrick
-----Original Message-----
From: hebarna [mailto:
hbarna@...]
Sent: Thursday, July 31, 2003 11:05 AM
To:
vantage@yahoogroups.com
Subject: [Vantage] Re: Report Builder Help
Patrick,
I wasn't paying attention, I thought that that the result of the
lookup function (1) meant true, but it is returning the position of
what you are looking for. So I changed the if statement to say if it
dosen't equal zero to use the person id, (which it how the Epicor
report works). Now it shows the jobs under each person.
Thanks for your help.
Helen
--- In vantage@yahoogroups.com, "hebarna" <hbarna@p...> wrote:
> Patrick,
>
> I did just that, I've been using Epicor's report. I created that
> exact lookup statement, then creatd an if statement that says if
the
> lookup statement = 1 (meaning it found a match) then print the
Person
> ID. So I'm grouping on that second calculation, with the record
being
> the job #'s. But, for example, if I have Jon and Ray in the person
> list on the job, it only shows the job# under Jon, and not Ray. I
> need the job number to show under every person in the list. I'm
still
> playing around with it, but any suggestions would be helpful.
>
> Thanks,
>
> Helen
>
>
> --- In vantage@yahoogroups.com, pjw@s... wrote:
> > Helen
> >
> > My mistake, the IF statement is probably just getting you the
first
> entry in
> > the string, which gives you just one listing of a job.
> >
>
> > Try designing it like the sales rep report on epicors web site.
> Epicor used
> > the LOOKUP command so yours would look something like:
> >
> > LOOKUP(Person.PersonID,JobHead.PersonList,"~~")
> >
> > The you can conditionally print the line only when there is data.
> >
> > Patrick Winter
> >
> >
> > -----Original Message-----
> > From: hebarna [mailto:hbarna@p...]
> > Sent: Thursday, July 31, 2003 8:56 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re: Report Builder Help
> >
> >
> > Patrick,
> >
> > Thanks for your input, I set the report up that way but the job
> only
> > appears once under one person. It does not appear under all the
> > people in the person list.
> >
> > Any ideas?
> >
> > Thanks,
> >
> > Helen
> >
> > --- In vantage@yahoogroups.com, pjw@s... wrote:
> > > Start with the Person table as the master then left outter to
jobs
> > check
> > > with an 'IF Statement' to see if the person is in the
> jobhead.person
> > > delimited list. Works like sales rep report provided on the
epicor
> > site.
> > > Will be slow to run but should work.
> > >
> > > Patrick Winter
> > >
> > >
> > > -----Original Message-----
> > > From: hebarna [mailto:hbarna@p...]
> > > Sent: Wednesday, July 30, 2003 10:22 AM
> > > To: vantage@yahoogroups.com
> > > Subject: [Vantage] Report Builder Help
> > >
> > >
> > >
> > > I need to create a job report that will sort by the people, or
the
> > > person list in the job header. The job needs to show under each
> > > person. So some jobs will be listed under one person and then
> again
> > > under another person. I did a calculation to look for matches
on
> > the
> > > personlist field, but once it finds the first match in the
> > > calculation it doesn't look any more. I'm using the personlist
in
> > the
> > > job header, should I use something else or should I do a
different
> > > calculation.
> > >
> > > Any help would be greatly appreciated.
> > >
> > > Thanks,
> > >
> > > Helen
> > > Niven Marketing
> > >
> > >
> > >
> > >
> > > 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/
> >
> >
> >
> > 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/
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/
LeavesHello,
I am writing a report that shows quoted jobs in a particular time period,
whether the quote was ordered, the order quantity, and unit price. My
problem is the lines are duplicating. If there are two lines in the quote,
each line appears 2 times, if there are 3 lines, each line appears 3 times
and so on. I have tried every approach that I know to get this to stop with
no luck. Any help is appreciated. Also, if any of you have an RB or Crystal
report similar to this, can I please get a copy?
Also, does anyone have a report that shows the quoted set-up and production
hours vs.. actual set-up and production hours?
Thanks,
Karen Brodniak
Accounting Manager
425-742-7011 X44
Fax 425-353-8945
karen.brodniak@...
[Non-text portions of this message have been removed]
sounds like a join issue.
you have to join quote number on the header and the detail tables.
Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...
-----Original Message-----
From: Karen Brodniak [mailto:karen.brodniak@...]
Sent: Monday, November 08, 2004 12:31 PM
To: Vantage Group (E-mail)
Subject: [Vantage] Report Builder Help
LeavesHello,
I am writing a report that shows quoted jobs in a particular time period,
whether the quote was ordered, the order quantity, and unit price. My
problem is the lines are duplicating. If there are two lines in the quote,
each line appears 2 times, if there are 3 lines, each line appears 3 times
and so on. I have tried every approach that I know to get this to stop with
no luck. Any help is appreciated. Also, if any of you have an RB or Crystal
report similar to this, can I please get a copy?
Also, does anyone have a report that shows the quoted set-up and production
hours vs.. actual set-up and production hours?
Thanks,
Karen Brodniak
Accounting Manager
425-742-7011 X44
Fax 425-353-8945
karen.brodniak@...
[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 Sponsor
ADVERTISEMENT
<http://us.ard.yahoo.com/SIG=129riismv/M=294855.5468653.6549235.3001176/D=gr
oups/S=1705007183:HM/EXP=1100021417/A=2376776/R=0/SIG=11ldm1jvc/*http://prom
otions.yahoo.com/ydomains2004/index.html> click here
<http://us.adserver.yahoo.com/l?M=294855.5468653.6549235.3001176/D=groups/S=
:HM/A=2376776/rand=475315483>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* 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/> .
<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and keyboards
This e-mail is from Innovative Office Products, Inc. but expresses the views of the sender and not necessarily the views of the company. The email and any files transmitted with it are confidential to the intended recipient at the e-mail address to which it has been addressed. It may not be disclosed or used by any other than that addressee, nor may it be copied in any way. If received in error, please delete and notify the sender via e-mail or sales@... quoting the name of the sender. Messages sent via this medium may be subject to delays, non-delivery and unauthorized alteration. This e-mail has been prepared using information believed by the author to be reliable and accurate. Unless expressly stated otherwise, this e-mail does not form part of a legally binding contract or agreement between recipient and Innovative Office Products, Inc.
Warning: Although Innovative Office Products, Inc. has taken reasonable precautions to ensure no viruses are present in this email, we cannot accept responsibility for any loss or damage arising from the use of this email or attachments. It is, therefore, your responsibility to scan attachments (if any).
[Non-text portions of this message have been removed]
---
## Post #22 by @system
Thank you for the information. The quote number is joined on the header and
the detail tables. Does it matter which one is the master table?
Karen Brodniak
Accounting Manager
425-742-7011 X44
Fax 425-353-8945
karen.brodniak@...
-----Original Message-----
From: Frank Zeigafuse [mailto:fzeigafuse@...]
Sent: Monday, November 08, 2004 9:48 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report Builder Help
sounds like a join issue.
you have to join quote number on the header and the detail tables.
Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...
-----Original Message-----
From: Karen Brodniak [mailto:karen.brodniak@...]
Sent: Monday, November 08, 2004 12:31 PM
To: Vantage Group (E-mail)
Subject: [Vantage] Report Builder Help
LeavesHello,
I am writing a report that shows quoted jobs in a particular time period,
whether the quote was ordered, the order quantity, and unit price. My
problem is the lines are duplicating. If there are two lines in the quote,
each line appears 2 times, if there are 3 lines, each line appears 3 times
and so on. I have tried every approach that I know to get this to stop
with
no luck. Any help is appreciated. Also, if any of you have an RB or
Crystal
report similar to this, can I please get a copy?
Also, does anyone have a report that shows the quoted set-up and
production
hours vs.. actual set-up and production hours?
Thanks,
Karen Brodniak
Accounting Manager
425-742-7011 X44
Fax 425-353-8945
karen.brodniak@...
[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 Sponsor
ADVERTISEMENT
<http://us.ard.yahoo.com/SIG=129riismv/M=294855.5468653.6549235.3001176/D=gr
oups/S=1705007183:HM/EXP=1100021417/A=2376776/R=0/SIG=11ldm1jvc/*http://prom
otions.yahoo.com/ydomains2004/index.html> click here
<http://us.adserver.yahoo.com/l?M=294855.5468653.6549235.3001176/D=groups/S=
:HM/A=2376776/rand=475315483>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* 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/> .
<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and
keyboards
This e-mail is from Innovative Office Products, Inc. but expresses the
views of the sender and not necessarily the views of the company. The email
and any files transmitted with it are confidential to the intended recipient
at the e-mail address to which it has been addressed. It may not be
disclosed or used by any other than that addressee, nor may it be copied in
any way. If received in error, please delete and notify the sender via
e-mail or sales@... quoting the name of the sender. Messages sent
via this medium may be subject to delays, non-delivery and unauthorized
alteration. This e-mail has been prepared using information believed by the
author to be reliable and accurate. Unless expressly stated otherwise, this
e-mail does not form part of a legally binding contract or agreement between
recipient and Innovative Office Products, Inc.
Warning: Although Innovative Office Products, Inc. has taken reasonable
precautions to ensure no viruses are present in this email, we cannot accept
responsibility for any loss or damage arising from the use of this email or
attachments. It is, therefore, your responsibility to scan attachments (if
any).
[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 Sponsor
ADVERTISEMENT
----------------------------------------------------------------------------
--
Yahoo! Groups Links
a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
---
## Post #23 by @system
I am not sure I do not have much experience with rb I use crystal. sorry.
Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...
-----Original Message-----
From: Karen Brodniak [mailto:karen.brodniak@...]
Sent: Monday, November 08, 2004 1:54 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report Builder Help
Thank you for the information. The quote number is joined on the header and
the detail tables. Does it matter which one is the master table?
Karen Brodniak
Accounting Manager
425-742-7011 X44
Fax 425-353-8945
karen.brodniak@...
-----Original Message-----
From: Frank Zeigafuse [mailto:fzeigafuse@...]
Sent: Monday, November 08, 2004 9:48 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report Builder Help
sounds like a join issue.
you have to join quote number on the header and the detail tables.
Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...
-----Original Message-----
From: Karen Brodniak [mailto:karen.brodniak@...]
Sent: Monday, November 08, 2004 12:31 PM
To: Vantage Group (E-mail)
Subject: [Vantage] Report Builder Help
LeavesHello,
I am writing a report that shows quoted jobs in a particular time period,
whether the quote was ordered, the order quantity, and unit price. My
problem is the lines are duplicating. If there are two lines in the quote,
each line appears 2 times, if there are 3 lines, each line appears 3 times
and so on. I have tried every approach that I know to get this to stop
with
no luck. Any help is appreciated. Also, if any of you have an RB or
Crystal
report similar to this, can I please get a copy?
Also, does anyone have a report that shows the quoted set-up and
production
hours vs.. actual set-up and production hours?
Thanks,
Karen Brodniak
Accounting Manager
425-742-7011 X44
Fax 425-353-8945
karen.brodniak@...
[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 Sponsor
ADVERTISEMENT
<http://us.ard.yahoo.com/SIG=129riismv/M=294855.5468653.6549235.3001176/D=gr
oups/S=1705007183:HM/EXP=1100021417/A=2376776/R=0/SIG=11ldm1jvc/*http://prom
otions.yahoo.com/ydomains2004/index.html> click here
<http://us.adserver.yahoo.com/l?M=294855.5468653.6549235.3001176/D=groups/S=
:HM/A=2376776/rand=475315483>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* 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/> .
<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and
keyboards
This e-mail is from Innovative Office Products, Inc. but expresses the
views of the sender and not necessarily the views of the company. The email
and any files transmitted with it are confidential to the intended recipient
at the e-mail address to which it has been addressed. It may not be
disclosed or used by any other than that addressee, nor may it be copied in
any way. If received in error, please delete and notify the sender via
e-mail or sales@... quoting the name of the sender. Messages sent
via this medium may be subject to delays, non-delivery and unauthorized
alteration. This e-mail has been prepared using information believed by the
author to be reliable and accurate. Unless expressly stated otherwise, this
e-mail does not form part of a legally binding contract or agreement between
recipient and Innovative Office Products, Inc.
Warning: Although Innovative Office Products, Inc. has taken reasonable
precautions to ensure no viruses are present in this email, we cannot accept
responsibility for any loss or damage arising from the use of this email or
attachments. It is, therefore, your responsibility to scan attachments (if
any).
[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 Sponsor
ADVERTISEMENT
----------------------------------------------------------------------------
--
Yahoo! Groups Links
a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[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 Sponsor
ADVERTISEMENT
<http://us.ard.yahoo.com/SIG=12905pubq/M=295196.4901138.6071305.3001176/D=gr
oups/S=1705007183:HM/EXP=1100026378/A=2128215/R=0/SIG=10se96mf6/*http://comp
anion.yahoo.com> click here
<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=
:HM/A=2128215/rand=500626349>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* 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/> .
<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and keyboards
This e-mail is from Innovative Office Products, Inc. but expresses the views of the sender and not necessarily the views of the company. The email and any files transmitted with it are confidential to the intended recipient at the e-mail address to which it has been addressed. It may not be disclosed or used by any other than that addressee, nor may it be copied in any way. If received in error, please delete and notify the sender via e-mail or sales@... quoting the name of the sender. Messages sent via this medium may be subject to delays, non-delivery and unauthorized alteration. This e-mail has been prepared using information believed by the author to be reliable and accurate. Unless expressly stated otherwise, this e-mail does not form part of a legally binding contract or agreement between recipient and Innovative Office Products, Inc.
Warning: Although Innovative Office Products, Inc. has taken reasonable precautions to ensure no viruses are present in this email, we cannot accept responsibility for any loss or damage arising from the use of this email or attachments. It is, therefore, your responsibility to scan attachments (if any).
[Non-text portions of this message have been removed]
---
## Post #24 by @system
It does sound like a join issue. What are your joins? Do any of your lines
have more than on quantity break listed?
---
## Post #25 by @system
---
## Post #26 by @system
Thanks to all of you who responded. Shirley, I tried re-sorting and
re-grouping and almost have it. I have a couple of jobs that are still
repeating lines but others aren't. I am looking at those jobs now to figure
out why only those jobs are duplicating lines. Thanks again for all your
help.
Karen Brodniak
Accounting Manager
425-742-7011 X44
Fax 425-353-8945
karen.brodniak@...
-----Original Message-----
From: Shirley Graver [mailto:
shirleyg@...]
Sent: Monday, November 08, 2004 11:59 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Report Builder Help
Sarah,
You aren't going to resolve your issue with joins. The issue
is that you have multiple records that have one un-displayed difference
between them. The simplest way to correct is to set an upper level group.
For example: If each of your quote lines has multiple quantities then
that
is what is kicking out the multiple lines. Try sorting and grouping your
quote line items. If you need help with grouping your items let me know.
Shirley Graver
Rubber Associates inc
_____
From:
sarah.vareschi@... [mailto:
sarah.vareschi@...]
Sent: Monday, November 08, 2004 2:52 PM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Report Builder Help
It does sound like a join issue. What are your joins? Do any of your
lines
have more than on quantity break listed?
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 Sponsor
ADVERTISEMENT
<
http://us.ard.yahoo.com/SIG=129m37e2a/M=294855.5468653.6549235.3001176/D=gr
oups/S=1705007183:HM/EXP=1100029583/A=2376776/R=0/SIG=11ldm1jvc/*http:/promo
tions.yahoo.com/ydomains2004/index.html> click here
<
http://us.adserver.yahoo.com/l?M=294855.5468653.6549235.3001176/D=groups/S=
:HM/A=2376776/rand=564166919>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* 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 #: 9B31ECE5E915894AA8EBF39F2ED4528BB1BFD32B
[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 Sponsor
Get unlimited calls to
U.S./Canada
----------------------------------------------------------------------------
--
Yahoo! Groups Links
a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
Karen,
Feel free to email your report to me if you get frustrated.
They can be really knotty (naughty) :-)~ some times.
Shirley
_____
From: Karen Brodniak [mailto:
karen.brodniak@...]
Sent: Tuesday, November 09, 2004 2:21 PM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Report Builder Help
Thanks to all of you who responded. Shirley, I tried re-sorting and
re-grouping and almost have it. I have a couple of jobs that are still
repeating lines but others aren't. I am looking at those jobs now to figure
out why only those jobs are duplicating lines. Thanks again for all your
help.
Karen Brodniak
Accounting Manager
425-742-7011 X44
Fax 425-353-8945
karen.brodniak@...
-----Original Message-----
From: Shirley Graver [mailto:
shirleyg@...]
Sent: Monday, November 08, 2004 11:59 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Report Builder Help
Sarah,
You aren't going to resolve your issue with joins. The issue
is that you have multiple records that have one un-displayed difference
between them. The simplest way to correct is to set an upper level group.
For example: If each of your quote lines has multiple quantities then
that
is what is kicking out the multiple lines. Try sorting and grouping your
quote line items. If you need help with grouping your items let me know.
Shirley Graver
Rubber Associates inc
_____
From:
sarah.vareschi@... [mailto:
sarah.vareschi@...]
Sent: Monday, November 08, 2004 2:52 PM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Report Builder Help
It does sound like a join issue. What are your joins? Do any of your
lines
have more than on quantity break listed?
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
Yahoo! Groups Sponsor
ADVERTISEMENT
<
http://us.ard.yahoo.com/SIG=129m37e2a/M=294855.5468653.6549235.3001176/D=gr
oups/S=1705007183:HM/EXP=1100029583/A=2376776/R=0/SIG=11ldm1jvc/*http:/promo
tions.yahoo.com/ydomains2004/index.html> click here
<
http://us.adserver.yahoo.com/l?M=294855.5468653.6549235.3001176/D=groups/S=
:HM/A=2376776/rand=564166919>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* 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 #: 9B31ECE5E915894AA8EBF39F2ED4528BB1BFD32B
[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 Sponsor
Get unlimited calls to
U.S./Canada
----------------------------------------------------------------------------
--
Yahoo! Groups Links
a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[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 Sponsor
ADVERTISEMENT
<
http://us.ard.yahoo.com/SIG=129v92oou/M=294855.5468653.6549235.3001176/D=gr
oups/S=1705007183:HM/EXP=1100114401/A=2376776/R=0/SIG=11ldm1jvc/*http:/promo
tions.yahoo.com/ydomains2004/index.html> click here
<
http://us.adserver.yahoo.com/l?M=294855.5468653.6549235.3001176/D=groups/S=
:HM/A=2376776/rand=657588262>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* 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]
Can anyone tell me if I can create a field in a report that will
calculate the following information?
(ScrapLaborCost+ScrapBurdenCost+ScrapMaterialCost)*Quantity
I have tried using "Help" but am not getting anywhere fast. I need
lay terms. I know how to calculate this in Excel but can't get Report
Builder to do it.
OR....
Does anyone have a report on Non-Conformances that would include
Machine ID, total costs, employee, date, reason, etc? My boss would
like a report so he can monitor scrap counts and dollars by machine
and employee and since I am the only one in the company that knows "a
little" about report builder, I was given the task of coming up with a
report. Lucky me!!
Any help would be greatly appreciated!!!!
---
## Post #29 by @system
To create this in report builder - go to 'Calculations' -> 'Calculated
field' -> 'New"
Under Name - enter the name that you want it to be called, i.e.
"TotalScrapCost"
In expression, enter the calculation using field names: (ScrapLaborCost +
ScrapBurdenCost + ScrapMaterialCost + ScrapMaterialBurCost) * Quantity
-----Original Message-----
From:
vantage@yahoogroups.com [mailto:
vantage@yahoogroups.com] On Behalf Of
Nancy Metcalf
Sent: Wednesday, September 21, 2005 12:25 PM
To:
vantage@yahoogroups.com
Subject: [Vantage] Report Builder Help
Can anyone tell me if I can create a field in a report that will
calculate the following information?
(ScrapLaborCost+ScrapBurdenCost+ScrapMaterialCost)*Quantity
I have tried using "Help" but am not getting anywhere fast. I need
lay terms. I know how to calculate this in Excel but can't get Report
Builder to do it.
OR....
Does anyone have a report on Non-Conformances that would include
Machine ID, total costs, employee, date, reason, etc? My boss would
like a report so he can monitor scrap counts and dollars by machine
and employee and since I am the only one in the company that knows "a
little" about report builder, I was given the task of coming up with a
report. Lucky me!!
Any help would be greatly appreciated!!!!
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
To add to sarahs reply, a beginner should use the TOOLBAR for
entering in operators. For example 4+4 will fail while 4 + 4 will
work just fine. User the VERIFY button after you think you've
finished. Work your formual a piece at time IE: for (((a + b) *
c) / d) build your formula (a + b) then VERIFY then ((a + b) * c)
then VERIFY then (((a + b) * c) / d) then VERIFY. That way when it
fails you know which pieces are good and which pieces are bad.
Shirley
--- In vantage@yahoogroups.com, sarah.vareschi@n... wrote:
> To create this in report builder - go to 'Calculations' -
> 'Calculated
> field' -> 'New"
>
> Under Name - enter the name that you want it to be called, i.e.
> "TotalScrapCost"
>
> In expression, enter the calculation using field names:
(ScrapLaborCost +
> ScrapBurdenCost + ScrapMaterialCost + ScrapMaterialBurCost) *
Quantity
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> Nancy Metcalf
> Sent: Wednesday, September 21, 2005 12:25 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Report Builder Help
>
> Can anyone tell me if I can create a field in a report that will
> calculate the following information?
>
> (ScrapLaborCost+ScrapBurdenCost+ScrapMaterialCost)*Quantity
>
> I have tried using "Help" but am not getting anywhere fast. I need
> lay terms. I know how to calculate this in Excel but can't get
Report
> Builder to do it.
>
> OR....
>
> Does anyone have a report on Non-Conformances that would include
> Machine ID, total costs, employee, date, reason, etc? My boss
would
> like a report so he can monitor scrap counts and dollars by machine
> and employee and since I am the only one in the company that
knows "a
> little" about report builder, I was given the task of coming up
with a
> report. Lucky me!!
>
> Any help would be greatly appreciated!!!!
>
>
>
>
>
> 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
THANK YOU! THANK YOU! THANK YOU!
The only thing I was doing wrong was leaving the spaces in.
Now that I have that field in place, how can I get the report to
give me a total cost for each individual machine ID? I am wanting
the report sorted/grouped by machine ID, each line having a cost and
then each machine having a total scrap cost.
Any help there??
--- In
vantage@yahoogroups.com, "Shirley Graver" <shirleyg@R...>
wrote:
> To add to sarahs reply, a beginner should use the TOOLBAR for
> entering in operators. For example 4+4 will fail while 4 + 4
will
> work just fine. User the VERIFY button after you think you've
> finished. Work your formual a piece at time IE: for (((a + b) *
> c) / d) build your formula (a + b) then VERIFY then ((a + b) *
c)
> then VERIFY then (((a + b) * c) / d) then VERIFY. That way when
it
> fails you know which pieces are good and which pieces are bad.
>
> Shirley
>
> --- In vantage@yahoogroups.com, sarah.vareschi@n... wrote:
> > To create this in report builder - go to 'Calculations' -
> > 'Calculated
> > field' -> 'New"
> >
> > Under Name - enter the name that you want it to be called, i.e.
> > "TotalScrapCost"
> >
> > In expression, enter the calculation using field names:
> (ScrapLaborCost +
> > ScrapBurdenCost + ScrapMaterialCost + ScrapMaterialBurCost) *
> Quantity
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
On
> Behalf Of
> > Nancy Metcalf
> > Sent: Wednesday, September 21, 2005 12:25 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Report Builder Help
> >
> > Can anyone tell me if I can create a field in a report that will
> > calculate the following information?
> >
> > (ScrapLaborCost+ScrapBurdenCost+ScrapMaterialCost)*Quantity
> >
> > I have tried using "Help" but am not getting anywhere fast. I
need
> > lay terms. I know how to calculate this in Excel but can't get
> Report
> > Builder to do it.
> >
> > OR....
> >
> > Does anyone have a report on Non-Conformances that would include
> > Machine ID, total costs, employee, date, reason, etc? My boss
> would
> > like a report so he can monitor scrap counts and dollars by
machine
> > and employee and since I am the only one in the company that
> knows "a
> > little" about report builder, I was given the task of coming up
> with a
> > report. Lucky me!!
> >
> > Any help would be greatly appreciated!!!!
> >
> >
> >
> >
> >
> > 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
Create new band lines, for your Machine Group (Both Header and Footer band
Lines.) You can add several lines for the same band to give you room for
Column labels and summary fields. Put the description field for your
machines in the HEADER BAND to title the group (I like to make them a larger
font in bold to help make it more readable. Next go to Aggregate Fields and
create a new field. Name it something like MachineDollarsSubtot. Select
your TOTAL function, go to the drop down field and select the Value field
you want to total. Next select reset on (ID code of your machine). This
is a simple subtotal so you don't need to worry about OPTIONS. Click OK and
exit back to your report. Next Insert the field into the FOOTER BAND. Test
your report
Shirley Graver
Rubber Associates
_____
From:
vantage@yahoogroups.com [mailto:
vantage@yahoogroups.com] On Behalf Of
Nancy Metcalf
Sent: Wednesday, September 21, 2005 4:11 PM
To:
vantage@yahoogroups.com
Subject: [Vantage] Re: Report Builder Help
THANK YOU! THANK YOU! THANK YOU!
The only thing I was doing wrong was leaving the spaces in.
Now that I have that field in place, how can I get the report to
give me a total cost for each individual machine ID? I am wanting
the report sorted/grouped by machine ID, each line having a cost and
then each machine having a total scrap cost.
Any help there??
--- In
vantage@yahoogroups.com, "Shirley Graver" <shirleyg@R...>
wrote:
> To add to sarahs reply, a beginner should use the TOOLBAR for
> entering in operators. For example 4+4 will fail while 4 + 4
will
> work just fine. User the VERIFY button after you think you've
> finished. Work your formual a piece at time IE: for (((a + b) *
> c) / d) build your formula (a + b) then VERIFY then ((a + b) *
c)
> then VERIFY then (((a + b) * c) / d) then VERIFY. That way when
it
> fails you know which pieces are good and which pieces are bad.
>
> Shirley
>
> --- In vantage@yahoogroups.com, sarah.vareschi@n... wrote:
> > To create this in report builder - go to 'Calculations' -
> > 'Calculated
> > field' -> 'New"
> >
> > Under Name - enter the name that you want it to be called, i.e.
> > "TotalScrapCost"
> >
> > In expression, enter the calculation using field names:
> (ScrapLaborCost +
> > ScrapBurdenCost + ScrapMaterialCost + ScrapMaterialBurCost) *
> Quantity
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
On
> Behalf Of
> > Nancy Metcalf
> > Sent: Wednesday, September 21, 2005 12:25 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Report Builder Help
> >
> > Can anyone tell me if I can create a field in a report that will
> > calculate the following information?
> >
> > (ScrapLaborCost+ScrapBurdenCost+ScrapMaterialCost)*Quantity
> >
> > I have tried using "Help" but am not getting anywhere fast. I
need
> > lay terms. I know how to calculate this in Excel but can't get
> Report
> > Builder to do it.
> >
> > OR....
> >
> > Does anyone have a report on Non-Conformances that would include
> > Machine ID, total costs, employee, date, reason, etc? My boss
> would
> > like a report so he can monitor scrap counts and dollars by
machine
> > and employee and since I am the only one in the company that
> knows "a
> > little" about report builder, I was given the task of coming up
> with a
> > report. Lucky me!!
> >
> > Any help would be greatly appreciated!!!!
> >
> >
> >
> >
> >
> > 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/> .
_____
Tracking #: 7EFE6B5CA76C544997C68524E00ADF2755D9AF75
[Non-text portions of this message have been removed]