I have this exact same problem. I'm trying to add a table to the
quote form. I've successfully added missing fields from tables that
were already existing in the report but I can't seem to get Vantage
to add a missing table. I've been playing/fighting with this for
two days now. Has anyone successfully added a new table to an
existing crystal report in 8.0?
Thanks,
Mike
quote form. I've successfully added missing fields from tables that
were already existing in the report but I can't seem to get Vantage
to add a missing table. I've been playing/fighting with this for
two days now. Has anyone successfully added a new table to an
existing crystal report in 8.0?
Thanks,
Mike
--- In vantage@yahoogroups.com, "Carey S" <rotary1@...> wrote:
>
> Are you saying that they are not there if you manually inspect the
XML?
> Did you add a style and not have it applied to the printed report,
or did
> you just modify the original?
> Remember that once you make the change in the report definition,
you need to
> run the report to create the output file with the new xml data.
>
> Then, open the crystal reports developer and the rpt to modify.
>
> Choose the Database menu -> Set Datasource Location.
> In bottom half of the screen, click on + sign next to Create New
Connection.
> Click + sign next to ADO.NET.
> Connection to XML file screen, choose the button ... to the right.
> Browse to your Epicor\Mfgsysdata\Reports\Username(who printed the
PO in
> above steps)
> Find the latest ***.XML with the right created/modified date on it
(the file
> generated by the above steps)
> This XML file should now have in it the fields added in Report
Data
> Definitions.
> Select this particular XML file to bring it into the File Path:
field.
> Make sure both ReportDataSet options are highlighted and choose
the Update
> button on the right. Do the same thing with each ReportDataSet in
the top
> window.
> Click again on Database menu, choose Verify Database. Database is
up to date
> message.
> Click Close and Save.
> Those fields should now be available in the Field Explorer to add
to the
> Crystal form.
>
>
> If you have more questions, contact me offline and maybe I can be
of more
> step-by-step assistance.
> Carey
>
>
> >From: "brendan_butterworth" <brendan.butterworth@...>
> >Reply-To: vantage@yahoogroups.com
> >To: vantage@yahoogroups.com
> >Subject: [Vantage] Re: V8 Report Data
> >Date: Mon, 19 Jun 2006 22:45:41 -0000
> >
> >Thanks Carey,
> >
> >I have done all of that however i must have done something wrong,
In
> >the xml schema portion of the file the tables i added are defined
> >however the tables do not appear below in the data section, not
even
> >empty shells. This leads me to assume that even though i added the
> >tables in the report data maintenance vantage is not actually
> >outputing the data from those tables.
> >
> >Brendan
> >
> >--- In vantage@yahoogroups.com, "Carey S" <rotary1@> wrote:
> > >
> > > Brendan,
> > > The overall report setup is a lot of back and forth.
> > > Basically, you need to go to the report definition in V8 and
add
> >the tables
> > > cotaining the data you want to output from. Then go run the
report
> >in
> > > Vantage. Then you have to open Crystal Developer, and look in
the
> >user
> > > folder under mfgsysdata\reports to locate the newly created XML
> >file. Then,
> > > link in the new datasource(s) and add them to the report.
> > > Carey
> > >
> > >
> > > >From: "brendan_butterworth" <brendan.butterworth@>
> > > >Reply-To: vantage@yahoogroups.com
> > > >To: vantage@yahoogroups.com
> > > >Subject: [Vantage] V8 Report Data
> > > >Date: Mon, 19 Jun 2006 04:56:02 -0000
> > > >
> > > >Hi all i would like to add an additional table to one of my
> >crystal
> > > >reports using the data contained in the output data from
vantage
> >(XML
> > > >file)utililising ADO.net. Does anybody know how to tell
vantage to
> > > >send out information from another table in the xml output?
> > > >
> > > >Thanks
> > > >
> > > >Brendan Butterworth
> > > >
> > > >
> > > >
> > >
> >
> >
> >
> >
>