Report Builder Question

To the Report Builder experts:

I am trying to write two different reports, but I need to do the same
thing in both reports.
Example: Trying to print all Quotes within certain date fields (I
accomplished this)
In addition, I would like to total all quotes ordered and
all quotes not ordered, then formulate the % of each.
This is where I am having trouble. Is this possible in Report
Builder? I've attempted to create an calculated field using an
If/then, but I did not know how to bring that into an aggregated
field to "Count".

Can someone help?

Thank you,
Joy Fekkes
Jaco Inc
jfekkes@...
Try IIF(Quoted = Yes,1,0) as a calculated field then Aggregate the
calculated field.

-----Original Message-----
From: jfekkes [mailto:jfekkes@...]
Sent: Friday, January 04, 2002 10:48 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder Question


To the Report Builder experts:

I am trying to write two different reports, but I need to do the same
thing in both reports.
Example: Trying to print all Quotes within certain date fields (I
accomplished this)
In addition, I would like to total all quotes ordered and
all quotes not ordered, then formulate the % of each.
This is where I am having trouble. Is this possible in Report
Builder? I've attempted to create an calculated field using an
If/then, but I did not know how to bring that into an aggregated
field to "Count".

Can someone help?

Thank you,
Joy Fekkes
Jaco Inc
jfekkes@...




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/
OK Report Builders Experts....

I'm trying to count the number of true occurance for
the following calculated field:

IIF (field1 - field > 0,1,0)

I want to count the number of true conditions, then
use that result in another calculation. (ie. total
true/total records)

Can anyone help me out???

__________________________________________________
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
Is your count aggregate set to pre-pass?
-Todd C.

-----Original Message-----
From: Zerfass Jim [mailto:jimzerfass@...]
Sent: Wednesday, January 09, 2002 8:01 AM
To: Vantage@...
Subject: [Vantage] Report Builder Question


OK Report Builders Experts....

I'm trying to count the number of true occurance for
the following calculated field:

IIF (field1 - field > 0,1,0)

I want to count the number of true conditions, then
use that result in another calculation. (ie. total
true/total records)

Can anyone help me out???

__________________________________________________
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/ <http://promo.yahoo.com/videomail/>


Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=215002.1818248.3328688.1261774/D=egroupweb/S=17050071
83:HM/A=847665/R=0/*http://ads.x10.com/?bHlhaG9vbW9uc3RlcjcuZGF0=1010584835%
3eM=215002.1818248.3328688.1261774/D=egroupweb/S=1705007183:HM/A=847665/R=1>


<http://us.adserver.yahoo.com/l?M=215002.1818248.3328688.1261774/D=egroupmai
l/S=1705007183:HM/A=847665/rand=322832812>

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]
No, it was not. I switched it and got the same
results. It appears to be counting each record.

What I'm trying to do with the calculation is compare
the Ship date from the ShipHead a the NeedByDate from
the OrderRel. Determine if shipment was early, late
or ontime. Count the number of each and do a % of the
total shipments.

--- Todd Caughey <caugheyt@...> wrote:
> Is your count aggregate set to pre-pass?
> -Todd C.
>
> -----Original Message-----
> From: Zerfass Jim [mailto:jimzerfass@...]
> Sent: Wednesday, January 09, 2002 8:01 AM
> To: Vantage@...
> Subject: [Vantage] Report Builder Question
>
>
> OK Report Builders Experts....
>
> I'm trying to count the number of true occurance for
> the following calculated field:
>
> IIF (field1 - field > 0,1,0)
>
> I want to count the number of true conditions, then
> use that result in another calculation. (ie. total
> true/total records)
>
> Can anyone help me out???
>
> __________________________________________________
> Do You Yahoo!?
> Send FREE video emails in Yahoo! Mail!
> http://promo.yahoo.com/videomail/
> <http://promo.yahoo.com/videomail/>
>
>
> Yahoo! Groups Sponsor
>
> ADVERTISEMENT
>
>
<http://rd.yahoo.com/M=215002.1818248.3328688.1261774/D=egroupweb/S=17050071
>
83:HM/A=847665/R=0/*http://ads.x10.com/?bHlhaG9vbW9uc3RlcjcuZGF0=1010584835%
>
3eM=215002.1818248.3328688.1261774/D=egroupweb/S=1705007183:HM/A=847665/R=1>
>
>
>
<http://us.adserver.yahoo.com/l?M=215002.1818248.3328688.1261774/D=egroupmai
> l/S=1705007183:HM/A=847665/rand=322832812>
>
> 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]
>
>
> ------------------------ 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/
>
>


__________________________________________________
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
Onetime Delivery Performance is a fun one. You may also want to see if the
shipment Quantity is at least 95% of the requested quantity to count it
onetime. Otherwise you would count it as a partial shipment. We count early
partials as a third category "Partial Shipment". But we count all shipments,
partial or not as late. This applies more to repetitive type manufacturing
but still can be done in report builder.

Hope this helps.

Patrick Winter



-----Original Message-----
From: Zerfass Jim [mailto:jimzerfass@...]
Sent: Wednesday, January 09, 2002 9:02 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report Builder Question


No, it was not. I switched it and got the same
results. It appears to be counting each record.

What I'm trying to do with the calculation is compare
the Ship date from the ShipHead a the NeedByDate from
the OrderRel. Determine if shipment was early, late
or ontime. Count the number of each and do a % of the
total shipments.
Jim,
Change your aggregate from COUNT to TOTAL. Your numbers should come out
correct.

Shirley H. Graver
(End User)
Systems Administrator
Rubber Associates Inc.

-----Original Message-----
From: Zerfass Jim [mailto:jimzerfass@...]
Sent: Wednesday, January 09, 2002 9:01 AM
To: Vantage@...
Subject: [Vantage] Report Builder Question

OK Report Builders Experts....

I'm trying to count the number of true occurance for
the following calculated field:

IIF (field1 - field > 0,1,0)

I want to count the number of true conditions, then
use that result in another calculation. (ie. total
true/total records)

Can anyone help me out???

__________________________________________________
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/



Yahoo! Groups Sponsor
ADVERTISEMENT

<http://rd.yahoo.com/M=215002.1818248.3328688.1261774/D=egroupweb/S=17050071
83:HM/A=847665/R=0/*http://ads.x10.com/?bHlhaG9vbW9uc3RlcjcuZGF0=1010584835%
3eM=215002.1818248.3328688.1261774/D=egroupweb/S=1705007183:HM/A=847665/R=1>


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


[Non-text portions of this message have been removed]
I am rewriting ours now but there are several changes and fields that don't
exist. I can modify the DBF files and manually add the fields to the file
and the report but I was curious if anyone had gotten a definitive answer on
how to handle W2s and 3.0 or are we on our own?

Thanks

Jim Carnes
IS Administrator
Kenlee Precision Corp
jcarnes@...
1700 Morrell Park Ave
Baltimore, MD 21230



[Non-text portions of this message have been removed]
Jim,
I have a stable of shipping performance reports that have been
working well, (though we do have some special twists specific to us).

Shirley H. Graver
(End User)
Systems Administrator
Rubber Associates Inc.

-----Original Message-----
From: Zerfass Jim [mailto:jimzerfass@...]
Sent: Wednesday, January 09, 2002 10:02 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report Builder Question

No, it was not. I switched it and got the same
results. It appears to be counting each record.

What I'm trying to do with the calculation is compare
the Ship date from the ShipHead a the NeedByDate from
the OrderRel. Determine if shipment was early, late
or ontime. Count the number of each and do a % of the
total shipments.

--- Todd Caughey <caugheyt@...> wrote:
> Is your count aggregate set to pre-pass?
> -Todd C.
>
> -----Original Message-----
> From: Zerfass Jim [mailto:jimzerfass@...]
> Sent: Wednesday, January 09, 2002 8:01 AM
> To: Vantage@...
> Subject: [Vantage] Report Builder Question
>
>
> OK Report Builders Experts....
>
> I'm trying to count the number of true occurance for
> the following calculated field:
>
> IIF (field1 - field > 0,1,0)
>
> I want to count the number of true conditions, then
> use that result in another calculation. (ie. total
> true/total records)
>
> Can anyone help me out???
>
> __________________________________________________
> Do You Yahoo!?
> Send FREE video emails in Yahoo! Mail!
> http://promo.yahoo.com/videomail/ <http://promo.yahoo.com/videomail/>
> < http://promo.yahoo.com/videomail/ <http://promo.yahoo.com/videomail/> >
>
>
> Yahoo! Groups Sponsor
>
> ADVERTISEMENT
>
>
<
http://rd.yahoo.com/M=215002.1818248.3328688.1261774/D=egroupweb/S=17050071
>
83:HM/A=847665/R=0/*
http://ads.x10.com/?bHlhaG9vbW9uc3RlcjcuZGF0=1010584835%
<http://ads.x10.com/?bHlhaG9vbW9uc3RlcjcuZGF0=1010584835%25>
>
3eM=215002.1818248.3328688.1261774/D=egroupweb/S=1705007183:HM/A=847665/R=1>
>
>
>
<
http://us.adserver.yahoo.com/l?M=215002.1818248.3328688.1261774/D=egroupmai
> l/S=1705007183:HM/A=847665/rand=322832812>
>
> 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]
>
>
> ------------------------ 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/
>
>


__________________________________________________
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/



Yahoo! Groups Sponsor
ADVERTISEMENT

<http://rd.yahoo.com/M=215002.1818248.3328688.1261774/D=egroupweb/S=17050071
83:HM/A=847665/R=0/*http://ads.x10.com/?bHlhaG9vbW9uc3RlcjcuZGF0=1010588559%
3eM=215002.1818248.3328688.1261774/D=egroupweb/S=1705007183:HM/A=847665/R=1>


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


[Non-text portions of this message have been removed]
Jim, looks to me you need as many as three calculated fields and an
aggregate for each. I would setup this way:

was_late = iif (date1-date2 < 0, 1,0)
was_ontime = iif (date1-date2 = 0, 1, 0)
was_early = iif (date1-date2 > 0, 1,0)

total_late = aggregate Total was_late
total_ontime = aggreagte Total was_ontime
total_early = aggregate Total was_early

note: Don't use Count in the aggregate as this counts the 1 or the 0 just
the same, use Total.

Regards
Jim Stetter
-----Original Message-----
From: Zerfass Jim [mailto:jimzerfass@...]
Sent: Wednesday, January 09, 2002 10:02 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report Builder Question


No, it was not. I switched it and got the same
results. It appears to be counting each record.

What I'm trying to do with the calculation is compare
the Ship date from the ShipHead a the NeedByDate from
the OrderRel. Determine if shipment was early, late
or ontime. Count the number of each and do a % of the
total shipments.

--- Todd Caughey <caugheyt@...> wrote:
> Is your count aggregate set to pre-pass?
> -Todd C.
>
> -----Original Message-----
> From: Zerfass Jim [mailto:jimzerfass@...]
> Sent: Wednesday, January 09, 2002 8:01 AM
> To: Vantage@...
> Subject: [Vantage] Report Builder Question
>
>
> OK Report Builders Experts....
>
> I'm trying to count the number of true occurance for
> the following calculated field:
>
> IIF (field1 - field > 0,1,0)
>
> I want to count the number of true conditions, then
> use that result in another calculation. (ie. total
> true/total records)
>
> Can anyone help me out???
>



[Non-text portions of this message have been removed]
At 07:02 AM 1/9/02 -0800, you wrote:
>What I'm trying to do with the calculation is compare
>the Ship date from the ShipHead a the NeedByDate from
>the OrderRel. Determine if shipment was early, late
>or ontime. Count the number of each and do a % of the
>total shipments.

Try creating one aggregate to sum the 0 and 1 values from you calculated
field. That should be the number of ontime shipments in each group. And
another aggregate to count the details - that's total shipments for the
group. Then a calculated field to do the percentage between the two
aggregates.

-Wayne
Jim,

Since you are on 3.0 I am not sure but Tim Ligas did post the following
message regarding 4.0. Maybe they can do the same for 3.0

"The Vantage Custom Programming group has agreed to undertake a project
to retro-fit the W2 changes into Vantage 4.00. This mod will be
completed by
the end of the first week of January and will be offered at a nominal
fee of
$150.00. Anyone interested in this mod should email Custom Programming
at
custprog@...."

Also, another user posted a W2 crystal report, that would work for
4.0. If you do not want to pay the $150.00 download that and start
their with yours.

Dina


Jim Carnes wrote:

> I am rewriting ours now but there are several changes and fields that
> don't
> exist. I can modify the DBF files and manually add the fields to the
> file
> and the report but I was curious if anyone had gotten a definitive
> answer on
> how to handle W2s and 3.0 or are we on our own?
>
> Thanks
>
> Jim Carnes
> IS Administrator
> Kenlee Precision Corp
> jcarnes@...
> 1700 Morrell Park Ave
> Baltimore, MD 21230
>
>
>
> [Non-text portions of this message have been removed]
>
>
> 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.

--
Dina M. Hieber
Vamco International, Inc.
555 Epsilon Drive
Pittsburgh, PA 15238
(412) 963-7100 - phone
(412) 963-9511 - fax

www.vamcointernational.com



[Non-text portions of this message have been removed]
I gave up on them and bought a program from staples. It works good, but took
about a day to enter in all the info

John Memmelaar Jr
Royal Master Grinders, Inc
143 Bauer Drive
Oakland, NJ 07436
Phone: 001-201-337-8500
Fax: 001-201-337-2324
E-mail: johnjr@...
I had asked Tim for clarification since the subject line had 3.0 and 4.0.
He said the fix would not be done for 3.0.

Rick

> Jim,
>
> Since you are on 3.0 I am not sure but Tim Ligas did post the
> following message regarding 4.0. Maybe they can do the same for 3.0
I asked the same and got the opposite answer. anyway the program from staples
cost 59.99 and came with forms

John Memmelaar Jr
Royal Master Grinders, Inc
143 Bauer Drive
Oakland, NJ 07436
Phone: 001-201-337-8500
Fax: 001-201-337-2324
E-mail: johnjr@...
Interesting. I just got a test install 5.1 running this morning with recent
data, so we are just going to run them from there.

Rick


> I asked the same and got the opposite answer. anyway the
> program from staples cost 59.99 and came with forms
>
> John Memmelaar Jr
> Royal Master Grinders, Inc
> 143 Bauer Drive
> Oakland, NJ 07436
> Phone: 001-201-337-8500
> Fax: 001-201-337-2324
> E-mail: johnjr@...
I have built a simple report based on a single table (Part). I am
trying to compare a calculated field against the Internal Unit Price
field. I set the only filter to show parts where calc field <>
internalunitprice. The filter does not work. It shows on the report
fields that are the same. What am I doing wrong? Is comparing a
numeric field with a calculated field not possible?

Juliet
One way to diagnose a filter problem like that is to have both field that
you are comparing print on the report and see what is happening. If both
fields are truely the same then look at your calculation to see that its
correct.

Shirley Graver
Systems Administrator
Rubber Associates Inc.
Cleveland/Akron, OH

-----Original Message-----
From: Juliet Martin [mailto:jmartin@...]
Sent: Tuesday, April 16, 2002 1:55 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder Question


I have built a simple report based on a single table (Part). I am
trying to compare a calculated field against the Internal Unit Price
field. I set the only filter to show parts where calc field <>
internalunitprice. The filter does not work. It shows on the report
fields that are the same. What am I doing wrong? Is comparing a
numeric field with a calculated field not possible?

Juliet

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]
My guess is that the calculated field has a higher degree of precision (more
decimal places than the data field even if you set the display format to
match). With that in mind, you might have to round or truncate the
calculated field to match the precision of the data field.

Jim Stetter

-----Original Message-----
From: Juliet Martin [mailto:jmartin@...]
Sent: Tuesday, April 16, 2002 1:55 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder Question


I have built a simple report based on a single table (Part). I am
trying to compare a calculated field against the Internal Unit Price
field. I set the only filter to show parts where calc field <>
internalunitprice. The filter does not work. It shows on the report
fields that are the same. What am I doing wrong? Is comparing a
numeric field with a calculated field not possible?

Juliet


Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=194081.1994012.3473453.1261774/D=egroupweb/S=17050071
83:HM/A=1036972/R=0/*http://www.ediets.com/start.cfm?code=3466> Click Here!


<http://us.adserver.yahoo.com/l?M=194081.1994012.3473453.1261774/D=egroupmai
l/S=1705007183:HM/A=1036972/rand=829749916>

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]
Hi,



I need some help with a report builder question. In the payroll files there
is a table called 'PREmpRt' with a field of 'RateDate'. The records are
linked to the 'PREmpMas' table using the 'EmpLink' field.



I am trying to write a report giving the employee's latest rate and/or
vacation remaining.



The problem is that each time an employee's rate is changed, there is a new
entry placed in the 'PREmpRt' table. I need the record with the latest
'RateDate' because if you run a report without getting just the latest rate
you get as many entries per employee as there are rate changes.



I know you supposedly can't use Report Builder with payroll, but with some
third party software magic and redirection of triggers it works just fine.



Thanks,



Dave Cole

Reeder & Kline



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