Report Builder Help

Yahoo Archive
1
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
2
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
3
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
4
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.
5
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.
>
6
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.)
7
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.)
8
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.
9
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/
10
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]
11
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
83:HM/A=1189558/R=0/*http://www.bmgmusic.com/acq/ee/q6/enroll/mhn/9/>

<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/.>
(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]
12
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]
13
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
14
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/
15
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/
16
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/
17
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/
18
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/
19
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/
20
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]