Report Builder Date

>wonder if I could rig up email here to have an automatic
>compile & return service? Email your source to a specific address, and
>have it compile and fire back a .R file?!

Actually, check out the outlook programmers reference, if you are using
outlook. There's lots of fun stuff in there. You can trap the recievemail,
search the subject for a particular phrase, and if that phrase is found,
copy the text of the body of the message, launch provision's compiler, and
spit the .r file back in an attachement. You can do it within Outlook 2000
itself, using the visual basic built in. However, you could use a 4GL (or
VB, or c++) program as well, and communicate with outlook via its API. Or
you could use MAPI calls instead, bypassing outlook altogether......

I know you probably weren't serious about this particular application, but
there are many other instances where automated e-mail response can speed
things up. In one application, a work at home engineer sends us a request
saying SENDMEDATASHEET 31-000253, and the appropriate pdf file is located
and attached to the e-mail and sent to the engineer. Pretty fun
stuff..........


-----Original Message-----
From: Wayne Cox [mailto:wmc@...]
Sent: Monday, August 06, 2001 9:29 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Report Builder Date


At 11:46 PM 8/6/2001 +0000, you wrote:
>Here's an idea.. Small Progress program, scheduled with AT command
>for evenings, that updates the selected user field of all NEW jobs
>with current date. You don't need ProVision or a so-called 'write
license'.

Good Idea. I've though of doing something similar with the Memo table to
have an indexed INTEGER copy of "Key1" so Report Builder could work with
it.

But you *would* need ProVision to compile it. Shot me code & I can burn it
for ya'. Hmm... wonder if I could rig up email here to have an automatic
compile & return service? Email your source to a specific address, and
have it compile and fire back a .R file?!

-Wayne




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 there a way to filter a report by using a "created" date. Example, I
enter a number of "Jobs" with an Order Date's 3rd-6th, Aug. 2001. But I
entered them all on the 6th and I want generate a report of all the "Jobs" I
entered on the 6th. Is there a "date stamp" in Vantage 4or5 that I can use
as a filter?

Clear as Mud, right.

Jim Horton
Mol-Son, Inc.
The BookDtl table has this info for Sales Orders. Link the Sales order to
the BookDtl table and filter on the BookDate.

------------------------------
Sarah Vareschi
NyproMold, Inc.
sarah.vareschi@...



-----Original Message-----
From: Jim Horton [mailto:Vantage@...]
Sent: Monday, August 06, 2001 3:46 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Report Builder Date


Is there a way to filter a report by using a "created" date. Example, I
enter a number of "Jobs" with an Order Date's 3rd-6th, Aug. 2001. But I
entered them all on the 6th and I want generate a report of all the "Jobs" I
entered on the 6th. Is there a "date stamp" in Vantage 4or5 that I can use
as a filter?

Clear as Mud, right.

Jim Horton
Mol-Son, Inc.


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/
We looked and looked and never found a job created date so we ended up
manually entering this in a user defined date field on the job header.
Having this date is critical to our process of logging daily job bookings
(as opposed to order bookings). It would also be nice from an audit trail
standpoint to be able to go back and know what day a job was created on and
by whom. Any date based on order is meaningless to us where we may have a
KanBan job with future releases with unknown dates or unknown Customer ID so
we have just the job and no order to link it to, yet. We also don't count
an order as booked until it has a job and the job's date is what counts.
We're a job shop.

It would be very nice if more of the transaction records had better audit
trail such as at least the creation date/user and the last changed
date/user. It would greatly assist in user education - find who did it
wrong and teach them how to do it right, etc..

-Todd C.

-----Original Message-----
From: Jim Horton [mailto:Vantage@...]
Sent: Monday, August 06, 2001 2:46 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Report Builder Date



Is there a way to filter a report by using a "created" date. Example, I
enter a number of "Jobs" with an Order Date's 3rd-6th, Aug. 2001. But I
entered them all on the 6th and I want generate a report of all the "Jobs" I
entered on the 6th. Is there a "date stamp" in Vantage 4or5 that I can use
as a filter?

Clear as Mud, right.

Jim Horton
Mol-Son, Inc.

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]
Actually, clear as a bell.

I couldn't find a 'date stamp' on the order side, but if you look at
BookDtl there is a BookDate field, which is the system date the
orderline created or the date of the last change to the order. Join
to BookDtl by company, ordernum, orderline.

HTH

Lonnie

--- In vantage@y..., Jim Horton <Vantage@e...> wrote:
>
> Is there a way to filter a report by using a "created" date.
Example, I
> enter a number of "Jobs" with an Order Date's 3rd-6th, Aug. 2001.
But I
> entered them all on the 6th and I want generate a report of all
the "Jobs" I
> entered on the 6th. Is there a "date stamp" in Vantage 4or5 that I
can use
> as a filter?
>
> Clear as Mud, right.
>
> Jim Horton
> Mol-Son, Inc.
Amend my last message.

You have the potential for multiple returns from the join I gave.
The BookDtl table contains a record of EACH change to OrderDtl.
You'll have to be careful using this.

Lonnie

--- In vantage@y..., "Lonnie Drew" <lonniedrew@c...> wrote:
> Actually, clear as a bell.
>
> I couldn't find a 'date stamp' on the order side, but if you look
at
> BookDtl there is a BookDate field, which is the system date the
> orderline created or the date of the last change to the order.
Join
> to BookDtl by company, ordernum, orderline.
>
> HTH
>
> Lonnie
>
> --- In vantage@y..., Jim Horton <Vantage@e...> wrote:
> >
> > Is there a way to filter a report by using a "created" date.
> Example, I
> > enter a number of "Jobs" with an Order Date's 3rd-6th, Aug.
2001.
> But I
> > entered them all on the 6th and I want generate a report of all
> the "Jobs" I
> > entered on the 6th. Is there a "date stamp" in Vantage 4or5 that
I
> can use
> > as a filter?
> >
> > Clear as Mud, right.
> >
> > Jim Horton
> > Mol-Son, Inc.
Filter the BookDtl table on type = new and you'll only get the record of the
date the order was created. If you added lines on different dates, you'll
have to take the minimum date.




-----Original Message-----
From: Lonnie Drew [mailto:lonniedrew@...]
Sent: Monday, August 06, 2001 4:12 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Report Builder Date

Amend my last message.

You have the potential for multiple returns from the join I gave.
The BookDtl table contains a record of EACH change to OrderDtl.
You'll have to be careful using this.

Lonnie

--- In vantage@y..., "Lonnie Drew" <lonniedrew@c...> wrote:
> Actually, clear as a bell.
>
> I couldn't find a 'date stamp' on the order side, but if you look
at
> BookDtl there is a BookDate field, which is the system date the
> orderline created or the date of the last change to the order.
Join
> to BookDtl by company, ordernum, orderline.
>
> HTH
>
> Lonnie
>
> --- In vantage@y..., Jim Horton <Vantage@e...> wrote:
> >
> > Is there a way to filter a report by using a "created" date.
> Example, I
> > enter a number of "Jobs" with an Order Date's 3rd-6th, Aug.
2001.
> But I
> > entered them all on the 6th and I want generate a report of all
> the "Jobs" I
> > entered on the 6th. Is there a "date stamp" in Vantage 4or5 that
I
> can use
> > as a filter?
> >
> > Clear as Mud, right.
> >
> > Jim Horton
> > Mol-Son, Inc.



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 Sarah! I've never noticed that field before- it might prove
useful to us in future.

--- In vantage@y..., sarah.vareschi@n... wrote:
> Filter the BookDtl table on type = new and you'll only get the
record of the
> date the order was created. If you added lines on different dates,
you'll
> have to take the minimum date.
>
>
>
>
> -----Original Message-----
> From: Lonnie Drew [mailto:lonniedrew@c...]
> Sent: Monday, August 06, 2001 4:12 PM
> To: vantage@y...
> Subject: [Vantage] Re: Report Builder Date
>
> Amend my last message.
>
> You have the potential for multiple returns from the join I gave.
> The BookDtl table contains a record of EACH change to OrderDtl.
> You'll have to be careful using this.
>
> Lonnie
>
> --- In vantage@y..., "Lonnie Drew" <lonniedrew@c...> wrote:
> > Actually, clear as a bell.
> >
> > I couldn't find a 'date stamp' on the order side, but if you look
> at
> > BookDtl there is a BookDate field, which is the system date the
> > orderline created or the date of the last change to the order.
> Join
> > to BookDtl by company, ordernum, orderline.
> >
> > HTH
> >
> > Lonnie
> >
> > --- In vantage@y..., Jim Horton <Vantage@e...> wrote:
> > >
> > > Is there a way to filter a report by using a "created" date.
> > Example, I
> > > enter a number of "Jobs" with an Order Date's 3rd-6th, Aug.
> 2001.
> > But I
> > > entered them all on the 6th and I want generate a report of all
> > the "Jobs" I
> > > entered on the 6th. Is there a "date stamp" in Vantage 4or5
that
> I
> > can use
> > > as a filter?
> > >
> > > Clear as Mud, right.
> > >
> > > Jim Horton
> > > Mol-Son, Inc.
>
>
>
> 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 you have Jobs setup to log changes (see Company Configuration), then you
could join JobHead with JobAudit and display the Min value for
JobAudit.ChangedDate.
======================
Steve Sanders
Delta Centrifugal Corp

-----Original Message-----
From: Jim Horton [mailto:Vantage@...]
Sent: Monday, August 06, 2001 2:46 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder Date



Is there a way to filter a report by using a "created" date. Example, I
enter a number of "Jobs" with an Order Date's 3rd-6th, Aug. 2001. But I
entered them all on the 6th and I want generate a report of all the "Jobs"
I
entered on the 6th. Is there a "date stamp" in Vantage 4or5 that I can
use
as a filter?

Clear as Mud, right.

Jim Horton
Mol-Son, Inc.

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]
Steve,
This sounds interesting but where do you set this? In the Job Management
module configuration I see a grayed out (unusable) check box for logging
engineering changes but not for just job changes. Is this the check box you
refer to and what controls whether it is available? Also will it log all
changes to a job (such as when it was created) or just engineering changes?
If this would work it would be huge for us.
Thanks,
-Todd C.

-----Original Message-----
From: Steve Sanders [mailto:ssanders@...]
Sent: Monday, August 06, 2001 4:17 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report Builder Date


If you have Jobs setup to log changes (see Company Configuration), then you
could join JobHead with JobAudit and display the Min value for
JobAudit.ChangedDate.
======================
Steve Sanders
Delta Centrifugal Corp

-----Original Message-----
From: Jim Horton [mailto:Vantage@...]
Sent: Monday, August 06, 2001 2:46 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder Date



Is there a way to filter a report by using a "created" date. Example, I
enter a number of "Jobs" with an Order Date's 3rd-6th, Aug. 2001. But I
entered them all on the 6th and I want generate a report of all the "Jobs"
I
entered on the 6th. Is there a "date stamp" in Vantage 4or5 that I can
use
as a filter?

Clear as Mud, right.

Jim Horton
Mol-Son, Inc.

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.



[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
<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]
Never mind - found I have to check 'Prevent Changes' to activate log
changes. Seems like a catch-22. Not sure yet what ramifications of
'Prevent Changes' would be for us or if we use engineered jobs. Thanks for
the lead.
-Todd C.

-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Monday, August 06, 2001 4:29 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Report Builder Date


Steve,
This sounds interesting but where do you set this? In the Job Management
module configuration I see a grayed out (unusable) check box for logging
engineering changes but not for just job changes. Is this the check box you
refer to and what controls whether it is available? Also will it log all
changes to a job (such as when it was created) or just engineering changes?
If this would work it would be huge for us.
Thanks,
-Todd C.

-----Original Message-----
From: Steve Sanders [mailto:ssanders@...]
Sent: Monday, August 06, 2001 4:17 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report Builder Date


If you have Jobs setup to log changes (see Company Configuration), then you
could join JobHead with JobAudit and display the Min value for
JobAudit.ChangedDate.
======================
Steve Sanders
Delta Centrifugal Corp

-----Original Message-----
From: Jim Horton [mailto:Vantage@...]
Sent: Monday, August 06, 2001 2:46 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder Date



Is there a way to filter a report by using a "created" date. Example, I
enter a number of "Jobs" with an Order Date's 3rd-6th, Aug. 2001. But I
entered them all on the 6th and I want generate a report of all the "Jobs"
I
entered on the 6th. Is there a "date stamp" in Vantage 4or5 that I can
use
as a filter?

Clear as Mud, right.

Jim Horton
Mol-Son, Inc.

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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[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/.
<http://groups.yahoo.com/group/vantage/files/.> >
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
< http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages> >
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>
< http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links> >

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




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


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 an idea.. Small Progress program, scheduled with AT command
for evenings, that updates the selected user field of all NEW jobs
with current date. You don't need ProVision or a so-called 'write
license'.

Lonnie

--- In vantage@y..., Todd Caughey <caugheyt@h...> wrote:
> We looked and looked and never found a job created date so we ended
up
> manually entering this in a user defined date field on the job
header.
> Having this date is critical to our process of logging daily job
bookings
> (as opposed to order bookings). It would also be nice from an
audit trail
> standpoint to be able to go back and know what day a job was
created on and
> by whom. Any date based on order is meaningless to us where we may
have a
> KanBan job with future releases with unknown dates or unknown
Customer ID so
> we have just the job and no order to link it to, yet. We also
don't count
> an order as booked until it has a job and the job's date is what
counts.
> We're a job shop.
>
> It would be very nice if more of the transaction records had better
audit
> trail such as at least the creation date/user and the last changed
> date/user. It would greatly assist in user education - find who
did it
> wrong and teach them how to do it right, etc..
>
> -Todd C.
>
> -----Original Message-----
> From: Jim Horton [mailto:Vantage@e...]
> Sent: Monday, August 06, 2001 2:46 PM
> To: 'vantage@y...'
> Subject: [Vantage] Report Builder Date
>
>
>
> Is there a way to filter a report by using a "created" date.
Example, I
> enter a number of "Jobs" with an Order Date's 3rd-6th, Aug. 2001.
But I
> entered them all on the 6th and I want generate a report of all
the "Jobs" I
> entered on the 6th. Is there a "date stamp" in Vantage 4or5 that I
can use
> as a filter?
>
> Clear as Mud, right.
>
> Jim Horton
> Mol-Son, Inc.
>
> 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]
At 11:46 PM 8/6/2001 +0000, you wrote:
>Here's an idea.. Small Progress program, scheduled with AT command
>for evenings, that updates the selected user field of all NEW jobs
>with current date. You don't need ProVision or a so-called 'write license'.

Good Idea. I've though of doing something similar with the Memo table to
have an indexed INTEGER copy of "Key1" so Report Builder could work with it.

But you *would* need ProVision to compile it. Shot me code & I can burn it
for ya'. Hmm... wonder if I could rig up email here to have an automatic
compile & return service? Email your source to a specific address, and
have it compile and fire back a .R file?!

-Wayne
I guess the debate 'to compile or not compile' will go on until
someone takes the time to post a proof. But anyway.. I just
finished a project with memos - fresh on my mind. Why do you need
an 'indexed integer copy of memo.Key1'? For example, if you're
trying to show a job's memos on a report, create a calculated field
RelatedTableVariable with value "jobhead", then join:

jobhead.company to memo.company
RelatedTableVariable to memo.RelatedToFile
jobhead.jobnum to memo.Key1

I haven't had problems with memos in our environment. What do you
mean by 'indexed integer copy of memo.Key1'?

Lonnie



--- In vantage@y..., Wayne Cox <wmc@u...> wrote:
> At 11:46 PM 8/6/2001 +0000, you wrote:
> >Here's an idea.. Small Progress program, scheduled with AT
command
> >for evenings, that updates the selected user field of all NEW jobs
> >with current date. You don't need ProVision or a so-called 'write
license'.
>
> Good Idea. I've though of doing something similar with the Memo
table to
> have an indexed INTEGER copy of "Key1" so Report Builder could
work with it.
>
> But you *would* need ProVision to compile it. Shot me code & I can
burn it
> for ya'. Hmm... wonder if I could rig up email here to have an
automatic
> compile & return service? Email your source to a specific address,
and
> have it compile and fire back a .R file?!
>
> -Wayne
Similarly, are there fields available to tell me who changed what in the Job
if we're not using the "prevent changes" setup? We can't possibly use this
b/c we're constantly adding to the BOM in the Job. Can I tell for example,
Who added material 120 to the Job and when? Thank you.

Amy T. MacKay
Parkinson Technologies
amackay@...
(p) 401-762-2100 x 324
(f) 401-762-2295

>>>>>>>>>>>>

Message: 17
Date: Mon, 6 Aug 2001 15:05:58 -0500
From: Todd Caughey <caugheyt@...>
Subject: RE: Report Builder Date

We looked and looked and never found a job created date so we ended up
manually entering this in a user defined date field on the job header.
Having this date is critical to our process of logging daily job bookings
(as opposed to order bookings). It would also be nice from an audit trail
standpoint to be able to go back and know what day a job was created on and
by whom. Any date based on order is meaningless to us where we may have a
KanBan job with future releases with unknown dates or unknown Customer ID so
we have just the job and no order to link it to, yet. We also don't count
an order as booked until it has a job and the job's date is what counts.
We're a job shop.

It would be very nice if more of the transaction records had better audit
trail such as at least the creation date/user and the last changed
date/user. It would greatly assist in user education - find who did it
wrong and teach them how to do it right, etc..

-Todd C.

-----Original Message-----
From: Jim Horton [mailto:Vantage@...]
Sent: Monday, August 06, 2001 2:46 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Report Builder Date



Is there a way to filter a report by using a "created" date. Example, I
enter a number of "Jobs" with an Order Date's 3rd-6th, Aug. 2001. But I
entered them all on the 6th and I want generate a report of all the "Jobs" I
entered on the 6th. Is there a "date stamp" in Vantage 4or5 that I can use
as a filter?

Clear as Mud, right.

Jim Horton
Mol-Son, Inc.

Amy T. MacKay
Parkinson Technologies
amackay@...
(p) 401-762-2100 x 324
(f) 401-762-2295
At 01:11 AM 8/7/2001 , you wrote:
>finished a project with memos - fresh on my mind. Why do you need
>an 'indexed integer copy of memo.Key1'? For example, if you're
>trying to show a job's memos on a report, create a calculated field

There are around 20 tables that you can attach memos to (see Memo Category
maintenance.) Some of them have a character string for the ID, but the
majority use an integer number. Either way, Vantage converts them all to
character strings when it creates the Memo record.

Report Builder doesn't have any way to join fields of dissimilar data
types. For example, it won't allow you to join OrderHed.OrderNum (integer)
to Memo.Key1 (character.) You can create a calculated field, like
String(OrderNum) but R.B. can't use that for a join. In a 4GL program, you
can convert each ID and run a separate query for each. But you're out of
luck for doing anything quick & dirty with Memos in R.B in most cases.

Anyone know if Crystal is able to do this? It choked when I tried, but
that was just a straight link, no fancy tricks.

Storing an integer key, like Memo.IntKey1 would allow us to work with Memo
in R.B. Doing a quick count, APInvHed, JobHead, Part, PREmpMas and Project
have character IDs in their home table and in Memo. But the majority of
the tables, InvcHead, QuoteHed, QuoteDtl, OrderHed, OrderDtl, OrderRel,
ShipHead, Customer, POHeader, SubShipH, DMRHead, and Vendor have their ID
keys converted to strings in Memo.

-Wayne Cox
--- In vantage@y..., Wayne Cox <wmc@u...> wrote:
>
> Report Builder doesn't have any way to join fields of dissimilar
data
> types. For example, it won't allow you to join OrderHed.OrderNum
(integer)
> to Memo.Key1 (character.) You can create a calculated field, like
> String(OrderNum) but R.B. can't use that for a join. In a 4GL
program, you
> can convert each ID and run a separate query for each. But you're
out of
> luck for doing anything quick & dirty with Memos in R.B in most
cases.
>
> Anyone know if Crystal is able to do this? It choked when I tried,
but
> that was just a straight link, no fancy tricks.

Yes, In Crystal you can join dissimilar data types - but only with
the help of a subreport (which slows things down quite a bit).
Example: To do the above example, you would use the Orderhed table
in the main report. In the main report, create a formula that
creates a string of the OrderHed.OrderNum field (i.e. ToString
(OrderHed.OrderNum).
Now create the subreport. The subreport will contain the Memo table.
From the Main report, link the "ToString formula" to the Memo.key1
field, and you should be linked together.

Now, getting the subreport data to the main report is a matter of
either:
A. Stick the subreport and it's fields in the appropriate spot in the
main report, or
B. Pass the fields in Shared Variables from the subreport to the main
report - where you can do calculations and such.

POINTS TO REMEMBER: The subreport cannot reside in the same detail or
group line that the subreports variables are used in. They have to
occur AFTER the subreport to be recognized by the main report. Put
the subreport in DETAILS A, and the variables can be used in DETAILS
B, for example.

Also, Crystal cannot group by memo fields if they are too long (ie.
PartDescription fields). If these are truncated, then you can group,
sort, etc just like any other field. Contact Epicor for details on
truncating Blob/memo fields in Progress.

Troy Funte
Liberty Electronics
I tried everything I could think of with the join to Memo - to no
avail - RB just wouldn't let me join string(orderdtl.ordernum) to
memo.key1. But there may be a work-around.

The test linked OrderDtl->Memo by:
orderdtl.company -> memo.company
"OrderDtl" -> memo.RelatedToFile

I created a calculated field
StringOrderNum = string(orderdtl.ordernum,">>>>>9")
which I placed in the filter after the orderdtl entries
Memo.Key1 = StringOrderNum.

There's more sequential searching than I would like, but all-in-all
not too slow.

Lonnie

--- In vantage@y..., Wayne Cox <wmc@u...> wrote:
> At 01:11 AM 8/7/2001 , you wrote:
> >finished a project with memos - fresh on my mind. Why do you need
> >an 'indexed integer copy of memo.Key1'? For example, if you're
> >trying to show a job's memos on a report, create a calculated
field
>
> There are around 20 tables that you can attach memos to (see Memo
Category
> maintenance.) Some of them have a character string for the ID, but
the
> majority use an integer number. Either way, Vantage converts them
all to
> character strings when it creates the Memo record.
>
> Report Builder doesn't have any way to join fields of dissimilar
data
> types. For example, it won't allow you to join OrderHed.OrderNum
(integer)
> to Memo.Key1 (character.) You can create a calculated field, like
> String(OrderNum) but R.B. can't use that for a join. In a 4GL
program, you
> can convert each ID and run a separate query for each. But you're
out of
> luck for doing anything quick & dirty with Memos in R.B in most
cases.
>
> Anyone know if Crystal is able to do this? It choked when I tried,
but
> that was just a straight link, no fancy tricks.
>
> Storing an integer key, like Memo.IntKey1 would allow us to work
with Memo
> in R.B. Doing a quick count, APInvHed, JobHead, Part, PREmpMas and
Project
> have character IDs in their home table and in Memo. But the
majority of
> the tables, InvcHead, QuoteHed, QuoteDtl, OrderHed, OrderDtl,
OrderRel,
> ShipHead, Customer, POHeader, SubShipH, DMRHead, and Vendor have
their ID
> keys converted to strings in Memo.
>
> -Wayne Cox