OrderDtl to Job Traveler - V8.03.404A

Yahoo Archive
1
OK, I finally got results using the Customization suggestion from Rob
Brown on another piece of this thread.

I used a FKV to pull Part.PartsPerContainer into ShipDtl.Number01

Then I added ShipDtl.Number01 to my Data Definitions which made it
available to put it on my CR PackingList.

It worked. It's not automatic. It will require the user to click on
my new ShipDtl.Number01 field to pull in the data during Customer
Shipment Entry because the only Vantage Wizard Event that I
understand how to use is "GotFocus".

It was a lot of work to do this customization when it would have been
a very simple task if I was using ODBC. However, with the
customization "workaround" I have avoided the maintenance issues of
ODBC drivers on dozens of user computers.

Thanks to Todd for raising this question and thanks to everyone who
replied and gave me more tools for my toolbox.

Lynn




--- In vantage@yahoogroups.com, "Scott Litzau" <scott.litzau@...>
wrote:
>
> The licensing does work that way. In Vantage there you have so many
licenses
> but in your ODBC Setup in PET you set the number of ODBC
connections the
> database can a accept (the more connection the more memory it does
utilize
> as the connection are created). I have 30 user licenses for Vantage
and then
> I have 20 available ODBC connections.
>
> So go ahead and do it by ODBC and I am sure it will work. I do this
with our
> Picking Ticket. I am able to print on the picking Ticket if the
Order is on
> Credit Hold and not just the Customer by linking back to the
Customer
> pulling information in to then main report and then determine if
the Order
> is on Credit Hold.
>
> Scott Litzau, MCP
> Olympus Flag & Banner
> Information Systems Manager
> scott.litzau@...
> P: 414-365-9732
> F: 414-355-1931
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> Lynn
> Sent: Thursday, June 26, 2008 10:06 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: OrderDtl to Job Traveler - V8.03.404A
>
> Hi Scott:
>
> It didn't work. I created the subreport and linked it to the
> container report via ShipDtl.PartNum = Part.PartNum, but I cannot
get
> the PackingList Subreport to bring in any data from the Part file
> either.
>
> I guess I'm going to have to go to the last resort and use ODBC. I
> have been extremely reluctant to do this because it is my
> understanding that when the user is using Vantage and the Progress-
CR
> ODBC, then 2 Vantage licenses are being used by the user. We will
> very quickly run out of Vantage/Progress licenses if this option
must
> be used.
>
> Thanks.
>
> Lynn
>
>
>
> --- In vantage@yahoogroups.com, "Scott Litzau" <scott.litzau@>
> wrote:
> >
> > Even though you may have added the table in the Data Definition
it
> does not
> > mean it linked when the process to create the report generates
the
> XML file.
> > So in Crystal when you link them you probably see that the Part
> Table in the
> > linking tab has no indication of Primary, 2nd, etc... indexes.
> >
> > So in Crystal create a subreport and then link to the Subreport
> Tables you
> > need. If that does not work Crystal can draw from multiple
database
> > connections at the same time. Meaning that not only can it read
the
> XML
> > generated file from Vantage it can also link to Vantage via ODBC.
> So if
> > linking the above Part table does not work when included in the
data
> > definition you can create a subreport, have it talk to Vantage
via
> ODBC,
> > link the table and fields via the subreport and you should get
back
> the data
> > you are looking for.
> >
> > But you will have to edit the registry to put the default
username
> and
> > password in the ODBC connection to Vantage. Otherwise when the
> report runs
> > it will ask the user for both.
> >
> > Scott Litzau, MCP
> > Olympus Flag & Banner
> > Information Systems Manager
> > scott.litzau@
> > P: 414-365-9732
> > F: 414-355-1931
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of
> > Lynn
> > Sent: Thursday, June 26, 2008 8:50 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re: OrderDtl to Job Traveler - V8.03.404A
> >
> > I am having what seems to be the EXACT same problem this week.
> >
> > I am on Vantage 8.03.404/Progress.
> >
> > Following the instructions in AnswerBook # 4778MPS, I added the
> Part
> > file to the canned Vantage Data Definitions for the Packing Slip
> form.
> >
> > When I am in Crystal Reports, I can link the Part file. And from
> the
> > Field Explorer, I add the Part.PartsPerContainer field to my
> > PackingSlip CR.
> >
> > When I save the CR and go back to Vantage to preview a packing
> slip,
> > at first glance the packing slip looks fine; but the field(s)
that
> I
> > am trying to pull in from the Part file do not show up.
> >
> > I have also experimented with the CR links to no avail.
> >
> > I too am wondering if there is a bug in the process.
> >
> > Lynn
> >
> >
> >
> > --- In vantage@yahoogroups.com, "Todd Hofert" <todd@> wrote:
> > >
> > > Dave,
> > >
> > >
> > >
> > > I have played with the joins to no avail. I am thinking A) I am
> not
> > > doing something in the data definition, or B) it is a Vantage
bug
> > that
> > > is not allowing me to add this table. I don't recall the
> specifics,
> > but
> > > I vaguely remember working with support on a similar issue
> > (different
> > > data definition and tables but same basic issue) and was told
it
> > was a
> > > bug. I threw the question out hoping someone knew a solution or
a
> > way
> > > around it. I think I will try the sub report route and see what
> > happens
> > > unless someone else steps up with the answer.
> > >
> > >
> > >
> > > Thanks
> > >
> > > Todd
> > >
> > >
> > >
> > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
On
> > Behalf
> > > Of Dave Olender
> > > Sent: Thursday, June 26, 2008 8:34 AM
> > > To: vantage@yahoogroups.com
> > > Subject: [Vantage] Re: OrderDtl to Job Traveler - V8.03.404A
> > >
> > >
> > >
> > > Mr. Todd: I don't know all of your details, however I can say
> that
> > at
> > > least in my case when a report comes up blank, it has always
been
> > > because I messed up one of the joins at the crystal level.
> > >
> > > Try changing the links associated with the fields to "Left
Outer".
> > >
> > > Good Luck,
> > >
> > > Dave Olender
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%
> 40yahoogroups.com> ,
> > > "Todd Hofert" <todd@> wrote:
> > > >
> > > > Last week I posted a couple of questions regarding shipping
of
> > > Overs and
> > > > Unders. Thanks to feedback from the group I have 95% of a
> > solution
> > > in
> > > > place to deal with this problem. The remaining 5% left undone
> is
> > > being
> > > > able to print the two fields; OrderDtl.Number20 and
> > > OrderDtl.Number19 on
> > > > my Job Traveler.
> > > >
> > > >
> > > >
> > > > I have copied the canned Vantage Report Data Definition and
> have
> > > been
> > > > trying to add the OrderDtl Table to that definition but have
> > failed.
> > > > When I add those fields to the Crystal Report the report goes
> > > blank. Can
> > > > anyone offer assistance in how to properly add this data to
the
> > data
> > > > definition/Crystal report?
> > > >
> > > >
> > > >
> > > > Thanks
> > > > Todd H.
> > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> > >
> > >
> > >
> > >
> > > [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/linksYahoo! Groups Links
> >
>
>
>
> ------------------------------------
>
> 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/linksYahoo! Groups Links
>
2
Last week I posted a couple of questions regarding shipping of Overs and
Unders. Thanks to feedback from the group I have 95% of a solution in
place to deal with this problem. The remaining 5% left undone is being
able to print the two fields; OrderDtl.Number20 and OrderDtl.Number19 on
my Job Traveler.



I have copied the canned Vantage Report Data Definition and have been
trying to add the OrderDtl Table to that definition but have failed.
When I add those fields to the Crystal Report the report goes blank. Can
anyone offer assistance in how to properly add this data to the data
definition/Crystal report?



Thanks
Todd H.



[Non-text portions of this message have been removed]
3
Mr. Todd: I don't know all of your details, however I can say that at
least in my case when a report comes up blank, it has always been
because I messed up one of the joins at the crystal level.

Try changing the links associated with the fields to "Left Outer".

Good Luck,

Dave Olender

--- In vantage@yahoogroups.com, "Todd Hofert" <todd@...> wrote:
>
> Last week I posted a couple of questions regarding shipping of
Overs and
> Unders. Thanks to feedback from the group I have 95% of a solution
in
> place to deal with this problem. The remaining 5% left undone is
being
> able to print the two fields; OrderDtl.Number20 and
OrderDtl.Number19 on
> my Job Traveler.
>
>
>
> I have copied the canned Vantage Report Data Definition and have
been
> trying to add the OrderDtl Table to that definition but have failed.
> When I add those fields to the Crystal Report the report goes
blank. Can
> anyone offer assistance in how to properly add this data to the data
> definition/Crystal report?
>
>
>
> Thanks
> Todd H.
>
>
>
> [Non-text portions of this message have been removed]
>
4
One way is with a subreport.

-Peter

--- In vantage@yahoogroups.com, "Todd Hofert" <todd@...> wrote:
>
> Last week I posted a couple of questions regarding shipping of
Overs and
> Unders. Thanks to feedback from the group I have 95% of a solution
in
> place to deal with this problem. The remaining 5% left undone is
being
> able to print the two fields; OrderDtl.Number20 and
OrderDtl.Number19 on
> my Job Traveler.
>
>
>
> I have copied the canned Vantage Report Data Definition and have
been
> trying to add the OrderDtl Table to that definition but have failed.
> When I add those fields to the Crystal Report the report goes
blank. Can
> anyone offer assistance in how to properly add this data to the data
> definition/Crystal report?
>
>
>
> Thanks
> Todd H.
>
>
>
> [Non-text portions of this message have been removed]
>
5
Dave,



I have played with the joins to no avail. I am thinking A) I am not
doing something in the data definition, or B) it is a Vantage bug that
is not allowing me to add this table. I don't recall the specifics, but
I vaguely remember working with support on a similar issue (different
data definition and tables but same basic issue) and was told it was a
bug. I threw the question out hoping someone knew a solution or a way
around it. I think I will try the sub report route and see what happens
unless someone else steps up with the answer.



Thanks

Todd



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Dave Olender
Sent: Thursday, June 26, 2008 8:34 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: OrderDtl to Job Traveler - V8.03.404A



Mr. Todd: I don't know all of your details, however I can say that at
least in my case when a report comes up blank, it has always been
because I messed up one of the joins at the crystal level.

Try changing the links associated with the fields to "Left Outer".

Good Luck,

Dave Olender

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Todd Hofert" <todd@...> wrote:
>
> Last week I posted a couple of questions regarding shipping of
Overs and
> Unders. Thanks to feedback from the group I have 95% of a solution
in
> place to deal with this problem. The remaining 5% left undone is
being
> able to print the two fields; OrderDtl.Number20 and
OrderDtl.Number19 on
> my Job Traveler.
>
>
>
> I have copied the canned Vantage Report Data Definition and have
been
> trying to add the OrderDtl Table to that definition but have failed.
> When I add those fields to the Crystal Report the report goes
blank. Can
> anyone offer assistance in how to properly add this data to the data
> definition/Crystal report?
>
>
>
> Thanks
> Todd H.
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
6
I am having what seems to be the EXACT same problem this week.

I am on Vantage 8.03.404/Progress.

Following the instructions in AnswerBook # 4778MPS, I added the Part
file to the canned Vantage Data Definitions for the Packing Slip form.

When I am in Crystal Reports, I can link the Part file. And from the
Field Explorer, I add the Part.PartsPerContainer field to my
PackingSlip CR.

When I save the CR and go back to Vantage to preview a packing slip,
at first glance the packing slip looks fine; but the field(s) that I
am trying to pull in from the Part file do not show up.

I have also experimented with the CR links to no avail.

I too am wondering if there is a bug in the process.

Lynn



--- In vantage@yahoogroups.com, "Todd Hofert" <todd@...> wrote:
>
> Dave,
>
>
>
> I have played with the joins to no avail. I am thinking A) I am not
> doing something in the data definition, or B) it is a Vantage bug
that
> is not allowing me to add this table. I don't recall the specifics,
but
> I vaguely remember working with support on a similar issue
(different
> data definition and tables but same basic issue) and was told it
was a
> bug. I threw the question out hoping someone knew a solution or a
way
> around it. I think I will try the sub report route and see what
happens
> unless someone else steps up with the answer.
>
>
>
> Thanks
>
> Todd
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of Dave Olender
> Sent: Thursday, June 26, 2008 8:34 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: OrderDtl to Job Traveler - V8.03.404A
>
>
>
> Mr. Todd: I don't know all of your details, however I can say that
at
> least in my case when a report comes up blank, it has always been
> because I messed up one of the joins at the crystal level.
>
> Try changing the links associated with the fields to "Left Outer".
>
> Good Luck,
>
> Dave Olender
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Todd Hofert" <todd@> wrote:
> >
> > Last week I posted a couple of questions regarding shipping of
> Overs and
> > Unders. Thanks to feedback from the group I have 95% of a
solution
> in
> > place to deal with this problem. The remaining 5% left undone is
> being
> > able to print the two fields; OrderDtl.Number20 and
> OrderDtl.Number19 on
> > my Job Traveler.
> >
> >
> >
> > I have copied the canned Vantage Report Data Definition and have
> been
> > trying to add the OrderDtl Table to that definition but have
failed.
> > When I add those fields to the Crystal Report the report goes
> blank. Can
> > anyone offer assistance in how to properly add this data to the
data
> > definition/Crystal report?
> >
> >
> >
> > Thanks
> > Todd H.
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
7
Even though you may have added the table in the Data Definition it does not
mean it linked when the process to create the report generates the XML file.
So in Crystal when you link them you probably see that the Part Table in the
linking tab has no indication of Primary, 2nd, etc... indexes.

So in Crystal create a subreport and then link to the Subreport Tables you
need. If that does not work Crystal can draw from multiple database
connections at the same time. Meaning that not only can it read the XML
generated file from Vantage it can also link to Vantage via ODBC. So if
linking the above Part table does not work when included in the data
definition you can create a subreport, have it talk to Vantage via ODBC,
link the table and fields via the subreport and you should get back the data
you are looking for.

But you will have to edit the registry to put the default username and
password in the ODBC connection to Vantage. Otherwise when the report runs
it will ask the user for both.

Scott Litzau, MCP
Olympus Flag & Banner
Information Systems Manager
scott.litzau@...
P: 414-365-9732
F: 414-355-1931

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Lynn
Sent: Thursday, June 26, 2008 8:50 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: OrderDtl to Job Traveler - V8.03.404A

I am having what seems to be the EXACT same problem this week.

I am on Vantage 8.03.404/Progress.

Following the instructions in AnswerBook # 4778MPS, I added the Part
file to the canned Vantage Data Definitions for the Packing Slip form.

When I am in Crystal Reports, I can link the Part file. And from the
Field Explorer, I add the Part.PartsPerContainer field to my
PackingSlip CR.

When I save the CR and go back to Vantage to preview a packing slip,
at first glance the packing slip looks fine; but the field(s) that I
am trying to pull in from the Part file do not show up.

I have also experimented with the CR links to no avail.

I too am wondering if there is a bug in the process.

Lynn



--- In vantage@yahoogroups.com, "Todd Hofert" <todd@...> wrote:
>
> Dave,
>
>
>
> I have played with the joins to no avail. I am thinking A) I am not
> doing something in the data definition, or B) it is a Vantage bug
that
> is not allowing me to add this table. I don't recall the specifics,
but
> I vaguely remember working with support on a similar issue
(different
> data definition and tables but same basic issue) and was told it
was a
> bug. I threw the question out hoping someone knew a solution or a
way
> around it. I think I will try the sub report route and see what
happens
> unless someone else steps up with the answer.
>
>
>
> Thanks
>
> Todd
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of Dave Olender
> Sent: Thursday, June 26, 2008 8:34 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: OrderDtl to Job Traveler - V8.03.404A
>
>
>
> Mr. Todd: I don't know all of your details, however I can say that
at
> least in my case when a report comes up blank, it has always been
> because I messed up one of the joins at the crystal level.
>
> Try changing the links associated with the fields to "Left Outer".
>
> Good Luck,
>
> Dave Olender
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Todd Hofert" <todd@> wrote:
> >
> > Last week I posted a couple of questions regarding shipping of
> Overs and
> > Unders. Thanks to feedback from the group I have 95% of a
solution
> in
> > place to deal with this problem. The remaining 5% left undone is
> being
> > able to print the two fields; OrderDtl.Number20 and
> OrderDtl.Number19 on
> > my Job Traveler.
> >
> >
> >
> > I have copied the canned Vantage Report Data Definition and have
> been
> > trying to add the OrderDtl Table to that definition but have
failed.
> > When I add those fields to the Crystal Report the report goes
> blank. Can
> > anyone offer assistance in how to properly add this data to the
data
> > definition/Crystal report?
> >
> >
> >
> > Thanks
> > Todd H.
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [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/linksYahoo! Groups Links
8
If it is a drop dead critical issue for you (and the sub-report attempt fails), a cludge fix would be to write your OrderDtl.Number20 and
OrderDtl.Number19 values to JobHead.Number## fields (that are accessible in the standard Crystal table joins for the report).

I assume maintenance of the OrderDtl fields is done through order entry so you would have to add JobHead as an FKV (likely to JobProd as that should already be available in order to show the linked jobs in the order entry app). You probably would also have to add the job adapter and its associated assemblies.

Rob Brown

--- On Thu, 6/26/08, Todd Hofert <todd@...> wrote:
From: Todd Hofert <todd@...>
Subject: RE: [Vantage] Re: OrderDtl to Job Traveler - V8.03.404A
To: vantage@yahoogroups.com
Date: Thursday, June 26, 2008, 9:01 AM











Dave,



I have played with the joins to no avail. I am thinking A) I am not

doing something in the data definition, or B) it is a Vantage bug that

is not allowing me to add this table. I don't recall the specifics, but

I vaguely remember working with support on a similar issue (different

data definition and tables but same basic issue) and was told it was a

bug. I threw the question out hoping someone knew a solution or a way

around it. I think I will try the sub report route and see what happens

unless someone else steps up with the answer.



Thanks



Todd



From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf

Of Dave Olender

Sent: Thursday, June 26, 2008 8:34 AM

To: vantage@yahoogroups .com

Subject: [Vantage] Re: OrderDtl to Job Traveler - V8.03.404A



Mr. Todd: I don't know all of your details, however I can say that at

least in my case when a report comes up blank, it has always been

because I messed up one of the joins at the crystal level.



Try changing the links associated with the fields to "Left Outer".



Good Luck,



Dave Olender



--- In vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com> ,

"Todd Hofert" <todd@...> wrote:

>

> Last week I posted a couple of questions regarding shipping of

Overs and

> Unders. Thanks to feedback from the group I have 95% of a solution

in

> place to deal with this problem. The remaining 5% left undone is

being

> able to print the two fields; OrderDtl.Number20 and

OrderDtl.Number19 on

> my Job Traveler.

>

>

>

> I have copied the canned Vantage Report Data Definition and have

been

> trying to add the OrderDtl Table to that definition but have failed.

> When I add those fields to the Crystal Report the report goes

blank. Can

> anyone offer assistance in how to properly add this data to the data

> definition/Crystal report?

>

>

>

> Thanks

> Todd H.

>

>

>

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

>



[Non-text portions of this message have been removed]
9
Hi Scott:

It didn't work. I created the subreport and linked it to the
container report via ShipDtl.PartNum = Part.PartNum, but I cannot get
the PackingList Subreport to bring in any data from the Part file
either.

I guess I'm going to have to go to the last resort and use ODBC. I
have been extremely reluctant to do this because it is my
understanding that when the user is using Vantage and the Progress-CR
ODBC, then 2 Vantage licenses are being used by the user. We will
very quickly run out of Vantage/Progress licenses if this option must
be used.

Thanks.

Lynn



--- In vantage@yahoogroups.com, "Scott Litzau" <scott.litzau@...>
wrote:
>
> Even though you may have added the table in the Data Definition it
does not
> mean it linked when the process to create the report generates the
XML file.
> So in Crystal when you link them you probably see that the Part
Table in the
> linking tab has no indication of Primary, 2nd, etc... indexes.
>
> So in Crystal create a subreport and then link to the Subreport
Tables you
> need. If that does not work Crystal can draw from multiple database
> connections at the same time. Meaning that not only can it read the
XML
> generated file from Vantage it can also link to Vantage via ODBC.
So if
> linking the above Part table does not work when included in the data
> definition you can create a subreport, have it talk to Vantage via
ODBC,
> link the table and fields via the subreport and you should get back
the data
> you are looking for.
>
> But you will have to edit the registry to put the default username
and
> password in the ODBC connection to Vantage. Otherwise when the
report runs
> it will ask the user for both.
>
> Scott Litzau, MCP
> Olympus Flag & Banner
> Information Systems Manager
> scott.litzau@...
> P: 414-365-9732
> F: 414-355-1931
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> Lynn
> Sent: Thursday, June 26, 2008 8:50 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: OrderDtl to Job Traveler - V8.03.404A
>
> I am having what seems to be the EXACT same problem this week.
>
> I am on Vantage 8.03.404/Progress.
>
> Following the instructions in AnswerBook # 4778MPS, I added the
Part
> file to the canned Vantage Data Definitions for the Packing Slip
form.
>
> When I am in Crystal Reports, I can link the Part file. And from
the
> Field Explorer, I add the Part.PartsPerContainer field to my
> PackingSlip CR.
>
> When I save the CR and go back to Vantage to preview a packing
slip,
> at first glance the packing slip looks fine; but the field(s) that
I
> am trying to pull in from the Part file do not show up.
>
> I have also experimented with the CR links to no avail.
>
> I too am wondering if there is a bug in the process.
>
> Lynn
>
>
>
> --- In vantage@yahoogroups.com, "Todd Hofert" <todd@> wrote:
> >
> > Dave,
> >
> >
> >
> > I have played with the joins to no avail. I am thinking A) I am
not
> > doing something in the data definition, or B) it is a Vantage bug
> that
> > is not allowing me to add this table. I don't recall the
specifics,
> but
> > I vaguely remember working with support on a similar issue
> (different
> > data definition and tables but same basic issue) and was told it
> was a
> > bug. I threw the question out hoping someone knew a solution or a
> way
> > around it. I think I will try the sub report route and see what
> happens
> > unless someone else steps up with the answer.
> >
> >
> >
> > Thanks
> >
> > Todd
> >
> >
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf
> > Of Dave Olender
> > Sent: Thursday, June 26, 2008 8:34 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re: OrderDtl to Job Traveler - V8.03.404A
> >
> >
> >
> > Mr. Todd: I don't know all of your details, however I can say
that
> at
> > least in my case when a report comes up blank, it has always been
> > because I messed up one of the joins at the crystal level.
> >
> > Try changing the links associated with the fields to "Left Outer".
> >
> > Good Luck,
> >
> > Dave Olender
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%
40yahoogroups.com> ,
> > "Todd Hofert" <todd@> wrote:
> > >
> > > Last week I posted a couple of questions regarding shipping of
> > Overs and
> > > Unders. Thanks to feedback from the group I have 95% of a
> solution
> > in
> > > place to deal with this problem. The remaining 5% left undone
is
> > being
> > > able to print the two fields; OrderDtl.Number20 and
> > OrderDtl.Number19 on
> > > my Job Traveler.
> > >
> > >
> > >
> > > I have copied the canned Vantage Report Data Definition and
have
> > been
> > > trying to add the OrderDtl Table to that definition but have
> failed.
> > > When I add those fields to the Crystal Report the report goes
> > blank. Can
> > > anyone offer assistance in how to properly add this data to the
> data
> > > definition/Crystal report?
> > >
> > >
> > >
> > > Thanks
> > > Todd H.
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> >
> >
> > [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/linksYahoo! Groups Links
>
10
The licensing does work that way. In Vantage there you have so many licenses
but in your ODBC Setup in PET you set the number of ODBC connections the
database can a accept (the more connection the more memory it does utilize
as the connection are created). I have 30 user licenses for Vantage and then
I have 20 available ODBC connections.

So go ahead and do it by ODBC and I am sure it will work. I do this with our
Picking Ticket. I am able to print on the picking Ticket if the Order is on
Credit Hold and not just the Customer by linking back to the Customer
pulling information in to then main report and then determine if the Order
is on Credit Hold.

Scott Litzau, MCP
Olympus Flag & Banner
Information Systems Manager
scott.litzau@...
P: 414-365-9732
F: 414-355-1931


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Lynn
Sent: Thursday, June 26, 2008 10:06 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: OrderDtl to Job Traveler - V8.03.404A

Hi Scott:

It didn't work. I created the subreport and linked it to the
container report via ShipDtl.PartNum = Part.PartNum, but I cannot get
the PackingList Subreport to bring in any data from the Part file
either.

I guess I'm going to have to go to the last resort and use ODBC. I
have been extremely reluctant to do this because it is my
understanding that when the user is using Vantage and the Progress-CR
ODBC, then 2 Vantage licenses are being used by the user. We will
very quickly run out of Vantage/Progress licenses if this option must
be used.

Thanks.

Lynn



--- In vantage@yahoogroups.com, "Scott Litzau" <scott.litzau@...>
wrote:
>
> Even though you may have added the table in the Data Definition it
does not
> mean it linked when the process to create the report generates the
XML file.
> So in Crystal when you link them you probably see that the Part
Table in the
> linking tab has no indication of Primary, 2nd, etc... indexes.
>
> So in Crystal create a subreport and then link to the Subreport
Tables you
> need. If that does not work Crystal can draw from multiple database
> connections at the same time. Meaning that not only can it read the
XML
> generated file from Vantage it can also link to Vantage via ODBC.
So if
> linking the above Part table does not work when included in the data
> definition you can create a subreport, have it talk to Vantage via
ODBC,
> link the table and fields via the subreport and you should get back
the data
> you are looking for.
>
> But you will have to edit the registry to put the default username
and
> password in the ODBC connection to Vantage. Otherwise when the
report runs
> it will ask the user for both.
>
> Scott Litzau, MCP
> Olympus Flag & Banner
> Information Systems Manager
> scott.litzau@...
> P: 414-365-9732
> F: 414-355-1931
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> Lynn
> Sent: Thursday, June 26, 2008 8:50 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: OrderDtl to Job Traveler - V8.03.404A
>
> I am having what seems to be the EXACT same problem this week.
>
> I am on Vantage 8.03.404/Progress.
>
> Following the instructions in AnswerBook # 4778MPS, I added the
Part
> file to the canned Vantage Data Definitions for the Packing Slip
form.
>
> When I am in Crystal Reports, I can link the Part file. And from
the
> Field Explorer, I add the Part.PartsPerContainer field to my
> PackingSlip CR.
>
> When I save the CR and go back to Vantage to preview a packing
slip,
> at first glance the packing slip looks fine; but the field(s) that
I
> am trying to pull in from the Part file do not show up.
>
> I have also experimented with the CR links to no avail.
>
> I too am wondering if there is a bug in the process.
>
> Lynn
>
>
>
> --- In vantage@yahoogroups.com, "Todd Hofert" <todd@> wrote:
> >
> > Dave,
> >
> >
> >
> > I have played with the joins to no avail. I am thinking A) I am
not
> > doing something in the data definition, or B) it is a Vantage bug
> that
> > is not allowing me to add this table. I don't recall the
specifics,
> but
> > I vaguely remember working with support on a similar issue
> (different
> > data definition and tables but same basic issue) and was told it
> was a
> > bug. I threw the question out hoping someone knew a solution or a
> way
> > around it. I think I will try the sub report route and see what
> happens
> > unless someone else steps up with the answer.
> >
> >
> >
> > Thanks
> >
> > Todd
> >
> >
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf
> > Of Dave Olender
> > Sent: Thursday, June 26, 2008 8:34 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re: OrderDtl to Job Traveler - V8.03.404A
> >
> >
> >
> > Mr. Todd: I don't know all of your details, however I can say
that
> at
> > least in my case when a report comes up blank, it has always been
> > because I messed up one of the joins at the crystal level.
> >
> > Try changing the links associated with the fields to "Left Outer".
> >
> > Good Luck,
> >
> > Dave Olender
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%
40yahoogroups.com> ,
> > "Todd Hofert" <todd@> wrote:
> > >
> > > Last week I posted a couple of questions regarding shipping of
> > Overs and
> > > Unders. Thanks to feedback from the group I have 95% of a
> solution
> > in
> > > place to deal with this problem. The remaining 5% left undone
is
> > being
> > > able to print the two fields; OrderDtl.Number20 and
> > OrderDtl.Number19 on
> > > my Job Traveler.
> > >
> > >
> > >
> > > I have copied the canned Vantage Report Data Definition and
have
> > been
> > > trying to add the OrderDtl Table to that definition but have
> failed.
> > > When I add those fields to the Crystal Report the report goes
> > blank. Can
> > > anyone offer assistance in how to properly add this data to the
> data
> > > definition/Crystal report?
> > >
> > >
> > >
> > > Thanks
> > > Todd H.
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> >
> >
> > [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/linksYahoo! Groups Links
>



------------------------------------

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/linksYahoo! Groups Links
11
Peter got me through this. Guess what? It was A) I was doing something
wrong in the data definition. I had added some criteria in the
definition early on in my trouble shooting. Once I removed them the data
was available for reporting.



Thanks Peter.



Todd H.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Hofert
Sent: Thursday, June 26, 2008 9:01 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: OrderDtl to Job Traveler - V8.03.404A



Dave,

I have played with the joins to no avail. I am thinking A) I am not
doing something in the data definition, or B) it is a Vantage bug that
is not allowing me to add this table. I don't recall the specifics, but
I vaguely remember working with support on a similar issue (different
data definition and tables but same basic issue) and was told it was a
bug. I threw the question out hoping someone knew a solution or a way
around it. I think I will try the sub report route and see what happens
unless someone else steps up with the answer.

Thanks

Todd

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Dave Olender
Sent: Thursday, June 26, 2008 8:34 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: OrderDtl to Job Traveler - V8.03.404A

Mr. Todd: I don't know all of your details, however I can say that at
least in my case when a report comes up blank, it has always been
because I messed up one of the joins at the crystal level.

Try changing the links associated with the fields to "Left Outer".

Good Luck,

Dave Olender

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
"Todd Hofert" <todd@...> wrote:
>
> Last week I posted a couple of questions regarding shipping of
Overs and
> Unders. Thanks to feedback from the group I have 95% of a solution
in
> place to deal with this problem. The remaining 5% left undone is
being
> able to print the two fields; OrderDtl.Number20 and
OrderDtl.Number19 on
> my Job Traveler.
>
>
>
> I have copied the canned Vantage Report Data Definition and have
been
> trying to add the OrderDtl Table to that definition but have failed.
> When I add those fields to the Crystal Report the report goes
blank. Can
> anyone offer assistance in how to properly add this data to the data
> definition/Crystal report?
>
>
>
> Thanks
> Todd H.
>
>
>
> [Non-text portions of this message have been removed]
>

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





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