RB Help

Yahoo Archive
1
If you have booking turned on, I think it is much easier to run a report
like this off of the booking tables. We do something similar based on sales
$, but we run off the booking tables (we also use Access not RB but it would
work in RB also).

You turn on booking in the order configuration screen. The tables are
BookOrd and BookDtl. The BookDtl table collects any changes made to qty on
the SO line. (see data dictionary viewer for more field information).
2
OK you RB wizards,

Any suggestions for which Table(s) and field(s) can be used to generate a
report to show who is absent for a day or range of days?
Also how can I display a field if there is not any data in that field?

Thanks.

Jim Moore
System Admin.
General Dynamics-OTS (DRI)
256-835-1660 x373
jmoore@...-ots.com
3
Master Table = EmpBasic
Left Outter Join to LaborHed
Company to Company
Empbasic.EmpID to LaborHed.EmployeeNum

filter on (LaborHed.PayrollDate = ? or LaborHed.PayrollDate = 11/27/2001)

The left outer join will display the the EmpBaic record with no LaborHed
record.
The fields appear with a "?".

That should get you started.

Patrick Winter
sSc Specialty Screw Corporation
Vantage 5.00.317, Progress 9.1a


-----Original Message-----
From: Moore, Jim (DRI) [mailto:jmoore@...-ots.com]
Sent: Tuesday, November 27, 2001 11:10 AM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] RB Help


OK you RB wizards,

Any suggestions for which Table(s) and field(s) can be used to generate a
report to show who is absent for a day or range of days?
Also how can I display a field if there is not any data in that field?

Thanks.

Jim Moore
System Admin.
General Dynamics-OTS (DRI)
256-835-1660 x373
jmoore@...-ots.com


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/
4
Patrick,thanks for your reply. I tried your suggestion and it gives me the
same results each time no matter what date I choose for the payrolldate. I
have tried to display laborhed.payhours = ? or 0 without success as well.
Any other idea's?



-----Original Message-----
From: Winter, Patrick [mailto:pjw@...]
Sent: Tuesday, November 27, 2001 11:21 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] RB Help


Master Table = EmpBasic
Left Outter Join to LaborHed
Company to Company
Empbasic.EmpID to LaborHed.EmployeeNum

filter on (LaborHed.PayrollDate = ? or LaborHed.PayrollDate = 11/27/2001)

The left outer join will display the the EmpBaic record with no LaborHed
record.
The fields appear with a "?".

That should get you started.

Patrick Winter
sSc Specialty Screw Corporation
Vantage 5.00.317, Progress 9.1a


-----Original Message-----
From: Moore, Jim (DRI) [mailto:jmoore@...-ots.com]
Sent: Tuesday, November 27, 2001 11:10 AM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] RB Help


OK you RB wizards,

Any suggestions for which Table(s) and field(s) can be used to generate a
report to show who is absent for a day or range of days?
Also how can I display a field if there is not any data in that field?

Thanks.

Jim Moore
System Admin.
General Dynamics-OTS (DRI)
256-835-1660 x373
jmoore@...-ots.com


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/
5
Make sure you are doing a left outer join.

Filter can be:
company = (your company)
(payrolldate >= 11/01/2001 or payrolldate = ?)

or use INLIST instead of >=

Patrick


-----Original Message-----
From: Moore, Jim (DRI) [mailto:jmoore@...-ots.com]
Sent: Tuesday, November 27, 2001 2:08 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] RB Help


Patrick,thanks for your reply. I tried your suggestion and it gives me the
same results each time no matter what date I choose for the payrolldate. I
have tried to display laborhed.payhours = ? or 0 without success as well.
Any other idea's?



-----Original Message-----
From: Winter, Patrick [mailto:pjw@...]
Sent: Tuesday, November 27, 2001 11:21 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] RB Help


Master Table = EmpBasic
Left Outter Join to LaborHed
Company to Company
Empbasic.EmpID to LaborHed.EmployeeNum

filter on (LaborHed.PayrollDate = ? or LaborHed.PayrollDate = 11/27/2001)

The left outer join will display the the EmpBaic record with no LaborHed
record.
The fields appear with a "?".

That should get you started.

Patrick Winter
sSc Specialty Screw Corporation
Vantage 5.00.317, Progress 9.1a


-----Original Message-----
From: Moore, Jim (DRI) [mailto:jmoore@...-ots.com]
Sent: Tuesday, November 27, 2001 11:10 AM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] RB Help


OK you RB wizards,

Any suggestions for which Table(s) and field(s) can be used to generate a
report to show who is absent for a day or range of days?
Also how can I display a field if there is not any data in that field?

Thanks.

Jim Moore
System Admin.
General Dynamics-OTS (DRI)
256-835-1660 x373
jmoore@...-ots.com


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/
6
I have almost completed a report that gives us a report of our
vendors/subcontractors with po#, packslip#,part# and desc, pass/failed qty
and receipt date.
I filter all this by company,receipt date and packslip #.
I have the following fields joined. RcvDtl to RcvHead RcvDtl to PORel
RcvHead to Vendor All Inner.

The problem is that the records keep repeating. I am pretty sure that it is
a join problem, maybe related to the way it is filtered, but I have been
unable to figure this out. I considered doing a conditional print, but I'm
not sure what route to take.

Any Ideas?

Thanks.

Jim Moore
System Admin.
General Dynamics-OTS (DRI)
7
Recreate and build the report from scratch link by link, previewing in
between additions to identify what your duplication in records is.

Patrick

-----Original Message-----
From: Moore, Jim (DRI) [mailto:jmoore@...-ots.com]
Sent: Monday, March 11, 2002 2:01 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] RB Help


I have almost completed a report that gives us a report of our
vendors/subcontractors with po#, packslip#,part# and desc, pass/failed qty
and receipt date.
I filter all this by company,receipt date and packslip #.
I have the following fields joined. RcvDtl to RcvHead RcvDtl to PORel
RcvHead to Vendor All Inner.

The problem is that the records keep repeating. I am pretty sure that it is
a join problem, maybe related to the way it is filtered, but I have been
unable to figure this out. I considered doing a conditional print, but I'm
not sure what route to take.

Any Ideas?

Thanks.

Jim Moore
System Admin.
General Dynamics-OTS (DRI)



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/
8
Your RcvDtl to PORel link should be linked by company, PONum, POLine, and PORel. If you forget PORel, you'll get more than you bargained for. Does that look like a culprit?

Troy Funte
Liberty Electronics

----- Original Message -----
From: Moore, Jim (DRI)
To: 'vantage@yahoogroups.com'
Sent: Monday, March 11, 2002 3:01 PM
Subject: [Vantage] RB Help


I have almost completed a report that gives us a report of our
vendors/subcontractors with po#, packslip#,part# and desc, pass/failed qty
and receipt date.
I filter all this by company,receipt date and packslip #.
I have the following fields joined. RcvDtl to RcvHead RcvDtl to PORel
RcvHead to Vendor All Inner.

The problem is that the records keep repeating. I am pretty sure that it is
a join problem, maybe related to the way it is filtered, but I have been
unable to figure this out. I considered doing a conditional print, but I'm
not sure what route to take.

Any Ideas?

Thanks.

Jim Moore
System Admin.
General Dynamics-OTS (DRI)


Yahoo! Groups Sponsor
ADVERTISEMENT




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 the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
9
Troy,
I did have Company,PO#, and POLine joined. I don't follow you on joining
PORel. What field in Table RcvDtl do I use to join with what field in Table
PORel?

Thanks.

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Monday, March 11, 2002 5:14 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] RB Help


Your RcvDtl to PORel link should be linked by company, PONum, POLine, and
PORel. If you forget PORel, you'll get more than you bargained for. Does
that look like a culprit?

Troy Funte
Liberty Electronics

----- Original Message -----
From: Moore, Jim (DRI)
To: 'vantage@yahoogroups.com'
Sent: Monday, March 11, 2002 3:01 PM
Subject: [Vantage] RB Help


I have almost completed a report that gives us a report of our
vendors/subcontractors with po#, packslip#,part# and desc, pass/failed qty
and receipt date.
I filter all this by company,receipt date and packslip #.
I have the following fields joined. RcvDtl to RcvHead RcvDtl to PORel
RcvHead to Vendor All Inner.

The problem is that the records keep repeating. I am pretty sure that it
is
a join problem, maybe related to the way it is filtered, but I have been
unable to figure this out. I considered doing a conditional print, but I'm
not sure what route to take.

Any Ideas?

Thanks.

Jim Moore
System Admin.
General Dynamics-OTS (DRI)


Yahoo! Groups Sponsor
ADVERTISEMENT




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 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

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
10
PORelNum



[Non-text portions of this message have been removed]
11
Jim,
There is RcvDtl.PORelNum and PORel.PORelNum. These should be linked as well or else you'll get every release (from all lines) for each POLine on your report. Or something just as messy.

Troy Funte
Liberty Electronics
----- Original Message -----
From: sarah.vareschi@...
To: vantage@yahoogroups.com
Sent: Tuesday, March 12, 2002 6:37 AM
Subject: RE: [Vantage] RB Help


PORelNum


Jim Moore wrote...

Troy,
I did have Company,PO#, and POLine joined. I don't follow you on joining
PORel. What field in Table RcvDtl do I use to join with what field in Table
PORel?

Thanks.



[Non-text portions of this message have been removed]
12
Thanks for everyone's help. With that and one other similar correction the
report is working great.
Thanks again.

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Tuesday, March 12, 2002 11:38 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] RB Help


Jim,
There is RcvDtl.PORelNum and PORel.PORelNum. These should be linked as
well or else you'll get every release (from all lines) for each POLine on
your report. Or something just as messy.

Troy Funte
Liberty Electronics
----- Original Message -----
From: sarah.vareschi@...
To: vantage@yahoogroups.com
Sent: Tuesday, March 12, 2002 6:37 AM
Subject: RE: [Vantage] RB Help


PORelNum


Jim Moore wrote...

Troy,
I did have Company,PO#, and POLine joined. I don't follow you on joining
PORel. What field in Table RcvDtl do I use to join with what field in
Table
PORel?

Thanks.



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



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
13
I am trying to create an RB report that shows production details from the previous day of
production. It works great for most days using ClockInDate=Today()-1. It does not work so well
when run on Monday for example when it will look at records from Sunday instead of Friday. Can
someone help me with a formula to select these records properly so the user does not have to
change the filter at run time? Ideally running the report on Monday would look at Friday,
Saturday and Sunday just in case work did get performed on the weekend.

Thanks and I hope that makes sense.

Todd Hofert
Spartan Graphics, Inc.
(616)887-8243
14
Create a Function that is an optional ClockInDate. Call it fClockInDate (I
use f to represent fake or faux). Your formula would then be.

Iif(SPELL-WEEKDAY(DATE_RB) = 'Monday',ClockInDate =
Today()-3,iif(SPELL-WEEKDAY(DATE_RB) = 'Tuesday',ClockInDate =
Today()-2,Today()-1))

-----Original Message-----
From: Todd Hofert [mailto:thofert@...]
Sent: Tuesday, March 19, 2002 1:36 PM
To: Vantage List (E-mail)
Subject: [Vantage] RB Help

I am trying to create an RB report that shows production
details from the previous day of
production. It works great for most days using
ClockInDate=Today()-1. It does not work so well
when run on Monday for example when it will look at records
from Sunday instead of Friday. Can
someone help me with a formula to select these records
properly so the user does not have to
change the filter at run time? Ideally running the report on
Monday would look at Friday,
Saturday and Sunday just in case work did get performed on
the weekend.

Thanks and I hope that makes sense.

Todd Hofert
Spartan Graphics, Inc.
(616)887-8243


------------------------ Yahoo! Groups Sponsor

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
At 02:36 PM 3/19/2002 -0500, you wrote:
>using ClockInDate=Today()-1. It does not work so well when run on Monday
>for example when it will look at records from Sunday instead of Friday.
>Can someone help me with a formula to select these records properly so the
>user does not have to change the filter at run time?

The Weekday() function returns a number 1 - 7, with 1 being Sunday. So you
could create a field :
IIF(WEEKDAY(TODAY()) = 2,TODAY() - 3,TODAY() - 1)

Call it TestDate, then you can filter: PayrollDate >= TestDate btw... if
you have any shifts wrapping over midnight, PayrollDate wraps back to the
starting day [what I want most the time] whereas ClockInDate is always the
actual date.

-Wayne Cox
Twenty Three -- Information Technology Consulting
828-685-2338
16
Use the,
IIF(WEEKDAY(TODAY) = 2, Today - 3, Today -1)
If the weekday of today is 2 (1-sunday, 2-monday, etc..) then subtract 3
other wise subtract 1.

also try PAYROLL date because it's indexed.

Patrick

-----Original Message-----
From: Todd Hofert [mailto:thofert@...]
Sent: Tuesday, March 19, 2002 1:36 PM
To: Vantage List (E-mail)
Subject: [Vantage] RB Help


I am trying to create an RB report that shows production details from the
previous day of
production. It works great for most days using ClockInDate=Today()-1. It
does not work so well
when run on Monday for example when it will look at records from Sunday
instead of Friday. Can
someone help me with a formula to select these records properly so the user
does not have to
change the filter at run time? Ideally running the report on Monday would
look at Friday,
Saturday and Sunday just in case work did get performed on the weekend.

Thanks and I hope that makes sense.

Todd Hofert
Spartan Graphics, Inc.
(616)887-8243



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
Create a calculate field, say 'Day'. (I'm really original).

Set the calculation to: iif(WEEKDAY(Today()) = 2,Today() - 3,Today() - 1)

Change your filter to: ClockInDate >= Day

Add to your filter: ClockInDate < today()



[Non-text portions of this message have been removed]
18
Thanks to everyone who replied with the formula listed below.
Thanks again
Todd

-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Tuesday, March 19, 2002 3:13 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] RB Help


Create a calculate field, say 'Day'. (I'm really original).

Set the calculation to: iif(WEEKDAY(Today()) = 2,Today() - 3,Today() - 1)

Change your filter to: ClockInDate >= Day

Add to your filter: ClockInDate < today()



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



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your
email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and
other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
19
I am trying to create a report that shows Customer name,Sales order #,
Invoice #, Invoice date and Invoice amount.
All above I have done by joining invchead to customer and it works fine.
However as always there is a got-cha. I also need to have a
receipt/transaction date and amount for A/R with all of the above.
All filtered by invoice date and customer id and closed invoices. Any ideas
for tables that will work. I have tried many different ones.

Any ideas or help is greatly appreciated.

Jim Moore
GD-OTS
20
I am trying to create a report that will list all customers who have not purchased from us in the last year. I am having trouble figuring out how to tell RB how to identify those customers. Does anyone have suggestions?

Thanks

Todd Hofert
IT Director
Spartan Graphics, Inc.