Need help with adding additional table to Job Traveler in Crysta

system · June 10, 2011, 1:55pm

And check the XML file to see if the PartBin table is shown in the XML...If so, does it have data in the xml for PartBin?

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of cooner_55421
Sent: Friday, June 10, 2011 12:53 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Need help with adding additional table to Job Traveler in Crystal

Some things to check -
You ran a report
--- the report style used the new RDD
Then opened the report specified in the style in Crystal
- and you are sure you changed the db connection to the XML file that was created when you ran the report? They are usually stored in a folder on the server, something like this -
\\servername\epicorshare\EpicorData\Reports\your_user_name

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, "Bethany Rye" <brye@...> wrote:
>
>
>
> I've done all of this and the PartBin table still isn't showing. Something
> I missed?
>
>
>
> From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of
> cooner_55421
> Sent: Wednesday, June 08, 2011 4:29 PM
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Need help with adding additional table to Job
> Traveler in Crystal
>
>
>
>
>
> Oh yeah.... A couple more steps will be required.
> In Crystal, now that you're linked to the new XML,
> Open Database Expert.
> Expand "Current Connections"
> You should see the table.
> Click the arrow to move it to selected tables.
> Then make sure you click the links tab and check/add the joins.
>
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> , "Bethany
> Rye" <brye@> wrote:
> >
> > We did all this and still cannot see the added table, PartBin.
> >
> >
> >
> > From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ] On
> Behalf Of
> > cooner_55421
> > Sent: Wednesday, June 08, 2011 2:56 PM
> > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Re: Need help with adding additional table to Job
> > Traveler in Crystal
> >
> >
> >
> >
> >
> > You changed the report style too?
> > If so...
> >
> > Then bear with me... here is a general outline of the steps.
> > (there are multiple ways to set this, and it's pretty hard to explain
> > without screen shots)
> >
> > Run the report from the menu.
> > Then open the report in Crystal.
> > In Field Explorer, right click on Database Fields, select set datasource
> > location.
> > Expand the report properties
> > double click on the file path & wipe it & close.
> > A dialog box will pop up and let you browse out to you report data
> directory
> > and select the new XML you generated when yo ran the report.
> >
> > --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> , "Bethany
> > Rye" <brye@> wrote:
> > >
> > > OK. We did that. So how do we get the Crystal Report to recognize the
> new
> > > RDD?
> > >
> > >
> > >
> > > Beth
> > >
> > >
> > >
> > >
> > >
> > > From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ] On
> > Behalf Of
> > > cooner_55421
> > > Sent: Wednesday, June 08, 2011 2:30 PM
> > > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Re: Need help with adding additional table to Job
> > > Traveler in Crystal
> > >
> > >
> > >
> > >
> > >
> > >
> > > Yes, you won't be able to modify system RDDs.
> > > Duplicate it and modify the new copy.
> > > Then on your report style, specify the new RDD.
> > >
> > > --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com> , "Bethany
> > > Rye" <brye@> wrote:
> > > >
> > > > I found the Report Data Definitions and went to the report (Job
> > Traveler).
> > > > I'm able to look at it, but I can't add a table. The option for it is
> > > > greyed out. I'm thinking it is greyed out because it is a system
> report.
> > > > Am I correct?
> > > >
> > > > Beth Rye
> > > > IT Director
> > > > CIGNYS
> > > > 68 Williamson Street
> > > > Saginaw, Michigan 48601
> > > > Phone: (989) 753-1411 ext. 1114
> > > > Direct Line: (989) 393-0108
> > > > Fax: (989) 393-0208
> > > > Email: brye@
> > > >
> > > > ***ITAR NOTICE***
> > > > This e-mail and/or the attached documents may contain technical data
> > > within
> > > > the definition of the International Traffic in Arms regulations, and
> are
> > > > subject to the export control laws of the US Government. Transfer of
> > this
> > > > data by any means to a foreign person, whether in the US or abroad,
> > > without
> > > > an export license or other approval from the US Department of State,
> is
> > > > prohibited. No portion of this e-mail or its attachment(s) may be
> > > reproduced
> > > > without written consent of CIGNYS. If you are not the intended
> recipient
> > > or
> > > > believe that you may have received this document in error, please
> notify
> > > the
> > > > sender and delete this e-mail and any attachments immediately.
> > > >
> > > > -----Original Message-----
> > > > From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > > [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com> ] On
> > > Behalf Of
> > > > Waffqle
> > > > Sent: Wednesday, June 08, 2011 1:34 PM
> > > > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > > > Subject: Re: [Vantage] Need help with adding additional table to Job
> > > > Traveler in Crystal
> > > >
> > > > "Report Data Definitions" are what you want.
> > > > They're under System > Company Maintenance.
> > > >
> > > > They're a little wierd at first but you should be able to get the hang
> > of
> > > it
> > > > pretty quick. Let me know if you have any issues once you get in
> there.
> > > >
> > > > On Wed, Jun 8, 2011 at 12:13 PM, Bethany Rye <brye@> wrote:
> > > >
> > > > >
> > > > >
> > > > > I'm trying to link the PartBin table into the existing Job Traveler
> so
> >
> > > > > that I can print the bin number of the raw materials. I have tried
> > > > > adding the table through an ODBC connection but then the subreport
> > > > > goes blank and none of the raw materials will display. What I need
> to
> > > > > know is how to add a table to an existing Epicor report. Any help
> > would
> > > be
> > > > greatly appreciated!
> > > > >
> > > > > Beth
> > > > >
> > > > > Beth Rye
> > > > >
> > > > > IT Director
> > > > >
> > > > > CIGNYS
> > > > >
> > > > > Email: <mailto:brye@> brye@
> > > > >
> > > > > ***ITAR NOTICE***
> > > > >
> > > > > This e-mail and/or the attached documents may contain technical data
>
> > > > > within the definition of the International Traffic in Arms
> > > > > regulations, and are subject to the export control laws of the US
> > > > > Government. Transfer of this data by any means to a foreign person,
> > > > > whether in the US or abroad, without an export license or other
> > > > > approval from the US Department of State, is prohibited. No portion
> of
> >
> > > > > this e-mail or its attachment(s) may be reproduced without written
> > > > > consent of CIGNYS. If you are not the intended recipient or believe
> > > > > that you may have received this document in error, please notify the
>
> > > > > sender and delete this e-mail and any attachments immediately.
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > > > --
> > > > *Waffqle Driggers*
> > > > *High End Dev, System Design, Profit Drinking
> > > > *
> > > > *:: 904.962.2887*
> > > > *:: waffqle@*
> > > > *:: NO FAXES*
> > > >
> > > > *
> > > >
> > > > *
> > > >
> > > >
> > > > [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/>
> > > <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
> > > >
> > >
> > >
> > >
> > >
> > >
> > > [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]
>

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

system · June 8, 2011, 12:40pm

I'm trying to link the PartBin table into the existing Job Traveler so that
I can print the bin number of the raw materials. I have tried adding the
table through an ODBC connection but then the subreport goes blank and none
of the raw materials will display. What I need to know is how to add a
table to an existing Epicor report. Any help would be greatly appreciated!

Beth

Beth Rye

IT Director

CIGNYS

Email: <mailto:brye@...> brye@...

***ITAR NOTICE***

This e-mail and/or the attached documents may contain technical data within
the definition of the International Traffic in Arms regulations, and are
subject to the export control laws of the US Government. Transfer of this
data by any means to a foreign person, whether in the US or abroad, without
an export license or other approval from the US Department of State, is
prohibited. No portion of this e-mail or its attachment(s) may be reproduced
without written consent of CIGNYS. If you are not the intended recipient or
believe that you may have received this document in error, please notify the
sender and delete this e-mail and any attachments immediately.

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

system · June 8, 2011, 1:44pm

"Report Data Definitions" are what you want.
They're under System > Company Maintenance.

They're a little wierd at first but you should be able to get the hang of it
pretty quick. Let me know if you have any issues once you get in there.

On Wed, Jun 8, 2011 at 12:13 PM, Bethany Rye <brye@...> wrote:

>
>
> I'm trying to link the PartBin table into the existing Job Traveler so that
> I can print the bin number of the raw materials. I have tried adding the
> table through an ODBC connection but then the subreport goes blank and none
> of the raw materials will display. What I need to know is how to add a
> table to an existing Epicor report. Any help would be greatly appreciated!
>
> Beth
>
> Beth Rye
>
> IT Director
>
> CIGNYS
>
> Email: <mailto:brye@...> brye@...
>
> ***ITAR NOTICE***
>
> This e-mail and/or the attached documents may contain technical data within
> the definition of the International Traffic in Arms regulations, and are
> subject to the export control laws of the US Government. Transfer of this
> data by any means to a foreign person, whether in the US or abroad, without
> an export license or other approval from the US Department of State, is
> prohibited. No portion of this e-mail or its attachment(s) may be
> reproduced
> without written consent of CIGNYS. If you are not the intended recipient or
> believe that you may have received this document in error, please notify
> the
> sender and delete this e-mail and any attachments immediately.
>
> [Non-text portions of this message have been removed]
>
>
>

--
*Waffqle Driggers*
*High End Dev, System Design, Profit Drinking
*
*:: 904.962.2887*
*:: waffqle@...*
*:: NO FAXES*

*

*

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

system · June 8, 2011, 1:46pm

Hi Beth,

This is what I have setup in the report data defenitions:

Relation: JobMatPartBin

Description: JobMat to PartBin

Parent Table: JobMtl

Child Table: PartBin

The fields that I'm using are:

Company

PartNum

WarehouseCode

Does this get you the information that you need?

Thanks,

Travis Late

IT/ERP Manager

M-B Companies, Inc

Office: 920-898-1560 Ext. 264

Mobile: 920-960-0062

tlate@... <mailto:tlate@...>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Bethany Rye
Sent: Wednesday, June 08, 2011 11:14 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Need help with adding additional table to Job
Traveler in Crystal

I'm trying to link the PartBin table into the existing Job Traveler so
that
I can print the bin number of the raw materials. I have tried adding the
table through an ODBC connection but then the subreport goes blank and
none
of the raw materials will display. What I need to know is how to add a
table to an existing Epicor report. Any help would be greatly
appreciated!

Beth

Beth Rye

IT Director

CIGNYS

Email: <mailto:brye@... <mailto:brye%40cignys.com> >
brye@... <mailto:brye%40cignys.com>

***ITAR NOTICE***

This e-mail and/or the attached documents may contain technical data
within
the definition of the International Traffic in Arms regulations, and are
subject to the export control laws of the US Government. Transfer of
this
data by any means to a foreign person, whether in the US or abroad,
without
an export license or other approval from the US Department of State, is
prohibited. No portion of this e-mail or its attachment(s) may be
reproduced
without written consent of CIGNYS. If you are not the intended recipient
or
believe that you may have received this document in error, please notify
the
sender and delete this e-mail and any attachments immediately.

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

M-B Companies Confidentiality Notice:
This message is being sent by M-B Companies. It is intended exclusively for
the individuals and entities to which it is addressed. This communication,
including any attachments, may contain information that is proprietary,
privileged and confidential if you are not the named addressee; you are not
authorized to read,print,retain copy or disseminate this message or any part
of it.If you have received this message in error, please notify the sender
immediately by email.

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

system · June 8, 2011, 2:11pm

I found the Report Data Definitions and went to the report (Job Traveler).
I'm able to look at it, but I can't add a table. The option for it is
greyed out. I'm thinking it is greyed out because it is a system report.
Am I correct?

Beth Rye
IT Director
CIGNYS
68 Williamson Street
Saginaw, Michigan 48601
Phone:Â (989) 753-1411Â ext. 1114
Direct Line: (989) 393-0108
Fax:Â (989) 393-0208
Email:Â brye@...

***ITAR NOTICE***
This e-mail and/or the attached documents may contain technical data within
the definition of the International Traffic in Arms regulations, and are
subject to the export control laws of the US Government. Transfer of this
data by any means to a foreign person, whether in the US or abroad, without
an export license or other approval from the US Department of State, is
prohibited. No portion of this e-mail or its attachment(s) may be reproduced
without written consent of CIGNYS. If you are not the intended recipient or
believe that you may have received this document in error, please notify the
sender and delete this e-mail and any attachments immediately.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Waffqle
Sent: Wednesday, June 08, 2011 1:34 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Need help with adding additional table to Job
Traveler in Crystal

"Report Data Definitions" are what you want.
They're under System > Company Maintenance.

They're a little wierd at first but you should be able to get the hang of it
pretty quick. Let me know if you have any issues once you get in there.

On Wed, Jun 8, 2011 at 12:13 PM, Bethany Rye <brye@...> wrote:

>
>
> I'm trying to link the PartBin table into the existing Job Traveler so
> that I can print the bin number of the raw materials. I have tried
> adding the table through an ODBC connection but then the subreport
> goes blank and none of the raw materials will display. What I need to
> know is how to add a table to an existing Epicor report. Any help would be
greatly appreciated!
>
> Beth
>
> Beth Rye
>
> IT Director
>
> CIGNYS
>
> Email: <mailto:brye@...> brye@...
>
> ***ITAR NOTICE***
>
> This e-mail and/or the attached documents may contain technical data
> within the definition of the International Traffic in Arms
> regulations, and are subject to the export control laws of the US
> Government. Transfer of this data by any means to a foreign person,
> whether in the US or abroad, without an export license or other
> approval from the US Department of State, is prohibited. No portion of
> this e-mail or its attachment(s) may be reproduced without written
> consent of CIGNYS. If you are not the intended recipient or believe
> that you may have received this document in error, please notify the
> sender and delete this e-mail and any attachments immediately.
>
> [Non-text portions of this message have been removed]
>
>
>

--
*Waffqle Driggers*
*High End Dev, System Design, Profit Drinking
*
*:: 904.962.2887*
*:: waffqle@...*
*:: NO FAXES*

*

*

[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

system · June 8, 2011, 2:46pm

OK. We did that. So how do we get the Crystal Report to recognize the new
RDD?

Beth

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
cooner_55421
Sent: Wednesday, June 08, 2011 2:30 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Need help with adding additional table to Job
Traveler in Crystal

Yes, you won't be able to modify system RDDs.
Duplicate it and modify the new copy.
Then on your report style, specify the new RDD.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Bethany
Rye" <brye@...> wrote:

>
> I found the Report Data Definitions and went to the report (Job Traveler).
> I'm able to look at it, but I can't add a table. The option for it is
> greyed out. I'm thinking it is greyed out because it is a system report.
> Am I correct?
>
> Beth Rye
> IT Director
> CIGNYS
> 68 Williamson Street
> Saginaw, Michigan 48601
> Phone: (989) 753-1411 ext. 1114
> Direct Line: (989) 393-0108
> Fax: (989) 393-0208
> Email: brye@...
>
> ***ITAR NOTICE***
> This e-mail and/or the attached documents may contain technical data

within

> the definition of the International Traffic in Arms regulations, and are
> subject to the export control laws of the US Government. Transfer of this
> data by any means to a foreign person, whether in the US or abroad,

without

> an export license or other approval from the US Department of State, is
> prohibited. No portion of this e-mail or its attachment(s) may be

reproduced

> without written consent of CIGNYS. If you are not the intended recipient

or

> believe that you may have received this document in error, please notify

the

> sender and delete this e-mail and any attachments immediately.
>
> -----Original Message-----
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>

[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of

> Waffqle
> Sent: Wednesday, June 08, 2011 1:34 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: Re: [Vantage] Need help with adding additional table to Job
> Traveler in Crystal
>
> "Report Data Definitions" are what you want.
> They're under System > Company Maintenance.
>
> They're a little wierd at first but you should be able to get the hang of

it

> pretty quick. Let me know if you have any issues once you get in there.
>
> On Wed, Jun 8, 2011 at 12:13 PM, Bethany Rye <brye@...> wrote:
>
> >
> >
> > I'm trying to link the PartBin table into the existing Job Traveler so
> > that I can print the bin number of the raw materials. I have tried
> > adding the table through an ODBC connection but then the subreport
> > goes blank and none of the raw materials will display. What I need to
> > know is how to add a table to an existing Epicor report. Any help would

be

> greatly appreciated!
> >
> > Beth
> >
> > Beth Rye
> >
> > IT Director
> >
> > CIGNYS
> >
> > Email: <mailto:brye@...> brye@...
> >
> > ***ITAR NOTICE***
> >
> > This e-mail and/or the attached documents may contain technical data
> > within the definition of the International Traffic in Arms
> > regulations, and are subject to the export control laws of the US
> > Government. Transfer of this data by any means to a foreign person,
> > whether in the US or abroad, without an export license or other
> > approval from the US Department of State, is prohibited. No portion of
> > this e-mail or its attachment(s) may be reproduced without written
> > consent of CIGNYS. If you are not the intended recipient or believe
> > that you may have received this document in error, please notify the
> > sender and delete this e-mail and any attachments immediately.
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
>
>
> --
> *Waffqle Driggers*
> *High End Dev, System Design, Profit Drinking
> *
> *:: 904.962.2887*
> *:: waffqle@...*
> *:: NO FAXES*
>
> *
>
> *
>
>
> [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/linksYahoo! Groups Links
>

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

system · June 8, 2011, 4:03pm

We did all this and still cannot see the added table, PartBin.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
cooner_55421
Sent: Wednesday, June 08, 2011 2:56 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Need help with adding additional table to Job
Traveler in Crystal

You changed the report style too?
If so...

Then bear with me... here is a general outline of the steps.
(there are multiple ways to set this, and it's pretty hard to explain
without screen shots)

Run the report from the menu.
Then open the report in Crystal.
In Field Explorer, right click on Database Fields, select set datasource
location.
Expand the report properties
double click on the file path & wipe it & close.
A dialog box will pop up and let you browse out to you report data directory
and select the new XML you generated when yo ran the report.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Bethany
Rye" <brye@...> wrote:

>
> OK. We did that. So how do we get the Crystal Report to recognize the new
> RDD?
>
>
>
> Beth
>
>
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>

[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of

> cooner_55421
> Sent: Wednesday, June 08, 2011 2:30 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Need help with adding additional table to Job
> Traveler in Crystal
>
>
>
>
>
>
> Yes, you won't be able to modify system RDDs.
> Duplicate it and modify the new copy.
> Then on your report style, specify the new RDD.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>

<mailto:vantage%40yahoogroups.com> , "Bethany

> Rye" <brye@> wrote:
> >
> > I found the Report Data Definitions and went to the report (Job

Traveler).

> > I'm able to look at it, but I can't add a table. The option for it is
> > greyed out. I'm thinking it is greyed out because it is a system report.
> > Am I correct?
> >
> > Beth Rye
> > IT Director
> > CIGNYS
> > 68 Williamson Street
> > Saginaw, Michigan 48601
> > Phone: (989) 753-1411 ext. 1114
> > Direct Line: (989) 393-0108
> > Fax: (989) 393-0208
> > Email: brye@
> >
> > ***ITAR NOTICE***
> > This e-mail and/or the attached documents may contain technical data
> within
> > the definition of the International Traffic in Arms regulations, and are
> > subject to the export control laws of the US Government. Transfer of

this

> > data by any means to a foreign person, whether in the US or abroad,
> without
> > an export license or other approval from the US Department of State, is
> > prohibited. No portion of this e-mail or its attachment(s) may be
> reproduced
> > without written consent of CIGNYS. If you are not the intended recipient
> or
> > believe that you may have received this document in error, please notify
> the
> > sender and delete this e-mail and any attachments immediately.
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>

<mailto:vantage%40yahoogroups.com>

> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>

<mailto:vantage%40yahoogroups.com> ] On

> Behalf Of
> > Waffqle
> > Sent: Wednesday, June 08, 2011 1:34 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>

<mailto:vantage%40yahoogroups.com>

> > Subject: Re: [Vantage] Need help with adding additional table to Job
> > Traveler in Crystal
> >
> > "Report Data Definitions" are what you want.
> > They're under System > Company Maintenance.
> >
> > They're a little wierd at first but you should be able to get the hang

of

> it
> > pretty quick. Let me know if you have any issues once you get in there.
> >
> > On Wed, Jun 8, 2011 at 12:13 PM, Bethany Rye <brye@> wrote:
> >
> > >
> > >
> > > I'm trying to link the PartBin table into the existing Job Traveler so

> > > that I can print the bin number of the raw materials. I have tried
> > > adding the table through an ODBC connection but then the subreport
> > > goes blank and none of the raw materials will display. What I need to
> > > know is how to add a table to an existing Epicor report. Any help

would

> be
> > greatly appreciated!
> > >
> > > Beth
> > >
> > > Beth Rye
> > >
> > > IT Director
> > >
> > > CIGNYS
> > >
> > > Email: <mailto:brye@> brye@
> > >
> > > ***ITAR NOTICE***
> > >
> > > This e-mail and/or the attached documents may contain technical data
> > > within the definition of the International Traffic in Arms
> > > regulations, and are subject to the export control laws of the US
> > > Government. Transfer of this data by any means to a foreign person,
> > > whether in the US or abroad, without an export license or other
> > > approval from the US Department of State, is prohibited. No portion of

> > > this e-mail or its attachment(s) may be reproduced without written
> > > consent of CIGNYS. If you are not the intended recipient or believe
> > > that you may have received this document in error, please notify the
> > > sender and delete this e-mail and any attachments immediately.
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > >
> >
> >
> >
> > --
> > *Waffqle Driggers*
> > *High End Dev, System Design, Profit Drinking
> > *
> > *:: 904.962.2887*
> > *:: waffqle@*
> > *:: NO FAXES*
> >
> > *
> >
> > *
> >
> >
> > [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/linksYahoo! Groups Links
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

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

system · June 8, 2011, 9:09pm

Absolutely. You have to copy it. (Action) Then you can add a table.

Then set any old report that uses the old DLL to use the new DLL, run the report so it generates a XML file. The go to Crystal and connect to this new XML.

But don't forget even if you make the relationships between old tables and new tables in the DLL, you have to repeat them in Crystal.

--- In vantage@yahoogroups.com, "Bethany Rye" <brye@...> wrote:
>
> I found the Report Data Definitions and went to the report (Job Traveler).
> I'm able to look at it, but I can't add a table. The option for it is
> greyed out. I'm thinking it is greyed out because it is a system report.
> Am I correct?
>
> Beth Rye
> IT Director
> CIGNYS
> 68 Williamson Street
> Saginaw, Michigan 48601
> Phone:Â (989) 753-1411Â ext. 1114
> Direct Line: (989) 393-0108
> Fax:Â (989) 393-0208
> Email:Â brye@...
>
> ***ITAR NOTICE***
> This e-mail and/or the attached documents may contain technical data within
> the definition of the International Traffic in Arms regulations, and are
> subject to the export control laws of the US Government. Transfer of this
> data by any means to a foreign person, whether in the US or abroad, without
> an export license or other approval from the US Department of State, is
> prohibited. No portion of this e-mail or its attachment(s) may be reproduced
> without written consent of CIGNYS. If you are not the intended recipient or
> believe that you may have received this document in error, please notify the
> sender and delete this e-mail and any attachments immediately.
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> Waffqle
> Sent: Wednesday, June 08, 2011 1:34 PM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Need help with adding additional table to Job
> Traveler in Crystal
>
> "Report Data Definitions" are what you want.
> They're under System > Company Maintenance.
>
> They're a little wierd at first but you should be able to get the hang of it
> pretty quick. Let me know if you have any issues once you get in there.
>
> On Wed, Jun 8, 2011 at 12:13 PM, Bethany Rye <brye@...> wrote:
>
> >
> >
> > I'm trying to link the PartBin table into the existing Job Traveler so
> > that I can print the bin number of the raw materials. I have tried
> > adding the table through an ODBC connection but then the subreport
> > goes blank and none of the raw materials will display. What I need to
> > know is how to add a table to an existing Epicor report. Any help would be
> greatly appreciated!
> >
> > Beth
> >
> > Beth Rye
> >
> > IT Director
> >
> > CIGNYS
> >
> > Email: <mailto:brye@...> brye@...
> >
> > ***ITAR NOTICE***
> >
> > This e-mail and/or the attached documents may contain technical data
> > within the definition of the International Traffic in Arms
> > regulations, and are subject to the export control laws of the US
> > Government. Transfer of this data by any means to a foreign person,
> > whether in the US or abroad, without an export license or other
> > approval from the US Department of State, is prohibited. No portion of
> > this e-mail or its attachment(s) may be reproduced without written
> > consent of CIGNYS. If you are not the intended recipient or believe
> > that you may have received this document in error, please notify the
> > sender and delete this e-mail and any attachments immediately.
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
>
>
> --
> *Waffqle Driggers*
> *High End Dev, System Design, Profit Drinking
> *
> *:: 904.962.2887*
> *:: waffqle@...*
> *:: NO FAXES*
>
> *
>
> *
>
>
> [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
>

system · June 9, 2011, 5:21pm

I've done all of this and the PartBin table still isn't showing. Something
I missed?

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
cooner_55421
Sent: Wednesday, June 08, 2011 4:29 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Need help with adding additional table to Job
Traveler in Crystal

Oh yeah.... A couple more steps will be required.
In Crystal, now that you're linked to the new XML,
Open Database Expert.
Expand "Current Connections"
You should see the table.
Click the arrow to move it to selected tables.
Then make sure you click the links tab and check/add the joins.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Bethany
Rye" <brye@...> wrote:

>
> We did all this and still cannot see the added table, PartBin.
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>

[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of

> cooner_55421
> Sent: Wednesday, June 08, 2011 2:56 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Need help with adding additional table to Job
> Traveler in Crystal
>
>
>
>
>
> You changed the report style too?
> If so...
>
> Then bear with me... here is a general outline of the steps.
> (there are multiple ways to set this, and it's pretty hard to explain
> without screen shots)
>
> Run the report from the menu.
> Then open the report in Crystal.
> In Field Explorer, right click on Database Fields, select set datasource
> location.
> Expand the report properties
> double click on the file path & wipe it & close.
> A dialog box will pop up and let you browse out to you report data

Topic		Replies	Views
Adding a linked table in report data maintenance Yahoo Archive	9	1806	May 5, 2011
Job Traveler Yahoo Archive	15	954	December 9, 2005
Job Traveler: Raw Materials Location Yahoo Archive	15	787	March 22, 2010
Bin Location on Job Traveler Yahoo Archive	3	889	June 30, 2008
Job Traveler and Primary Bin Locations Yahoo Archive	2	516	February 26, 2009

Need help with adding additional table to Job Traveler in Crysta

Related Topics