The boss wants me to create a report simular to the Shop Load
Report, but to also include showing if the material has been
received or not. They do not want to use the Priority Dispatch
Report <sigh>.

I've set the JobOper as the primary table, and have set the
WCCode as the primary sort (and group), and the LoadDate as the
secondary sort. Filtering out the completed jobs and completed
operations (and all workcenters not applicable) gives me something
close to the initial data as deplicted in the Shop Load Report (give
or take some formating). But, determining if the material is here is
proving to be more difficult.

Since we do so many different jobs with different methods, I'm
having difficulty coming up with a way to report this. There may be
anywhere from zero to multiple lines in the material requirements, so
I can't use that. In addition, if Vantage says that we need 12.6 feet
of material (accounting for our scrap rate), and we only get 12 feet
'knowing' that it's really enough, but not updating the job (I know, I
know), we can't use that either.

One option would to 'always' have, say, Operation #10 as 'Receive
Material'. As I step through the open jobs and open operations,
how can I 'look back' into a different operation #?

Another option would be to "assume" that if the prior opp had been
completed, the material is here. How can I determine the number of
the prior operation? I can't assume that it's the current opp number
minus 10, it may have been added to the job after the fact, such as
opp #25. Even if I could determine the prior op #, I'm still stuck
'looking back'.

In a programing language, it would look 'something' like:

If ((JobNum = JobNum()) and (OprSeq = 10) and (OpComplete =
.T.) then .......

I don't see that capability in Report Builder. I can analize the
"curent" record, but I can't go look at another specific record, and
still keep my place in the sort.

I really don't want to do another Group on the Job Number,
memorizing the status of Op #10, but only printing the first non-
complete record (and somehow skipping the remaining records,
*especially* any of the remaining records need to be displayed
later). Yech ....

Any help?

Thanks in advance !!

===============================================
Malcolm Spann
MIS
Malmberg Engineering
(925) 606-6500 x19
(925) 606-6505 FAX
Malcolm@...
===============================================

You can look for the prior operation if you create a variable which is equal
to the operation sequence then subtract 10 from it. Use this variable in a
join back to the JobOpr table creating an alias name for the table like
JobOpr2. The negative's are you miss added operations (025) so you will need
another report to pick these up, also you can not remove holidays from the
shop load. The positives are you can include priority dispatch information
on the shop load report, relieve work done on operations with your own
formula, create messages on the report like, "Job has started.", "Job setup
time is over estimated.", etc...
I also do a version linking to JobMtl, I have one material item (wire which
we make fasteners out of) and you are right, you need to have that material
linked to the job sequence number it is used on and include this in the
table join otherwise you will get a very slow report. We should shoot the
developer who designed the Production Calendar (ProdCal) by putting an array
in one of the tables fields, it is impossible to link to with report
builder. You would think that we learned a lesson from doing this to the
salesrep field in order entry. By the way if I could link to the production
calendar (ProdCal) I would then subtract out holidays reducing the weekly
buckets total available hours for Thanksgiving, Christmas, etc...

Merry Christmas

Patrick J. Winter
Information Services Manager
sSc Specialty Screw Corporation

-----Original Message-----
From: Malcolm Spann [mailto:Malcolm@...]
Sent: Monday, September 18, 2000 06:45 PM
To: vantage@egroups.com
Subject: [Vantage] Report Builder Question

The boss wants me to create a report simular to the Shop Load
Report, but to also include showing if the material has been
received or not. They do not want to use the Priority Dispatch
Report <sigh>.

I've set the JobOper as the primary table, and have set the
WCCode as the primary sort (and group), and the LoadDate as the
secondary sort. Filtering out the completed jobs and completed
operations (and all workcenters not applicable) gives me something
close to the initial data as deplicted in the Shop Load Report (give
or take some formating). But, determining if the material is here is
proving to be more difficult.

One option would to 'always' have, say, Operation #10 as 'Receive
Material'. As I step through the open jobs and open operations,
how can I 'look back' into a different operation #?

Another option would be to "assume" that if the prior opp had been
completed, the material is here. How can I determine the number of
the prior operation? I can't assume that it's the current opp number
minus 10, it may have been added to the job after the fact, such as
opp #25. Even if I could determine the prior op #, I'm still stuck
'looking back'.

In a programing language, it would look 'something' like:

If ((JobNum = JobNum()) and (OprSeq = 10) and (OpComplete =
.T.) then .......

I don't see that capability in Report Builder. I can analize the
"curent" record, but I can't go look at another specific record, and
still keep my place in the sort.

I really don't want to do another Group on the Job Number,
memorizing the status of Op #10, but only printing the first non-
complete record (and somehow skipping the remaining records,
*especially* any of the remaining records need to be displayed
later). Yech ....

Any help?

Thanks in advance !!

===============================================
Malcolm Spann
MIS
Malmberg Engineering
(925) 606-6500 x19
(925) 606-6505 FAX
Malcolm@...
===============================================

Sarah has you covered on the connection options for the report, Jeni.
However, make sure that you check the report filters once you get the report
opened (typically, there will be a filter on company name or other things
that are unique to the company that posted the report). In report builder
the filters are found under the funnel icon.

Good luck!

Kenneth E. Urban
Manager, Information Systems & Technology
Major Industries, Inc.
7120 Stewart Avenue
Wausau, WI 54401
(715) 842-4616 voice
kurban@...

-----Original Message-----
From: jeniwilson@... [mailto:jeniwilson@...]
Sent: Tuesday, October 17, 2000 2:29 PM
To: vantage@egroups.com
Subject: [Vantage] Report Builder Question

We are on Vantage 3.0 Progress 8.3A. We are new to report builder
and after downloading a report off the egroup cannot connect to the
database.

In connect Database, there are several options that need to be
completed. Where do you get the informaton to complete such things
as Service Name, Host Name, Password, User ID, Trigger Location,
Parameter File, Physical Name and Logical Name? Network is TCP.

What you probably want to do is group by part class, and create the
calculated field

OrderLineAmount which will include the statement
PODetail.UnitCost * PODetail.OrderQty

Now create an aggregate field that resets based on part class, that is a
total of the OrderLineAmount field

Place the aggregate field in the part class group footer, and you should be
on your way.

the line:

PODetail.UnitCost * PODetail.OrderQty = OrdLnAmt(Calculated_Named_Field)

Is probably going to return only a true or false value. True if the two
statements are equal to each other, and false if they aren't.

Let me know if you have any more questions,

Thaddeus

-----Original Message-----
From: Lee Ingalls [mailto:eli3@...]
Sent: Wednesday, June 13, 2001 10:51 AM
To: 'Vantage
Subject: [Vantage] Report Builder Question

It must be the oppressive heat and too large a lunch, but I'm drawing a
blank on creating an aggregate sub-total field of a calculated field based
upon Part Class. What I'm attempting is a weekly snap shot of Purchasing
Costs...
drawing my information from:
PODetail
POHeader
PORel
Vendor

I'm calculating Order_Line_Amount with the expression
PODetail.UnitCost * PODetail.OrderQty = OrdLnAmt(Calculated_Named_Field)

This I can aggregate easily for a Total Purchase Amount for the given date
range... what I would now like to do is sub-total based upon PODetail.Class
so that I can see Total Purchase Amounts for my purchases classified as
RESN, MAIN, PKG,SHOP, etc...

If anyone has a clue I could use a few! ;)

Thanks in advance, Lee

E. Lee Ingalls III
Commercial Tool & Die Inc.
(p)616.785.8100 (f)616.785.8120
eli3@...
Fortitudine Vincimus: "by Endurance we conquer."

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/

Set up a group on the customer field. Create an aggregate field that is the
'maximum' orderdate. Insert a customer group footer band line. Insert the
customer name and the MaxDate field. Suppress the record lines.

-----Original Message-----
From: De Anna Godfrey [mailto:dgodfrey@...]
Sent: Thursday, July 05, 2001 4:12 PM
To: Vantage
Subject: [Vantage] Report Builder Question

I would like the date of the last sale to print on a report builder report.

I am trying to create a customer report that tells me the last time they
placed an order.

I know how to get it to give me all the dates, I just don't know how to
limit it to only the last date.

Thanks,

De Anna Godfrey
McNeal Ent.

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/

Make sure your max field resets every cutomer (assuming you've got multiple
customers on this report).
-----Original Message-----
From:
sentto-20369-22157-994364106-jhellebuyck=stremel.com@...
[mailto:sentto-20369-22157-994364106-jhellebuyck=stremel.com@...
.com]On Behalf Of sarah.vareschi@...
Sent: Thursday, July 05, 2001 3:20 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report Builder Question

Set up a group on the customer field. Create an aggregate field that is
the
'maximum' orderdate. Insert a customer group footer band line. Insert
the
customer name and the MaxDate field. Suppress the record lines.

-----Original Message-----
From: De Anna Godfrey [mailto:dgodfrey@...]
Sent: Thursday, July 05, 2001 4:12 PM
To: Vantage
Subject: [Vantage] Report Builder Question

I would like the date of the last sale to print on a report builder
report.

I am trying to create a customer report that tells me the last time they
placed an order.

I know how to get it to give me all the dates, I just don't know how to
limit it to only the last date.

Thanks,

De Anna Godfrey
McNeal Ent.

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/

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

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

Sarah

Thanks that worked for this report. I am trying to take it a step further.
I want to show the corresponding data to the date of the last sale. For
example, the qty, the whse, the bin, etc. I put those fields in the
customer group footer but I do not get the corresponding data.

Thanks,

De Anna

Message: 9
Date: Thu, 5 Jul 2001 16:19:49 -0400
From: sarah.vareschi@...
Subject: RE: Report Builder Question

Set up a group on the customer field. Create an aggregate field that is the
'maximum' orderdate. Insert a customer group footer band line. Insert the
customer name and the MaxDate field. Suppress the record lines.

-----Original Message-----
From: De Anna Godfrey [mailto:dgodfrey@...]
Sent: Thursday, July 05, 2001 4:12 PM
To: Vantage
Subject: [Vantage] Report Builder Question

I would like the date of the last sale to print on a report builder report.

I am trying to create a customer report that tells me the last time they
placed an order.

I know how to get it to give me all the dates, I just don't know how to
limit it to only the last date.

Thanks,

De Anna Godfrey
McNeal Ent.

I'm guessing that you're already grouping by customer.
Within the customer group, you'll want to group by order date, in descending
order.
you'll want to conditionally suppress the record line bassed on the formula

previous(customer.custnum) = customer.custnum

set it to print the line only when this statement is false.

this way, the first date record (the most recent) prints first, and all the
others are suppressed.

Best Regards,

Thaddeus Jacobs
Assistant LAN Technologist / Vantage Support
Kinematic Automation, Inc
mailto:tjacobs@...

-----Original Message-----
From: De Anna Godfrey [mailto:dgodfrey@...]
Sent: Thursday, July 05, 2001 3:12 PM
To: Vantage
Subject: [Vantage] Report Builder Question

I would like the date of the last sale to print on a report builder report.

I am trying to create a customer report that tells me the last time they
placed an order.

I know how to get it to give me all the dates, I just don't know how to
limit it to only the last date.

Thanks,

De Anna Godfrey
McNeal Ent.

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/

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/

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]

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]

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

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

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]

Here's one of quite a few ways....

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]

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

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.

Sincerely,
Judy Havlik
Plitek, L.L.C.
e-mail: judy.havlik@...

Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=232673.2253070.3709326.1774049/D=egroupweb/S=17050071
83:HM/A=1194123/R=0/*http://www.adinsdirect.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/.
<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]

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

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

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

I used the following once in a letter to specific customer contacts (Buyers & Engineers) and it worked pretty well:

IIF(CntName-Space > 0, INITIAL-CAPS(SUBSTRING(CustCnt.Name,1,CntName-Space - 1)) + ',',
INITIAL-CAPS(CustCnt.Name) + ',')

where CntName-Space = INDEX(CustCnt.Name,' ',1)

(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

Yahoo! Groups Sponsor

ADVERTISEMENT
<http://rd.yahoo.com/M=246920.2960106.4328965.2848452/D=egroupweb/S=1705007183:HM/A=1481646/R=0/*http://www.gotomypc.com/u/tr/yh/cpm/grp/300_flake/g22lp?Target=mm/g22lp.tmpl>
<http://us.adserver.yahoo.com/l?M=246920.2960106.4328965.2848452/D=egroupmail/S=:HM/A=1481646/rand=923072251>

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]

Aha, that's much more elegant!
-Todd

-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Friday, March 14, 2003 9:29 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report Builder Question

Someone on the group answered this for me recently:

ENTRY(1,fieldname," ")

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

Yahoo! Groups Sponsor

ADVERTISEMENT
<http://rd.yahoo.com/M=246920.2960106.4328965.2848452/D=egroupweb/S=1705007183:HM/A=1481558/R=0/*http://www.gotomypc.com/u/tr/yh/cpm/grp/300_DIR/g22lp?Target=mm/g22lp.tmpl>
<http://us.adserver.yahoo.com/l?M=246920.2960106.4328965.2848452/D=egroupmail/S=:HM/A=1481558/rand=668818240>

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]

Thanks everyone, that worked great. TGIF

Have a good weekend.

Darren

-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Friday, March 14, 2003 9:31 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report Builder Question

Aha, that's much more elegant!
-Todd

-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Friday, March 14, 2003 9:29 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report Builder Question

Someone on the group answered this for me recently:

ENTRY(1,fieldname," ")

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

Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=246920.2960106.4328965.2848452/D=egroupweb/S=17050071
83:HM/A=1481558/R=0/*http://www.gotomypc.com/u/tr/yh/cpm/grp/300_DIR/g22lp?T
arget=mm/g22lp.tmpl>

<http://us.adserver.yahoo.com/l?M=246920.2960106.4328965.2848452/D=egroupmai
l/S=:HM/A=1481558/rand=668818240>

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

-----Original Message-----
From: Erica Steffens (IS) [mailto:ESteffens@...]
Sent: Monday, April 07, 2003 2:41 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Report Builder Question

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?

Erica A. Steffens

Business Systems Analyst

Synovis IS/PE/Caribe

ESteffens@... <mailto:ESteffens@...>

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

Yahoo! Groups Sponsor
<http://rd.yahoo.com/M=249981.3083817.4456279.1728375/D=egroupweb/S=1705007183:HM/A=1524435/R=0/*http://webmllc.tempdomainname.com/ais_lp/ais_index_yacan.php?bann=get300x250&area=CLUBEDIR&site=YaCan&camp=atestNtest>
<http://us.adserver.yahoo.com/l?M=249981.3083817.4456279.1728375/D=egroupmail/S=:HM/A=1524435/rand=230697248>

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]

This is recorded in the ReportBuilderSaveList section of Vantage.ini. Not sure, but could you maybe prohibit users from writing to this file and only allow you to write? Of course then when they open they will see your last library instead.
-Todd C.

-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Thursday, October 30, 2003 3:16 PM
To: Vantage Groups (E-mail)
Subject: [Vantage] Report Builder Question

In Report Builder, when I open a report, it defaults to the last library used by somebody in the company. I would like it to default to the last library that I used. Does anybody know why it does that and how to get around it?

Thanks,
Jasper

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

Yahoo! Groups Sponsor
<http://rd.yahoo.com/M=259395.3614674.4902533.1261774/D=egroupweb/S=1705007183:HM/A=1524963/R=0/SIG=12o885gmo/*http://hits.411web.com/cgi-bin/autoredir?camp=556&lineid=3614674&prop=egroupweb&pos=HM>
<http://us.adserver.yahoo.com/l?M=259395.3614674.4902533.1261774/D=egroupmail/S=:HM/A=1524963/rand=296703220>

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]

for all users of Report Builder, save a copy of the Vantage.INI file on the
home directory. In our case it's H:, so each user that uses Report Builder
has a H:\Vantage.ini file. Now edit the vtg file so that the
IniFile=V:\VANTAGE\Vantage.ini reads IniFile=H:\Vantage.ini. Now each user
will start report builder using their last library.

Another thing you can do is have an API call to write to the Vantage.ini and
set then ReportBuilderSaveList to what ever you want, then launch RB.

-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Thursday, October 30, 2003 3:22 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report Builder Question

This is recorded in the ReportBuilderSaveList section of Vantage.ini. Not
sure, but could you maybe prohibit users from writing to this file and only
allow you to write? Of course then when they open they will see your last
library instead.
-Todd C.

-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Thursday, October 30, 2003 3:16 PM
To: Vantage Groups (E-mail)
Subject: [Vantage] Report Builder Question

In Report Builder, when I open a report, it defaults to the last library
used by somebody in the company. I would like it to default to the last
library that I used. Does anybody know why it does that and how to get
around it?

Thanks,
Jasper

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

Yahoo! Groups Sponsor

<http://rd.yahoo.com/M=259395.3614674.4902533.1261774/D=egroupweb/S=17050071
83:HM/A=1524963/R=0/SIG=12o885gmo/*http://hits.411web.com/cgi-bin/autoredir?
camp=556&lineid=3614674&prop=egroupweb&pos=HM>

<http://us.adserver.yahoo.com/l?M=259395.3614674.4902533.1261774/D=egroupmai
l/S=:HM/A=1524963/rand=296703220>

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/

You could create your own .vtg (ReportBuilder2.vtg) and point it at
another .ini file (vantage2.ini).

Jim

-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Thursday, October 30, 2003 3:22 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report Builder Question

This is recorded in the ReportBuilderSaveList section of Vantage.ini.
Not sure, but could you maybe prohibit users from writing to this file
and only allow you to write? Of course then when they open they will
see your last library instead.
-Todd C.

-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Thursday, October 30, 2003 3:16 PM
To: Vantage Groups (E-mail)
Subject: [Vantage] Report Builder Question

In Report Builder, when I open a report, it defaults to the last library
used by somebody in the company. I would like it to default to the last
library that I used. Does anybody know why it does that and how to get
around it?

Thanks,
Jasper

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

Yahoo! Groups Sponsor

<http://rd.yahoo.com/M=259395.3614674.4902533.1261774/D=egroupweb/S=1705
007183:HM/A=1524963/R=0/SIG=12o885gmo/*http://hits.411web.com/cgi-bin/au
toredir?camp=556&lineid=3614674&prop=egroupweb&pos=HM>

<http://us.adserver.yahoo.com/l?M=259395.3614674.4902533.1261774/D=egrou
pmail/S=:HM/A=1524963/rand=296703220>

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/

If Truncate(A,0) = A, Where A = number/2, then number is an even integer.

David Kaufman
CNC Metal Products
Wooster OH

> -----Original Message-----
> From: Shirley Graver [SMTP:shirleyg@...]
> Sent: Friday, November 07, 2003 2:09 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Report Builder Question
>
> Does anyone have a way to identify whether a number is ODD or EVEN. I
> want to simulate green bar on a report for readability, every other line
> grey?
>
> Shirley Graver
> Sys Admin
> Rubber Associates
>
> Tracking #: F94EFCD9A394C447A58C98990BD3C49B27CE1FB9
>
>
> [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/
>
>

Try dividing by 2 to determine Odd or even. If it's an integer then it's even.

Just a thought
Jasper

-----Original Message-----
From: Shirley Graver [mailto:shirleyg@...]
Sent: Friday, November 07, 2003 2:09 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder Question

Does anyone have a way to identify whether a number is ODD or EVEN. I
want to simulate green bar on a report for readability, every other line
grey?

Shirley Graver
Sys Admin
Rubber Associates

Tracking #: F94EFCD9A394C447A58C98990BD3C49B27CE1FB9

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

Thanks David :}

Shirley

-----Original Message-----
From: David Kaufman [mailto:DKaufman@...]
Sent: Friday, November 07, 2003 2:10 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report Builder Question

If Truncate(A,0) = A, Where A = number/2, then number is an even
integer.

David Kaufman
CNC Metal Products
Wooster OH

> -----Original Message-----
> From: Shirley Graver [SMTP:shirleyg@...]
> Sent: Friday, November 07, 2003 2:09 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Report Builder Question
>
> Does anyone have a way to identify whether a number is ODD or EVEN.

> want to simulate green bar on a report for readability, every other

line

> grey?
>
> Shirley Graver
> Sys Admin
> Rubber Associates
>
> Tracking #: F94EFCD9A394C447A58C98990BD3C49B27CE1FB9
>
>
> [Non-text portions of this message have been removed]
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must

have already linked your email address to a yahoo id to enable access. )

> (1) To access the Files Section of our Yahoo!Group for Report Builder

and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>

> (2) To search through old msg's goto:

http://groups.yahoo.com/group/vantage/messages

> (3) To view links to Vendors that provide Vantage services goto:

http://groups.yahoo.com/group/vantage/links

>
> Your use of Yahoo! Groups is subject to

http://docs.yahoo.com/info/terms/

>
>

Thanks Folks,
Davids formula works perfectly.

Shirley

-----Original Message-----
From: Shirley Graver [mailto:shirleyg@...]
Sent: Friday, November 07, 2003 2:16 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report Builder Question

Thanks David :}

Shirley

-----Original Message-----
From: David Kaufman [mailto:DKaufman@...]
Sent: Friday, November 07, 2003 2:10 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report Builder Question

If Truncate(A,0) = A, Where A = number/2, then number is an even
integer.

David Kaufman
CNC Metal Products
Wooster OH

> -----Original Message-----
> From: Shirley Graver [SMTP:shirleyg@...]
> Sent: Friday, November 07, 2003 2:09 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Report Builder Question
>
> Does anyone have a way to identify whether a number is ODD or EVEN.

> want to simulate green bar on a report for readability, every other

line

> grey?
>
> Shirley Graver
> Sys Admin
> Rubber Associates
>
> Tracking #: F94EFCD9A394C447A58C98990BD3C49B27CE1FB9
>
>
> [Non-text portions of this message have been removed]
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must

have already linked your email address to a yahoo id to enable access. )

> (1) To access the Files Section of our Yahoo!Group for Report Builder

and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
<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/

>
>

Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=258297.4155337.5363526.4049145/D=egroupweb/S=1705
007183:HM/A=1701023/R=0/SIG=11ki6ck50/*http:/www.techsmith.com/rdr/ban/c
syah/default.asp> click here

<http://us.adserver.yahoo.com/l?M=258297.4155337.5363526.4049145/D=egrou
pmail/S=:HM/A=1701023/rand=741662653>

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

Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.

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

Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=267637.4116730.5333196.1261774/D=egroupweb/S=1705
007183:HM/A=1853618/R=0/SIG=11ts59qjv/*http:/www.netflix.com/Default?mqs
o=60178338&partid=4116730> click here

<http://us.adserver.yahoo.com/l?M=267637.4116730.5333196.1261774/D=egrou
pmail/S=:HM/A=1853618/rand=549403375>

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

Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.

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

Filter on InvDate using INLIST 01/01/2003,12/31/2003 or whatever range
works.

Patrick

-----Original Message-----
From: Robert Rodriguez [mailto:robert@...]
Sent: Thursday, December 04, 2003 10:07 AM
To: VISTA@...; vantage@yahoogroups.com
Subject: [Vantage] Report Builder Question

I need to create a Report Builder report to track invoices within a date
range. I have create the report to display the raw data, but I do not know
how to create the start date end start option for the report. Any ideas?

Robert Rodriguez, Asst. General Manager
Livonia Tool & Laser
936 Anderson Road
Litchfield, MI 49252-9600
Phone: 888-875-0833
Fax: 517-542-2427
http://www.livoniatool.com
Email: robert@...

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

------------------------ Yahoo! Groups Sponsor ---------------------~--> Buy
Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark Printer
at MyInks.com. Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/PhFolB/TM
---------------------------------------------------------------------~->

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/

Filter by the report by invoice Date

Invoice Date >= 01/01/03
and Invoice Date <= 01/31/2003

This gives you your range that you need.

Cheryl

-----Original Message-----
From: Robert Rodriguez [mailto:robert@...]
Sent: Thursday, December 04, 2003 11:07 AM
To: VISTA@...; vantage@yahoogroups.com
Subject: [Vantage] Report Builder Question

I need to create a Report Builder report to track invoices within a date
range. I have create the report to display the raw data, but I do not know
how to create the start date end start option for the report. Any ideas?

Robert Rodriguez, Asst. General Manager
Livonia Tool & Laser
936 Anderson Road
Litchfield, MI 49252-9600
Phone: 888-875-0833
Fax: 517-542-2427
http://www.livoniatool.com
Email: robert@...

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

Yahoo! Groups Sponsor

ADVERTISEMENT
<http://rd.yahoo.com/SIG=12cjsdq63/M=267637.4116732.5333197.1261774/D=egroupweb/S=1705007183:HM/EXP=1070640411/A=1853619/R=0/*http://www.netflix.com/Default?mqso=60178356&partid=4116732> click here
<http://us.adserver.yahoo.com/l?M=267637.4116732.5333197.1261774/D=egroupmail/S=:HM/A=1853619/rand=613936826>

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 have never calculated any two fields in Report Builder. I could use any
advice with calculating fields. For example, I created an open order sheet
in crystal reports that tracks Order, Customer, Part, onhandqty, qtyordered
and two formula fields to come up with the qty shipped and qty remaining. I
cannot seem to find a way to get Report Builder to calculate
{OrderRel.OurJobShippedQty}+{OrderRel.OurStockShippedQty)=Shippedqty

HELP!

Robert Rodriguez, Asst. General Manager
Livonia Tool & Laser
936 Anderson Road
Litchfield, MI 49252-9600
Phone: 888-875-0833
Fax: 517-542-2427
http://www.livoniatool.com <http://www.livoniatool.com/>
Email: robert@...

-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Tuesday, December 09, 2003 3:29 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report Builder Question

What is the calculated field you have that is giving you the error? (report
builder tend to be very picky, need spaces between symbols, etc., so it
would help if you sent the formula as you have it)

Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/SIG=12cc91q62/M=267637.4116730.5333196.1261774/D=egroup
web/S=1705007183:HM/EXP=1071088127/A=1853618/R=0/*http://www.netflix.com/Def
ault?mqso=60178338&partid=4116730> click here

<http://us.adserver.yahoo.com/l?M=267637.4116730.5333196.1261774/D=egroupmai
l/S=:HM/A=1853618/rand=287384730>

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]

Sarah,

THANK YOU!

Robert Rodriguez, Asst. General Manager
Livonia Tool & Laser
936 Anderson Road
Litchfield, MI 49252-9600
Phone: 888-875-0833
Fax: 517-542-2427
http://www.livoniatool.com <http://www.livoniatool.com/>
Email: robert@...

-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Tuesday, December 09, 2003 4:01 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report Builder Question

In your report builder report - go to the top menu and go to 'calculations'
-> 'calculated field'. Click 'New'. At the top, enter a name for the
field. i.e. Total$. In the expression portion, enter your calculation, i.e.
Field1 + field2. Then click 'ok'. Then add your new field to your report.

Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/SIG=12cccb7c6/M=267637.4116732.5333197.1261774/D=egroup
web/S=1705007183:HM/EXP=1071089994/A=1853618/R=0/*http://www.netflix.com/Def
ault?mqso=60178338&partid=4116732> click here

<http://us.adserver.yahoo.com/l?M=267637.4116732.5333197.1261774/D=egroupmai
l/S=:HM/A=1853618/rand=379315865>

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 have a report that uses the RcvDetail table. I'll send a copy off list.
-Todd C.

-----Original Message-----
From: Todd Hofert [mailto:todd@...]
Sent: Thursday, January 22, 2004 10:27 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder Question

I have a report for Vendor Performance. I need to evaluate the number of
receipts per vendor vs. the number of on time receipts for that vendor
to arrive at an on time percentage. How do I count the receipts for a
vendor? How do I count on time receipts?

Thanks in advance

Todd Hofert

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

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

Yahoo! Groups Sponsor

ADVERTISEMENT
<http://rd.yahoo.com/SIG=12cekjl4f/M=267637.4116730.5333196.1261774/D=egroupweb/S=1705007183:HM/EXP=1074875295/A=1945638/R=0/*http://www.netflix.com/Default?mqso=60178383&partid=4116730> click here
<http://us.adserver.yahoo.com/l?M=267637.4116730.5333196.1261774/D=egroupmail/S=:HM/A=1945638/rand=339961671>

_____

Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .

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

Number of receipts per vendor would be counting the RecDtl records for a
vendor for a time period.
Ontime is RecDtl.ReceiptDate <= POREL.PromiseDt.
Example: OntimeCounter IIF(RecDtl.ReceiptDate <=
POREL.PromiseDt,1,0)
Then add up the number of ontime receipts.

Patrick Winter

-----Original Message-----
From: Todd Hofert [mailto:todd@...]
Sent: Thursday, January 22, 2004 10:27 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder Question

I have a report for Vendor Performance. I need to evaluate the number of
receipts per vendor vs. the number of on time receipts for that vendor to
arrive at an on time percentage. How do I count the receipts for a vendor?
How do I count on time receipts?

Thanks in advance

Todd Hofert

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

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

------------------------ Yahoo! Groups Sponsor ---------------------~--> Buy
Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark Printer
at MyInks.com. Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/PhFolB/TM
---------------------------------------------------------------------~->

Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

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

I am trying to create a report to show all (open and closed) purchase
orders for a specific part class between the date of 1/1/04 and
5/31/04. It will not recognize the closed orders. I tried putting
in a filter to look at only closed orders (POHdr OpenOrder = no) or
closed lines (PODtl OpenLine = no) or only closed release lines
(PORel OpenRelease = no) but then I ge a "no records found" error.
But I know I have lots of closed orders. Could somebody PLEASE tell
me what I am doing wrong. I have the following joins:

POHdr to PODtl Company and PONum;
PODtl to PORel Company, PONum and POLine;
PORel to PartDtl Company, PONum and POLine; and
PartDtl to Part Company and PartNum

And the following Filters:

POHdr PODate in range 01/01/04,05/31/04
PartClass = "rwsh"

As long as I have those filters I get all open PO's. When I try to
narrow it down to just closed orders I get nothing. If anyone is
will and has time to look at this I could send the file. I am
getting desparate and very frustrated! Any help would be greatly
appreciated.

Joan Farver
Vantage Plastics

Sorry about late stab at this. Just got back in office and am wading thru hundreds of emails but did not notice a prior reply on your question.

I have a hunch PartDtl gets deleted when the purchase order is closed. Try an outer join on that table so that fields from it get reported as unknown but at least you will get the other data. Link to Part via some other means (if possible, perhaps via Job Header?).
-Todd C.

-----Original Message-----
From: joanfarver [mailto:joan.farver@...]
Sent: Tuesday, June 15, 2004 1:48 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder Question

I am trying to create a report to show all (open and closed) purchase
orders for a specific part class between the date of 1/1/04 and
5/31/04. It will not recognize the closed orders. I tried putting
in a filter to look at only closed orders (POHdr OpenOrder = no) or
closed lines (PODtl OpenLine = no) or only closed release lines
(PORel OpenRelease = no) but then I ge a "no records found" error.
But I know I have lots of closed orders. Could somebody PLEASE tell
me what I am doing wrong. I have the following joins:

POHdr to PODtl Company and PONum;
PODtl to PORel Company, PONum and POLine;
PORel to PartDtl Company, PONum and POLine; and
PartDtl to Part Company and PartNum

And the following Filters:

POHdr PODate in range 01/01/04,05/31/04
PartClass = "rwsh"

As long as I have those filters I get all open PO's. When I try to
narrow it down to just closed orders I get nothing. If anyone is
will and has time to look at this I could send the file. I am
getting desparate and very frustrated! Any help would be greatly
appreciated.

Joan Farver
Vantage Plastics

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

Yahoo! Groups Sponsor

ADVERTISEMENT
<http://us.ard.yahoo.com/SIG=129gu93n0/M=298184.5022502.6152625.3001176/D=groups/S=1705007183:HM/EXP=1087411726/A=2164330/R=0/SIG=11eamf8g4/*http://www.netflix.com/Default?mqso=60183350> click here
<http://us.adserver.yahoo.com/l?M=298184.5022502.6152625.3001176/D=groups/S=:HM/A=2164330/rand=233341048>

_____

Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .

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

Yes, I think the formulas all print in the report specification report. Go to Report - Print and in the drop down select the Report Sprcification. The formulas are in there.
-Todd C.

-----Original Message-----
From: Sandy Morse [mailto:smorse@...]
Sent: Tuesday, March 08, 2005 9:39 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder Question

I would like to print the calculations from a report builder program
without doing print screens of each one. Is there a way to print the
actual code behind the report? TIA

Sandy Morse
BVR Technologies Company
815-874-2471 x112

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

Yahoo! Groups Sponsor

ADVERTISEMENT
<http://us.ard.yahoo.com/SIG=129fl1p2b/M=298184.6018725.7038619.3001176/D=groups/S=1705007183:HM/EXP=1110382827/A=2593423/R=0/SIG=11el9gslf/*http://www.netflix.com/Default?mqso=60190075> click here
<http://us.adserver.yahoo.com/l?M=298184.6018725.7038619.3001176/D=groups/S=:HM/A=2593423/rand=808292255>

_____

Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .

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

Judy....you may have already looked at this but if you go to
report-print then look at the pages section. I had a user change this
and it saved with the report.

Matt

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Judy Havlik
Sent: Monday, March 06, 2006 10:49 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder Question

I've never experienced this before. One of our tech's modified an
existing Report Builder report. Now, the report will only print one
page, even though the report should be several pages long. No matter
what we do, only one page will print.

Does anyone have any suggestions?

Sincerely,
Judy Havlik
Plitek, L.L.C.
judy.havlik@...
847-827-6680 x223

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

SPONSORED LINKS

Manufacturing software
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Database
+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA>

Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ>

Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Data
base+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A>

Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Database+
marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg>

Database management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw>

Database marketing software
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manu
facturing+software&w2=Membership+database+software&w3=Database+mortgage+
software&w4=Pda+database+software&w5=Database+management+software&w6=Dat
abase+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw>

________________________________

YAHOO! GROUPS LINKS

* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .

________________________________

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

Dear Matt...

You saved me a great deal of time and aggrevation over this. Thanks
so much! I would have never looked there.

Sincerely,
Judy Havlik

--- In vantage@yahoogroups.com, "MATT FINN" <matt@...> wrote:
>
> Judy....you may have already looked at this but if you go to
> report-print then look at the pages section. I had a user change
this
> and it saved with the report.
>
>
>
> Matt
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of Judy Havlik
> Sent: Monday, March 06, 2006 10:49 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Report Builder Question
>
>
>
> I've never experienced this before. One of our tech's modified an
> existing Report Builder report. Now, the report will only print
one
> page, even though the report should be several pages long. No
matter
> what we do, only one page will print.
>
> Does anyone have any suggestions?
>
> Sincerely,
> Judy Havlik
> Plitek, L.L.C.
> judy.havlik@...
> 847-827-6680 x223
>
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must
> have already linked your email address to a yahoo id to enable
access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> <http://groups.yahoo.com/group/vantage/files/>
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
>
>
>
>
> SPONSORED LINKS
>
> Manufacturing software
> <http://groups.yahoo.com/gads?
t=ms&k=Manufacturing+software&w1=Manufactu
>
ring+software&w2=Membership+database+software&w3=Database+mortgage+sof
tw
>
are&w4=Pda+database+software&w5=Database+management+software&w6=Databa
se
> +marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA>
>
> Membership database software
> <http://groups.yahoo.com/gads?
t=ms&k=Membership+database+software&w1=Man
>
ufacturing+software&w2=Membership+database+software&w3=Database+mortga
ge
>
+software&w4=Pda+database+software&w5=Database+management+software&w6=
Da
> tabase+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ>
>
> Database mortgage software
> <http://groups.yahoo.com/gads?
t=ms&k=Database+mortgage+software&w1=Manuf
>
acturing+software&w2=Membership+database+software&w3=Database+mortgage
+s
>
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Da
ta
> base+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A>
>
> Pda database software
> <http://groups.yahoo.com/gads?
t=ms&k=Pda+database+software&w1=Manufactur
>
ing+software&w2=Membership+database+software&w3=Database+mortgage+soft
wa
>
re&w4=Pda+database+software&w5=Database+management+software&w6=Databas
e+
> marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg>
>
> Database management software
> <http://groups.yahoo.com/gads?
t=ms&k=Database+management+software&w1=Man
>
ufacturing+software&w2=Membership+database+software&w3=Database+mortga
ge
>
+software&w4=Pda+database+software&w5=Database+management+software&w6=
Da
> tabase+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw>
>
> Database marketing software
> <http://groups.yahoo.com/gads?
t=ms&k=Database+marketing+software&w1=Manu
>
facturing+software&w2=Membership+database+software&w3=Database+mortgag
e+
>
software&w4=Pda+database+software&w5=Database+management+software&w6=D
at
> abase+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw>
>
>
>
> ________________________________
>
> YAHOO! GROUPS LINKS
>
>
>
> * Visit your group "vantage
> <http://groups.yahoo.com/group/vantage> " on the web.
>
> * To unsubscribe from this group, send an email to:
> vantage-unsubscribe@yahoogroups.com
> <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/> .
>
>
>
> ________________________________
>
>
>
> [Non-text portions of this message have been removed]
>

Judy,

I've encountered this when I save the reports as generic text files. You
may want to try opening the report in Report Builder, go to Print, and then
change the page selection from 1 to 9999999 to 1 to 50 (or however many
number of pages may be appropriate).

Rebecca
P-K Tool

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Judy Havlik
Sent: Monday, March 06, 2006 10:49 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder Question

I've never experienced this before. One of our tech's modified an existing
Report Builder report. Now, the report will only print one page, even
though the report should be several pages long. No matter what we do, only
one page will print.

Does anyone have any suggestions?

Sincerely,
Judy Havlik
Plitek, L.L.C.
judy.havlik@...
847-827-6680 x223

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

There is a .prl file in the FILES section of the Vantage Yahoo Groups called
HOURLY HOURS that has a selection of RB reports that you should be able to
modifiy.

Shirley Graver
Rubber Associates.

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
rfc822 Compliance issue From: added by system POTENTIAL SPAM
Sent: Thursday, March 30, 2006 4:32 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder Question

We are currnetly on version 6.1 We use Data Collection, but do not have
the payroll module.
We do use data collection. We use a Report Builder report to total
hours worked in a date range, and key those totals into another payroll
package.
We offer flexible scheduling at one of our plant locations, and cut off
time at 10 am on Fridays that is then credited to another pay period.
Does anyone have a report they would be willing to share that would
total hours for the week, but cut them off at a certain time on the
fifth day?

Thanks in advance!

Jerry

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

_____

YAHOO! GROUPS LINKS

* Visit your group "vantage <http://groups.yahoo.com/group/vantage> "
on the web.

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .

_____

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

I have a crystal report for 5.2 looking a two week pay period based on a
requested pay date. It calculates Reg, OT (after 40hrs a wk), Vac, Sic and
Hol. You can have it if you would like.

David

> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
> Of jerrygeb1
> Sent: Thursday, March 30, 2006 3:31 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Report Builder Question
>
>
> We are currnetly on version 6.1 We use Data Collection, but do not have
> the payroll module.
> We do use data collection. We use a Report Builder report to total
> hours worked in a date range, and key those totals into another payroll
> package.
> We offer flexible scheduling at one of our plant locations, and cut off
> time at 10 am on Fridays that is then credited to another pay period.
> Does anyone have a report they would be willing to share that would
> total hours for the week, but cut them off at a certain time on the
> fifth day?
>
> Thanks in advance!
>
> Jerry
>
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> must have already linked your email address to a yahoo id to
> enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report
> Builder and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
> Yahoo! Groups Links
>
>
>
>
>
>
>
>

Dick,
Check Properties/Record Layout.
Good luck,
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of PLAMAN DICK
Sent: Wednesday, April 12, 2006 8:35 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder Question

Does anyone know how to reformat data across rather than down?
10 WrkCtr1
20 WrkCtr2
30 WrkCtr3

I would like to print them on one record line.

TIA

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

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