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