Crystal Report Help!

I have successfully created a new Report Defenition with the new Table (PartRev) I Created a "Report Relationship" from the PartRev to the OMR50 table (system table for original SchedShip Report Defenition) but this gives me multiple results per Part because the OMR50 table does not have a RevisionNumber that i can link the PartRev.RevisionNumber to.

any tips are greatly appreciated?

--- In vantage@yahoogroups.com, "vacortes21" <vcortes@...> wrote:
>
> I beleive I did. the report is "SchedShip" Scheduled Shipments Report
>
> --- In vantage@yahoogroups.com, "Manasa Reddy" <manasa@> wrote:
> >
> > And you pulled the report in the program?
> >
> >
> >
> > What is the name of the report?
> >
> >
> >
> >
> >
> >
> >
> > M. Manasa Reddy
> >
> > manasa@
> >
> > 630.806.2000 x1515
> >
> > ________________________________
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> > Of vacortes21
> > Sent: Friday, August 26, 2011 3:49 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re: Crystal Report Help!
> >
> >
> >
> >
> >
> > we are running Vantage 8.03.409C
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> > "Manasa Reddy" <manasa@> wrote:
> > >
> > > what version are you running?
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > M. Manasa Reddy
> > >
> > > manasa@
> > >
> > > 630.806.2000 x1515
> > >
> > > ________________________________
> > >
> > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> > Behalf
> > > Of vacortes21
> > > Sent: Friday, August 26, 2011 2:51 PM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Re: Crystal Report Help!
> > >
> > >
> > >
> > >
> > >
> > > Thank you so much I was not aware of this. This is a big help should
> > > help me get a few other reports updated as well.
> > >
> > > one more question, why is it that I cannot add a new table to this
> > > report? everything other then "New Report" is grayed out.
> > >
> > > thanks again
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com> ,
> > > "Manasa Reddy" <manasa@> wrote:
> > > >
> > > > You have to make the table available in the dataset first in Epicor.
> > > > You do this under Report Data Definition, click on the report table
> > > tab,
> > > > click under the excluded fields....see if it is there first. If not
> > > > link the table here first!
> > > >
> > > >
> > > >
> > > > THEN go to crystal and Update the report.
> > > >
> > > >
> > > >
> > > > This should get you going...
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > M. Manasa Reddy
> > > >
> > > > manasa@
> > > >
> > > > 630.806.2000 x1515
> > > >
> > > > ________________________________
> > > >
> > > > 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 vacortes21
> > > > Sent: Friday, August 26, 2011 2:19 PM
> > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > > > Subject: [Vantage] Re: Crystal Report Help!
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > I am working with a ODBC
> > > >
> > > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > > <mailto:vantage%40yahoogroups.com> ,
> > > > "c.krusen1" <ckrusen1@> wrote:
> > > > >
> > > > > What type of reports is it? A "canned", BAQ, or ODBC?
> > > > >
> > > > > Calvin
> > > > >
> > > > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > > <mailto:vantage%40yahoogroups.com> ,
> > > > "vacortes21" <vcortes@> wrote:
> > > > > >
> > > > > > How do you add a new table to an existing Crystal Report
> > Dataset?
> > > > > > I have a report that was Created by a previous Employee and I
> > need
> > > > to add some new fields from the PartRev table, but when I add the
> > > table
> > > > it adds it outside the Report Datset. Then after I Link the tables I
> > > get
> > > > warring message "More then one dataset driver has been used in this
> > > > report. If you want to change the database driver use database/Set
> > > > Location."
> > > > > >
> > > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > [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]
> >
>
How do you add a new table to an existing Crystal Report Dataset?
I have a report that was Created by a previous Employee and I need to add some new fields from the PartRev table, but when I add the table it adds it outside the Report Datset. Then after I Link the tables I get warring message "More then one dataset driver has been used in this report. If you want to change the database driver use database/Set Location."
What type of reports is it? A "canned", BAQ, or ODBC?

Calvin

--- In vantage@yahoogroups.com, "vacortes21" <vcortes@...> wrote:
>
> How do you add a new table to an existing Crystal Report Dataset?
> I have a report that was Created by a previous Employee and I need to add some new fields from the PartRev table, but when I add the table it adds it outside the Report Datset. Then after I Link the tables I get warring message "More then one dataset driver has been used in this report. If you want to change the database driver use database/Set Location."
>
I am working with a ODBC

--- In vantage@yahoogroups.com, "c.krusen1" <ckrusen1@...> wrote:
>
> What type of reports is it? A "canned", BAQ, or ODBC?
>
> Calvin
>
> --- In vantage@yahoogroups.com, "vacortes21" <vcortes@> wrote:
> >
> > How do you add a new table to an existing Crystal Report Dataset?
> > I have a report that was Created by a previous Employee and I need to add some new fields from the PartRev table, but when I add the table it adds it outside the Report Datset. Then after I Link the tables I get warring message "More then one dataset driver has been used in this report. If you want to change the database driver use database/Set Location."
> >
>
You have to make the table available in the dataset first in Epicor.
You do this under Report Data Definition, click on the report table tab,
click under the excluded fields....see if it is there first. If not
link the table here first!



THEN go to crystal and Update the report.



This should get you going...







M. Manasa Reddy

manasa@...

630.806.2000 x1515

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of vacortes21
Sent: Friday, August 26, 2011 2:19 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal Report Help!





I am working with a ODBC

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"c.krusen1" <ckrusen1@...> wrote:
>
> What type of reports is it? A "canned", BAQ, or ODBC?
>
> Calvin
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"vacortes21" <vcortes@> wrote:
> >
> > How do you add a new table to an existing Crystal Report Dataset?
> > I have a report that was Created by a previous Employee and I need
to add some new fields from the PartRev table, but when I add the table
it adds it outside the Report Datset. Then after I Link the tables I get
warring message "More then one dataset driver has been used in this
report. If you want to change the database driver use database/Set
Location."
> >
>





[Non-text portions of this message have been removed]
Thank you so much I was not aware of this. This is a big help should help me get a few other reports updated as well.

one more question, why is it that I cannot add a new table to this report? everything other then "New Report" is grayed out.

thanks again


--- In vantage@yahoogroups.com, "Manasa Reddy" <manasa@...> wrote:
>
> You have to make the table available in the dataset first in Epicor.
> You do this under Report Data Definition, click on the report table tab,
> click under the excluded fields....see if it is there first. If not
> link the table here first!
>
>
>
> THEN go to crystal and Update the report.
>
>
>
> This should get you going...
>
>
>
>
>
>
>
> M. Manasa Reddy
>
> manasa@...
>
> 630.806.2000 x1515
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of vacortes21
> Sent: Friday, August 26, 2011 2:19 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Crystal Report Help!
>
>
>
>
>
> I am working with a ODBC
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "c.krusen1" <ckrusen1@> wrote:
> >
> > What type of reports is it? A "canned", BAQ, or ODBC?
> >
> > Calvin
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "vacortes21" <vcortes@> wrote:
> > >
> > > How do you add a new table to an existing Crystal Report Dataset?
> > > I have a report that was Created by a previous Employee and I need
> to add some new fields from the PartRev table, but when I add the table
> it adds it outside the Report Datset. Then after I Link the tables I get
> warring message "More then one dataset driver has been used in this
> report. If you want to change the database driver use database/Set
> Location."
> > >
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
what version are you running?







M. Manasa Reddy

manasa@...

630.806.2000 x1515

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of vacortes21
Sent: Friday, August 26, 2011 2:51 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal Report Help!





Thank you so much I was not aware of this. This is a big help should
help me get a few other reports updated as well.

one more question, why is it that I cannot add a new table to this
report? everything other then "New Report" is grayed out.

thanks again

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Manasa Reddy" <manasa@...> wrote:
>
> You have to make the table available in the dataset first in Epicor.
> You do this under Report Data Definition, click on the report table
tab,
> click under the excluded fields....see if it is there first. If not
> link the table here first!
>
>
>
> THEN go to crystal and Update the report.
>
>
>
> This should get you going...
>
>
>
>
>
>
>
> M. Manasa Reddy
>
> manasa@...
>
> 630.806.2000 x1515
>
> ________________________________
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of vacortes21
> Sent: Friday, August 26, 2011 2:19 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Crystal Report Help!
>
>
>
>
>
> I am working with a ODBC
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
> "c.krusen1" <ckrusen1@> wrote:
> >
> > What type of reports is it? A "canned", BAQ, or ODBC?
> >
> > Calvin
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
> "vacortes21" <vcortes@> wrote:
> > >
> > > How do you add a new table to an existing Crystal Report Dataset?
> > > I have a report that was Created by a previous Employee and I need
> to add some new fields from the PartRev table, but when I add the
table
> it adds it outside the Report Datset. Then after I Link the tables I
get
> warring message "More then one dataset driver has been used in this
> report. If you want to change the database driver use database/Set
> Location."
> > >
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
we are running Vantage 8.03.409C

--- In vantage@yahoogroups.com, "Manasa Reddy" <manasa@...> wrote:
>
> what version are you running?
>
>
>
>
>
>
>
> M. Manasa Reddy
>
> manasa@...
>
> 630.806.2000 x1515
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of vacortes21
> Sent: Friday, August 26, 2011 2:51 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Crystal Report Help!
>
>
>
>
>
> Thank you so much I was not aware of this. This is a big help should
> help me get a few other reports updated as well.
>
> one more question, why is it that I cannot add a new table to this
> report? everything other then "New Report" is grayed out.
>
> thanks again
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Manasa Reddy" <manasa@> wrote:
> >
> > You have to make the table available in the dataset first in Epicor.
> > You do this under Report Data Definition, click on the report table
> tab,
> > click under the excluded fields....see if it is there first. If not
> > link the table here first!
> >
> >
> >
> > THEN go to crystal and Update the report.
> >
> >
> >
> > This should get you going...
> >
> >
> >
> >
> >
> >
> >
> > M. Manasa Reddy
> >
> > manasa@
> >
> > 630.806.2000 x1515
> >
> > ________________________________
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf
> > Of vacortes21
> > Sent: Friday, August 26, 2011 2:19 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Re: Crystal Report Help!
> >
> >
> >
> >
> >
> > I am working with a ODBC
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ,
> > "c.krusen1" <ckrusen1@> wrote:
> > >
> > > What type of reports is it? A "canned", BAQ, or ODBC?
> > >
> > > Calvin
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ,
> > "vacortes21" <vcortes@> wrote:
> > > >
> > > > How do you add a new table to an existing Crystal Report Dataset?
> > > > I have a report that was Created by a previous Employee and I need
> > to add some new fields from the PartRev table, but when I add the
> table
> > it adds it outside the Report Datset. Then after I Link the tables I
> get
> > warring message "More then one dataset driver has been used in this
> > report. If you want to change the database driver use database/Set
> > Location."
> > > >
> > >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
And you pulled the report in the program?



What is the name of the report?







M. Manasa Reddy

manasa@...

630.806.2000 x1515

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of vacortes21
Sent: Friday, August 26, 2011 3:49 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal Report Help!





we are running Vantage 8.03.409C

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Manasa Reddy" <manasa@...> wrote:
>
> what version are you running?
>
>
>
>
>
>
>
> M. Manasa Reddy
>
> manasa@...
>
> 630.806.2000 x1515
>
> ________________________________
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of vacortes21
> Sent: Friday, August 26, 2011 2:51 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Crystal Report Help!
>
>
>
>
>
> Thank you so much I was not aware of this. This is a big help should
> help me get a few other reports updated as well.
>
> one more question, why is it that I cannot add a new table to this
> report? everything other then "New Report" is grayed out.
>
> thanks again
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
> "Manasa Reddy" <manasa@> wrote:
> >
> > You have to make the table available in the dataset first in Epicor.
> > You do this under Report Data Definition, click on the report table
> tab,
> > click under the excluded fields....see if it is there first. If not
> > link the table here first!
> >
> >
> >
> > THEN go to crystal and Update the report.
> >
> >
> >
> > This should get you going...
> >
> >
> >
> >
> >
> >
> >
> > M. Manasa Reddy
> >
> > manasa@
> >
> > 630.806.2000 x1515
> >
> > ________________________________
> >
> > 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 vacortes21
> > Sent: Friday, August 26, 2011 2:19 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Re: Crystal Report Help!
> >
> >
> >
> >
> >
> > I am working with a ODBC
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ,
> > "c.krusen1" <ckrusen1@> wrote:
> > >
> > > What type of reports is it? A "canned", BAQ, or ODBC?
> > >
> > > Calvin
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ,
> > "vacortes21" <vcortes@> wrote:
> > > >
> > > > How do you add a new table to an existing Crystal Report
Dataset?
> > > > I have a report that was Created by a previous Employee and I
need
> > to add some new fields from the PartRev table, but when I add the
> table
> > it adds it outside the Report Datset. Then after I Link the tables I
> get
> > warring message "More then one dataset driver has been used in this
> > report. If you want to change the database driver use database/Set
> > Location."
> > > >
> > >
> >
> >
> >
> >
> >
> > [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]
I beleive I did. the report is "SchedShip" Scheduled Shipments Report

--- In vantage@yahoogroups.com, "Manasa Reddy" <manasa@...> wrote:
>
> And you pulled the report in the program?
>
>
>
> What is the name of the report?
>
>
>
>
>
>
>
> M. Manasa Reddy
>
> manasa@...
>
> 630.806.2000 x1515
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of vacortes21
> Sent: Friday, August 26, 2011 3:49 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Crystal Report Help!
>
>
>
>
>
> we are running Vantage 8.03.409C
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Manasa Reddy" <manasa@> wrote:
> >
> > what version are you running?
> >
> >
> >
> >
> >
> >
> >
> > M. Manasa Reddy
> >
> > manasa@
> >
> > 630.806.2000 x1515
> >
> > ________________________________
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf
> > Of vacortes21
> > Sent: Friday, August 26, 2011 2:51 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Re: Crystal Report Help!
> >
> >
> >
> >
> >
> > Thank you so much I was not aware of this. This is a big help should
> > help me get a few other reports updated as well.
> >
> > one more question, why is it that I cannot add a new table to this
> > report? everything other then "New Report" is grayed out.
> >
> > thanks again
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ,
> > "Manasa Reddy" <manasa@> wrote:
> > >
> > > You have to make the table available in the dataset first in Epicor.
> > > You do this under Report Data Definition, click on the report table
> > tab,
> > > click under the excluded fields....see if it is there first. If not
> > > link the table here first!
> > >
> > >
> > >
> > > THEN go to crystal and Update the report.
> > >
> > >
> > >
> > > This should get you going...
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > M. Manasa Reddy
> > >
> > > manasa@
> > >
> > > 630.806.2000 x1515
> > >
> > > ________________________________
> > >
> > > 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 vacortes21
> > > Sent: Friday, August 26, 2011 2:19 PM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Re: Crystal Report Help!
> > >
> > >
> > >
> > >
> > >
> > > I am working with a ODBC
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com> ,
> > > "c.krusen1" <ckrusen1@> wrote:
> > > >
> > > > What type of reports is it? A "canned", BAQ, or ODBC?
> > > >
> > > > Calvin
> > > >
> > > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com> ,
> > > "vacortes21" <vcortes@> wrote:
> > > > >
> > > > > How do you add a new table to an existing Crystal Report
> Dataset?
> > > > > I have a report that was Created by a previous Employee and I
> need
> > > to add some new fields from the PartRev table, but when I add the
> > table
> > > it adds it outside the Report Datset. Then after I Link the tables I
> > get
> > > warring message "More then one dataset driver has been used in this
> > > report. If you want to change the database driver use database/Set
> > > Location."
> > > > >
> > > >
> > >
> > >
> > >
> > >
> > >
> > > [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]
>
I am trying to add the PartRev table.

--- In vantage@yahoogroups.com, "vacortes21" <vcortes@...> wrote:
>
> I beleive I did. the report is "SchedShip" Scheduled Shipments Report
>
> --- In vantage@yahoogroups.com, "Manasa Reddy" <manasa@> wrote:
> >
> > And you pulled the report in the program?
> >
> >
> >
> > What is the name of the report?
> >
> >
> >
> >
> >
> >
> >
> > M. Manasa Reddy
> >
> > manasa@
> >
> > 630.806.2000 x1515
> >
> > ________________________________
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> > Of vacortes21
> > Sent: Friday, August 26, 2011 3:49 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re: Crystal Report Help!
> >
> >
> >
> >
> >
> > we are running Vantage 8.03.409C
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> > "Manasa Reddy" <manasa@> wrote:
> > >
> > > what version are you running?
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > M. Manasa Reddy
> > >
> > > manasa@
> > >
> > > 630.806.2000 x1515
> > >
> > > ________________________________
> > >
> > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> > Behalf
> > > Of vacortes21
> > > Sent: Friday, August 26, 2011 2:51 PM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Re: Crystal Report Help!
> > >
> > >
> > >
> > >
> > >
> > > Thank you so much I was not aware of this. This is a big help should
> > > help me get a few other reports updated as well.
> > >
> > > one more question, why is it that I cannot add a new table to this
> > > report? everything other then "New Report" is grayed out.
> > >
> > > thanks again
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com> ,
> > > "Manasa Reddy" <manasa@> wrote:
> > > >
> > > > You have to make the table available in the dataset first in Epicor.
> > > > You do this under Report Data Definition, click on the report table
> > > tab,
> > > > click under the excluded fields....see if it is there first. If not
> > > > link the table here first!
> > > >
> > > >
> > > >
> > > > THEN go to crystal and Update the report.
> > > >
> > > >
> > > >
> > > > This should get you going...
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > M. Manasa Reddy
> > > >
> > > > manasa@
> > > >
> > > > 630.806.2000 x1515
> > > >
> > > > ________________________________
> > > >
> > > > 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 vacortes21
> > > > Sent: Friday, August 26, 2011 2:19 PM
> > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > > > Subject: [Vantage] Re: Crystal Report Help!
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > I am working with a ODBC
> > > >
> > > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > > <mailto:vantage%40yahoogroups.com> ,
> > > > "c.krusen1" <ckrusen1@> wrote:
> > > > >
> > > > > What type of reports is it? A "canned", BAQ, or ODBC?
> > > > >
> > > > > Calvin
> > > > >
> > > > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > > <mailto:vantage%40yahoogroups.com> ,
> > > > "vacortes21" <vcortes@> wrote:
> > > > > >
> > > > > > How do you add a new table to an existing Crystal Report
> > Dataset?
> > > > > > I have a report that was Created by a previous Employee and I
> > need
> > > > to add some new fields from the PartRev table, but when I add the
> > > table
> > > > it adds it outside the Report Datset. Then after I Link the tables I
> > > get
> > > > warring message "More then one dataset driver has been used in this
> > > > report. If you want to change the database driver use database/Set
> > > > Location."
> > > > > >
> > > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > [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]
> >
>
I don't have version 8.03, but if you do not already have the part table
that could be the reason you are getting the error?



Check it out...







M. Manasa Reddy

manasa@...

630.806.2000 x1515

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of vacortes21
Sent: Friday, August 26, 2011 3:58 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal Report Help!





I am trying to add the PartRev table.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"vacortes21" <vcortes@...> wrote:
>
> I beleive I did. the report is "SchedShip" Scheduled Shipments Report
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Manasa Reddy" <manasa@> wrote:
> >
> > And you pulled the report in the program?
> >
> >
> >
> > What is the name of the report?
> >
> >
> >
> >
> >
> >
> >
> > M. Manasa Reddy
> >
> > manasa@
> >
> > 630.806.2000 x1515
> >
> > ________________________________
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> > Of vacortes21
> > Sent: Friday, August 26, 2011 3:49 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Re: Crystal Report Help!
> >
> >
> >
> >
> >
> > we are running Vantage 8.03.409C
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
> > "Manasa Reddy" <manasa@> wrote:
> > >
> > > what version are you running?
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > M. Manasa Reddy
> > >
> > > manasa@
> > >
> > > 630.806.2000 x1515
> > >
> > > ________________________________
> > >
> > > 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 vacortes21
> > > Sent: Friday, August 26, 2011 2:51 PM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Re: Crystal Report Help!
> > >
> > >
> > >
> > >
> > >
> > > Thank you so much I was not aware of this. This is a big help
should
> > > help me get a few other reports updated as well.
> > >
> > > one more question, why is it that I cannot add a new table to this
> > > report? everything other then "New Report" is grayed out.
> > >
> > > thanks again
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com> ,
> > > "Manasa Reddy" <manasa@> wrote:
> > > >
> > > > You have to make the table available in the dataset first in
Epicor.
> > > > You do this under Report Data Definition, click on the report
table
> > > tab,
> > > > click under the excluded fields....see if it is there first. If
not
> > > > link the table here first!
> > > >
> > > >
> > > >
> > > > THEN go to crystal and Update the report.
> > > >
> > > >
> > > >
> > > > This should get you going...
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > M. Manasa Reddy
> > > >
> > > > manasa@
> > > >
> > > > 630.806.2000 x1515
> > > >
> > > > ________________________________
> > > >
> > > > 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 vacortes21
> > > > Sent: Friday, August 26, 2011 2:19 PM
> > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > > > Subject: [Vantage] Re: Crystal Report Help!
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > I am working with a ODBC
> > > >
> > > > --- In vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > > <mailto:vantage%40yahoogroups.com> ,
> > > > "c.krusen1" <ckrusen1@> wrote:
> > > > >
> > > > > What type of reports is it? A "canned", BAQ, or ODBC?
> > > > >
> > > > > Calvin
> > > > >
> > > > > --- In vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > > <mailto:vantage%40yahoogroups.com> ,
> > > > "vacortes21" <vcortes@> wrote:
> > > > > >
> > > > > > How do you add a new table to an existing Crystal Report
> > Dataset?
> > > > > > I have a report that was Created by a previous Employee and
I
> > need
> > > > to add some new fields from the PartRev table, but when I add
the
> > > table
> > > > it adds it outside the Report Datset. Then after I Link the
tables I
> > > get
> > > > warring message "More then one dataset driver has been used in
this
> > > > report. If you want to change the database driver use
database/Set
> > > > Location."
> > > > > >
> > > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > [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]
You guys just inspired me to add (ShipHead.TrackingNumber) on the
ARForm. It finally worked.

Have a great weekend everyone.



Mike Tonoyan / Natel Engr.

mtonoyan@...



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Manasa Reddy
Sent: Friday, August 26, 2011 1:51 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Crystal Report Help!





And you pulled the report in the program?

What is the name of the report?

M. Manasa Reddy

manasa@... <mailto:manasa%40weldcoa.com>

630.806.2000 x1515

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of vacortes21
Sent: Friday, August 26, 2011 3:49 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Crystal Report Help!

we are running Vantage 8.03.409C

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
"Manasa Reddy" <manasa@...> wrote:
>
> what version are you running?
>
>
>
>
>
>
>
> M. Manasa Reddy
>
> manasa@...
>
> 630.806.2000 x1515
>
> ________________________________
>
> 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 vacortes21
> Sent: Friday, August 26, 2011 2:51 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Crystal Report Help!
>
>
>
>
>
> Thank you so much I was not aware of this. This is a big help should
> help me get a few other reports updated as well.
>
> one more question, why is it that I cannot add a new table to this
> report? everything other then "New Report" is grayed out.
>
> thanks again
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
> "Manasa Reddy" <manasa@> wrote:
> >
> > You have to make the table available in the dataset first in Epicor.
> > You do this under Report Data Definition, click on the report table
> tab,
> > click under the excluded fields....see if it is there first. If not
> > link the table here first!
> >
> >
> >
> > THEN go to crystal and Update the report.
> >
> >
> >
> > This should get you going...
> >
> >
> >
> >
> >
> >
> >
> > M. Manasa Reddy
> >
> > manasa@
> >
> > 630.806.2000 x1515
> >
> > ________________________________
> >
> > 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 vacortes21
> > Sent: Friday, August 26, 2011 2:19 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Re: Crystal Report Help!
> >
> >
> >
> >
> >
> > I am working with a ODBC
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ,
> > "c.krusen1" <ckrusen1@> wrote:
> > >
> > > What type of reports is it? A "canned", BAQ, or ODBC?
> > >
> > > Calvin
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ,
> > "vacortes21" <vcortes@> wrote:
> > > >
> > > > How do you add a new table to an existing Crystal Report
Dataset?
> > > > I have a report that was Created by a previous Employee and I
need
> > to add some new fields from the PartRev table, but when I add the
> table
> > it adds it outside the Report Datset. Then after I Link the tables I
> get
> > warring message "More then one dataset driver has been used in this
> > report. If you want to change the database driver use database/Set
> > Location."
> > > >
> > >
> >
> >
> >
> >
> >
> > [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]




______________________________________________________________________
Notice: This email transmission may contain confidential information and is intended only for the person(s) named. Any use, copying or disclosure to/by any other person(s) is strictly prohibited. By accepting this information, recipients confirm that they understand and will comply with all applicable ITAR and EAR requirements.
______________________________________________________________________

[Non-text portions of this message have been removed]
This is a system report - you need to make a copy before you can make any changes

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Manasa Reddy
Sent: Friday, August 26, 2011 4:02 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Crystal Report Help!



I don't have version 8.03, but if you do not already have the part table
that could be the reason you are getting the error?

Check it out...

M. Manasa Reddy

manasa@...<mailto:manasa%40weldcoa.com>

630.806.2000 x1515

________________________________

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of vacortes21
Sent: Friday, August 26, 2011 3:58 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Crystal Report Help!

I am trying to add the PartRev table.

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ,
"vacortes21" <vcortes@...> wrote:
>
> I beleive I did. the report is "SchedShip" Scheduled Shipments Report
>
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ,
"Manasa Reddy" <manasa@> wrote:
> >
> > And you pulled the report in the program?
> >
> >
> >
> > What is the name of the report?
> >
> >
> >
> >
> >
> >
> >
> > M. Manasa Reddy
> >
> > manasa@
> >
> > 630.806.2000 x1515
> >
> > ________________________________
> >
> > 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 vacortes21
> > Sent: Friday, August 26, 2011 3:49 PM
> > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Re: Crystal Report Help!
> >
> >
> >
> >
> >
> > we are running Vantage 8.03.409C
> >
> > --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
> > "Manasa Reddy" <manasa@> wrote:
> > >
> > > what version are you running?
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > M. Manasa Reddy
> > >
> > > manasa@
> > >
> > > 630.806.2000 x1515
> > >
> > > ________________________________
> > >
> > > 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 vacortes21
> > > Sent: Friday, August 26, 2011 2:51 PM
> > > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Re: Crystal Report Help!
> > >
> > >
> > >
> > >
> > >
> > > Thank you so much I was not aware of this. This is a big help
should
> > > help me get a few other reports updated as well.
> > >
> > > one more question, why is it that I cannot add a new table to this
> > > report? everything other then "New Report" is grayed out.
> > >
> > > thanks again
> > >
> > > --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com> ,
> > > "Manasa Reddy" <manasa@> wrote:
> > > >
> > > > You have to make the table available in the dataset first in
Epicor.
> > > > You do this under Report Data Definition, click on the report
table
> > > tab,
> > > > click under the excluded fields....see if it is there first. If
not
> > > > link the table here first!
> > > >
> > > >
> > > >
> > > > THEN go to crystal and Update the report.
> > > >
> > > >
> > > >
> > > > This should get you going...
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > M. Manasa Reddy
> > > >
> > > > manasa@
> > > >
> > > > 630.806.2000 x1515
> > > >
> > > > ________________________________
> > > >
> > > > 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 vacortes21
> > > > Sent: Friday, August 26, 2011 2:19 PM
> > > > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > > > Subject: [Vantage] Re: Crystal Report Help!
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > I am working with a ODBC
> > > >
> > > > --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > > <mailto:vantage%40yahoogroups.com> ,
> > > > "c.krusen1" <ckrusen1@> wrote:
> > > > >
> > > > > What type of reports is it? A "canned", BAQ, or ODBC?
> > > > >
> > > > > Calvin
> > > > >
> > > > > --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > > <mailto:vantage%40yahoogroups.com> ,
> > > > "vacortes21" <vcortes@> wrote:
> > > > > >
> > > > > > How do you add a new table to an existing Crystal Report
> > Dataset?
> > > > > > I have a report that was Created by a previous Employee and
I
> > need
> > > > to add some new fields from the PartRev table, but when I add
the
> > > table
> > > > it adds it outside the Report Datset. Then after I Link the
tables I
> > > get
> > > > warring message "More then one dataset driver has been used in
this
> > > > report. If you want to change the database driver use
database/Set
> > > > Location."
> > > > > >
> > > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > [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]



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