Create a calculated field like..
DateAndRate = string(RateDate,"99/99/9999") + string(PayRate)
... create a maximum aggregate on DateAndRate.
Sorting by RateDate ascending, the highest aggregate will be
available on the employee group line. Use substring function to
grab rate from DateAndRate, convert to decimal, then multiply as
needed.
Impressive PR work around you have there, I'm envious! Payroll is my
least favorite module to write programs/reports from....
Lonnie
--- In vantage@y..., "Cole, Dave" <dave@r...> wrote:
> 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]
I am trying to create a report and need to change an integer field into a
character field. I have gone brain dead!! Can this be done and if it can
how?
Thanks,
Kathy Hambleton
Electron Energy Corporation
Kathy
The function is STRING
The format is string(value, format)
The format is in quotes like ">>>9.99"
Russ Dover
PS you're not brain dead. Brain Dead people can't send e-mail...
Uhh, bad example :-)
> I am trying to create a report and need to change an integer field into a
> character field. I have gone brain dead!! Can this be done and if it can
> how?
>
> Thanks,
> Kathy Hambleton
> Electron Energy Corporation
>
>
>
> 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/
>
>
Russ Dover
IS Manager
Weaver Industries, Inc.
717 336 7507 phone
717 336 4182 fax rdover@...
www.weaverind.com
Hi,
I am trying to get the quantity completed on the previous operation
on a report. I thought I did this before, but maybe not, and I can't seem
to do it now. Any ideas?
Thanks,
Judy Stauduhar
Synovis Interventional Solutions
This is most likely a simple thing, but I can't for the life of me
figure it out.
I am writing an RB report that calculates our sales $ by Year,
Month,and Product Group, and they want to be able to see last year
and this year on the same report. Or even the current year plus the
past two years.
Anyway, does anyone know how I would do an aggregate field that will
add the invoice amount when the year/month are the same? I don't
know why this has me stumped...but it does. Please feel free to e-
mail me direct if you'd like to. Thanks in advance.
Create function field where the value is either the invoice amount, if the
date test is true, or else zero then use this in the aggregate. Depending
on grouping and other issues you might (probably will actually) need to
aggregate it "pre-pass". Using various functions/aggregates for different
periods should allow side by side comparisons.
-Todd C.
-----Original Message-----
From: judyh001 [mailto:judy.havlik@...]
Sent: Monday, August 26, 2002 3:20 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder Question
This is most likely a simple thing, but I can't for the life of me
figure it out.
I am writing an RB report that calculates our sales $ by Year,
Month,and Product Group, and they want to be able to see last year
and this year on the same report. Or even the current year plus the
past two years.
Anyway, does anyone know how I would do an aggregate field that will
add the invoice amount when the year/month are the same? I don't
know why this has me stumped...but it does. Please feel free to e-
mail me direct if you'd like to. Thanks in advance.
I'm trying to select records by comparing two dates in a report filter like
this: PORelDueDate <> PORelPromiseDt
It works fine except I do not get records where the PORelPromiseDt field is
not populated. I would have guessed that comparing a field with a date in
it to a field that's empty would pass the criteria that they were not equal
but no dice. I do not see any "ISNULL" type functions available to create a
calculated field to use for filtering....any ideas?
Greg Clauser
General Manager
Lakin General Corporation
773-871-9604 FAX: 773-871-1265 gclauser@... <mailto:gclauser@...>
If someone could help me out. I'm not very well versed in Report Builder.
I have a field on a report from a check box that returns a yes/no value. I
need to add all the "yes" values together and total them at the bottom of
the report.
Thanks
--
Gary Wassing
MIS
SteelCraft Industries
519-271-4750
x227
[Non-text portions of this message have been removed]
Create a Calculated field called "CheckBoxCount" with the formula
"IIF(checkbox = yes,1,0)" then add up "CheckBoxCount".
Patrick Winter
-----Original Message-----
From: Gary Wassing [mailto:gwassing@...]
Sent: Thursday, February 27, 2003 8:52 AM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Report Builder Question
If someone could help me out. I'm not very well versed in Report Builder. I
have a field on a report from a check box that returns a yes/no value. I
need to add all the "yes" values together and total them at the bottom of
the report.
Thanks
--
Gary Wassing
MIS
SteelCraft Industries
519-271-4750
x227
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor ---------------------~--> Get
128 Bit SSL Encryption! http://us.click.yahoo.com/FpY02D/vN2EAA/xGHJAA/PhFolB/TM
---------------------------------------------------------------------~->
(sorry about possible email wrapping of the fomula)
Basically if there is a "space" found in the contact name it takes evertything in front of it otherwise uses the whole field. The comma afterward was because this was used in the salutation on the letter as in "Dear Paul,".
-Todd C.
-----Original Message-----
From: Darren Mann [mailto:dmann@...]
Sent: Friday, March 14, 2003 9:24 AM
To: Vantage User Group (E-mail)
Subject: [Vantage] Report Builder Question
Can anyone give my a formula to extract the First name from the contact name
field (it contains both first and last name) in report builder?
I need to use it on a letter greeting but can not find the right combination
of string functions to accomplish this. Any help appreciated.
Thank you,
Darren Mann
Miller Products Co.
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system ( http://www.grisoft.com).
Version: 6.0.461 / Virus Database: 260 - Release Date: 3/10/2003
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]
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]
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/
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.461 / Virus Database: 260 - Release Date: 3/10/2003
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.461 / Virus Database: 260 - Release Date: 3/10/2003
I am creating a report that prints bar code labels for production. I would
use the one that comes with vantage but there is no way for me to get the
customers part number to print on it. I want to have a filter where the
user can pick a number 1 - 24 and have that number show up on the label as
the quantity of parts any ideas on how to do this?
I have a technique I use to parse date ranges out of the report filter. If you have never tried to use the REPORT-FILTER() value there are a couple tricks required. The same technique also works for other data. I have a short notepad document which I'll copy to you off-list.
-Todd C.
I am creating a report that prints bar code labels for production. I would
use the one that comes with vantage but there is no way for me to get the
customers part number to print on it. I want to have a filter where the
user can pick a number 1 - 24 and have that number show up on the label as
the quantity of parts any ideas on how to do this?
Thank you to the people who responded to my question on my report builder
run time question. After sending out the email, I thought to relook at my
joins, and found that I had one join as an inner join rather than a left
outer join. Once I changed that, it runs in about 5 seconds!
Sandy Zarda, Vice President
Major Industries Inc
[Non-text portions of this message have been removed]
I need to build a report on approved vendors and print the vendor master
name and address if there is no purchase point. If there is a purchase
point I want to print only the information from the VendorPP file and I do
not want to print the Vendor Master information. I have the report set up
with a left join to the VendorPP from the Vendor file and two detail lines.
One to conditionally print if there is no purchase point and one to print if
there is. I am getting both lines every time. What do I need to do?