XML Files for Crystal Reports

Yahoo Archive
1
Matt,



In Report Data Maintenance for a copy of the Job Traveler, I added
JobProd and OrderHed using the Report Table tab.



With JobProd selected I go to the relationship tab and created a new
JobProd relation;

The parent table is Jobhead with JobNum as the key and the child table
is JobProd.



I added the Relationship fields of Company and JobNum (In this case the
parent and child fields had the same name.



Hope this helps?



Dale Schuerman

Sr. Consultant

RAM Software Systems, Inc.

972-669-0763

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Matt Caldwell
Sent: Monday, February 11, 2008 11:10 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: XML Files for Crystal Reports



Dale,

How did you define that key?

--Matt

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Dale Schuerman
Sent: Friday, February 08, 2008 3:31 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: XML Files for Crystal Reports

In version 8.03.403C, I was able to add a table to the report definition
and define the key to access the table.

This is without the SDK.

Dale Schuerman

Sr. Consultant

RAM Software Systems, Inc.

972-669-0763

________________________________

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 charles06072006
Sent: Friday, February 08, 2008 1:12 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: XML Files for Crystal Reports

Data can be added to an existing report very easily. However, you will
be limited to the data from the existing tables in the definition.
The addition of other tables to the definition will require the
purchase of the SDK module; well, at least getting data from the
tables. You can add them to the report definition but the data will
be blank when it hits Crystal.

The other option besides ODBC is to use BAQ reports. Most of the time
this functions very well and I use it for the majority of my reports.
There are occasions that I have to generate an ODBC report or use
ODBC for a subreport to a XML report. I actually prefer the latter
because of the ability to keep the report prompts consistent with
normal Vantage reports. This can be done completely transparent to the
user if everything is setup correctly.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> , Fons
van der Beek
<fons.vanderbeek@...> wrote:
>
> We added a table to the XML data definition for a purchase order, but
> it turned out that when there was no link to the added table
> (it was no standard vendorpart) we got an empty Crystal reports
report.
>
> We had to define two purchase orders: one for standard parts, one for
> non-standard parts.
>
>
> Todd Caughey schreef:
> > It had better or I am going to be really really PO'd. This is one
of the HUGE selling points for our upgrading from 6.1. I have been
told many times by Epicor that ODBC is virtually dead with regard to
Crystal as far as adding fields. It is all done via XML. Granted it
might also involve a seperate export but over the past 7 years I can't
count the number of times I've told users I can't add a given field
and what I have been told sounds like I will be able to do this. I'm
not sure if it would require a BAQ if it involves other tables to
create a file to suppliment the canned XML but it is supposed to be a
feature in 8.x to customize what is exported by the standard file
generators.
> > -Todd C.
> >
> > ________________________________
> > 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 Matt Caldwell
> > Sent: Friday, February 08, 2008 9:52 AM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] XML Files for Crystal Reports
> >
> >
> > Is there a way to manage the data that goes into the XML
> > files(\epicor\mfgsysdata\Reports\username) that Crystal Reports
uses to
> > print the reports out of Vantage? We would like to add more data
to the
> > Pick List, for example, as the canned Pick List isn't adequate
enough
> > for us. I really do not want to use ODBC to get the necessary data
> > into the report.
> >
> > Matt Caldwell
> > Technical Support Analyst
> >
> > KERUSSO
> > P.O. Box 32
> > Berryville, AR 72616
> > Phone: 800-424-0943 Ext. 231
> > Fax: 870-423-3568
> > Web Site: http://www.kerusso.com <http://www.kerusso.com>
<http://www.kerusso.com <http://www.kerusso.com> >
> > ******************************************************************
> > CONFIDENTIALITY STATEMENT:
> > This message, from Kerusso Inc., contains information
> > which is privileged and confidential and is solely for the use of
> > the intended recipient. If you are not the intended recipient, be
> > aware that any review, disclosure, copying, distribution, or use
> > of the contents of this message is strictly prohibited. If you have
> > received this in error, please destroy it and notify us immediately
> > at: 800-424-0943
> > ******************************************************************

.


<http://geo.yahoo.com/serv?s=97359714/grpId=20369/grpspId=1705007183/msg
Id=62498/stime=1202749789/nc1=4507179/nc2=3848641/nc3=4990214>



########################################################################
Attention:
This email message is privileged and confidential. If you are not the
intended recipient please delete the message and notify the sender.
Any views or opinions presented are solely those of the author.

This email message has been scanned for Viruses and Content and cleared
by MailMarshal SMTP

For more information go to http://www.ramsys.com
########################################################################


[Non-text portions of this message have been removed]
2
Is there a way to manage the data that goes into the XML
files(\epicor\mfgsysdata\Reports\username) that Crystal Reports uses to
print the reports out of Vantage? We would like to add more data to the
Pick List, for example, as the canned Pick List isn't adequate enough
for us. I really do not want to use ODBC to get the necessary data
into the report.



Matt Caldwell
Technical Support Analyst

KERUSSO
P.O. Box 32
Berryville, AR 72616
Phone: 800-424-0943 Ext. 231
Fax: 870-423-3568
Web Site: http://www.kerusso.com
******************************************************************
CONFIDENTIALITY STATEMENT:
This message, from Kerusso Inc., contains information
which is privileged and confidential and is solely for the use of
the intended recipient. If you are not the intended recipient, be
aware that any review, disclosure, copying, distribution, or use
of the contents of this message is strictly prohibited. If you have
received this in error, please destroy it and notify us immediately
at: 800-424-0943
******************************************************************





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



You would use the Data definitions or if more is required the SDK



Gary



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Matt Caldwell
Sent: 08 February 2008 15:52
To: vantage@yahoogroups.com
Subject: [Vantage] XML Files for Crystal Reports



Is there a way to manage the data that goes into the XML
files(\epicor\mfgsysdata\Reports\username) that Crystal Reports uses to
print the reports out of Vantage? We would like to add more data to the
Pick List, for example, as the canned Pick List isn't adequate enough
for us. I really do not want to use ODBC to get the necessary data
into the report.

Matt Caldwell
Technical Support Analyst

KERUSSO
P.O. Box 32
Berryville, AR 72616
Phone: 800-424-0943 Ext. 231
Fax: 870-423-3568
Web Site: http://www.kerusso.com
******************************************************************
CONFIDENTIALITY STATEMENT:
This message, from Kerusso Inc., contains information
which is privileged and confidential and is solely for the use of
the intended recipient. If you are not the intended recipient, be
aware that any review, disclosure, copying, distribution, or use
of the contents of this message is strictly prohibited. If you have
received this in error, please destroy it and notify us immediately
at: 800-424-0943
******************************************************************

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





[Non-text portions of this message have been removed]
4
It had better or I am going to be really really PO'd. This is one of the HUGE selling points for our upgrading from 6.1. I have been told many times by Epicor that ODBC is virtually dead with regard to Crystal as far as adding fields. It is all done via XML. Granted it might also involve a seperate export but over the past 7 years I can't count the number of times I've told users I can't add a given field and what I have been told sounds like I will be able to do this. I'm not sure if it would require a BAQ if it involves other tables to create a file to suppliment the canned XML but it is supposed to be a feature in 8.x to customize what is exported by the standard file generators.
-Todd C.

________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Matt Caldwell
Sent: Friday, February 08, 2008 9:52 AM
To: vantage@yahoogroups.com
Subject: [Vantage] XML Files for Crystal Reports


Is there a way to manage the data that goes into the XML
files(\epicor\mfgsysdata\Reports\username) that Crystal Reports uses to
print the reports out of Vantage? We would like to add more data to the
Pick List, for example, as the canned Pick List isn't adequate enough
for us. I really do not want to use ODBC to get the necessary data
into the report.

Matt Caldwell
Technical Support Analyst

KERUSSO
P.O. Box 32
Berryville, AR 72616
Phone: 800-424-0943 Ext. 231
Fax: 870-423-3568
Web Site: http://www.kerusso.com
******************************************************************
CONFIDENTIALITY STATEMENT:
This message, from Kerusso Inc., contains information
which is privileged and confidential and is solely for the use of
the intended recipient. If you are not the intended recipient, be
aware that any review, disclosure, copying, distribution, or use
of the contents of this message is strictly prohibited. If you have
received this in error, please destroy it and notify us immediately
at: 800-424-0943
******************************************************************

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





[Non-text portions of this message have been removed]
5
Looks like the Report Data Definitions will work! Thanks!



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Gary Parfrey
Sent: Friday, February 08, 2008 10:02 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] XML Files for Crystal Reports



Matt

You would use the Data definitions or if more is required the SDK

Gary

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Matt Caldwell
Sent: 08 February 2008 15:52
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] XML Files for Crystal Reports

Is there a way to manage the data that goes into the XML
files(\epicor\mfgsysdata\Reports\username) that Crystal Reports uses to
print the reports out of Vantage? We would like to add more data to the
Pick List, for example, as the canned Pick List isn't adequate enough
for us. I really do not want to use ODBC to get the necessary data
into the report.

Matt Caldwell
Technical Support Analyst

KERUSSO
P.O. Box 32
Berryville, AR 72616
Phone: 800-424-0943 Ext. 231
Fax: 870-423-3568
Web Site: http://www.kerusso.com
******************************************************************
CONFIDENTIALITY STATEMENT:
This message, from Kerusso Inc., contains information
which is privileged and confidential and is solely for the use of
the intended recipient. If you are not the intended recipient, be
aware that any review, disclosure, copying, distribution, or use
of the contents of this message is strictly prohibited. If you have
received this in error, please destroy it and notify us immediately
at: 800-424-0943
******************************************************************

[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]
6
2 points : We use ODBC on our Crystal Reports for version 8.03.305K,
& although it IS problematic at times, it works. We can add whatever
fields we need to, as long as they 'make sense' in the context of the
report itself and its underlying queries.

Second, I am beginning to prefer working on the 'Report Data
Definitions' and adding additional fields to THOSE, rather than deal
with all the 'Microsoft problems' that come along with ODBC. It's
simply cleaner, DOES involve a bit more work up front, BUT...the
reports will run faster as a bonus.

Gary

--- In vantage@yahoogroups.com, Todd Caughey <caugheyt@...> wrote:
>
> It had better or I am going to be really really PO'd. This is one
of the HUGE selling points for our upgrading from 6.1. I have been
told many times by Epicor that ODBC is virtually dead with regard to
Crystal as far as adding fields. It is all done via XML. Granted it
might also involve a seperate export but over the past 7 years I can't
count the number of times I've told users I can't add a given field
and what I have been told sounds like I will be able to do this. I'm
not sure if it would require a BAQ if it involves other tables to
create a file to suppliment the canned XML but it is supposed to be a
feature in 8.x to customize what is exported by the standard file
generators.
> -Todd C.
>
> ________________________________
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of Matt Caldwell
> Sent: Friday, February 08, 2008 9:52 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] XML Files for Crystal Reports
>
>
> Is there a way to manage the data that goes into the XML
> files(\epicor\mfgsysdata\Reports\username) that Crystal Reports uses to
> print the reports out of Vantage? We would like to add more data to the
> Pick List, for example, as the canned Pick List isn't adequate enough
> for us. I really do not want to use ODBC to get the necessary data
> into the report.
>
> Matt Caldwell
> Technical Support Analyst
>
> KERUSSO
> P.O. Box 32
> Berryville, AR 72616
> Phone: 800-424-0943 Ext. 231
> Fax: 870-423-3568
> Web Site: http://www.kerusso.com
> ******************************************************************
> CONFIDENTIALITY STATEMENT:
> This message, from Kerusso Inc., contains information
> which is privileged and confidential and is solely for the use of
> the intended recipient. If you are not the intended recipient, be
> aware that any review, disclosure, copying, distribution, or use
> of the contents of this message is strictly prohibited. If you have
> received this in error, please destroy it and notify us immediately
> at: 800-424-0943
> ******************************************************************
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
7
We added a table to the XML data definition for a purchase order, but
it turned out that when there was no link to the added table
(it was no standard vendorpart) we got an empty Crystal reports report.

We had to define two purchase orders: one for standard parts, one for
non-standard parts.


Todd Caughey schreef:
> It had better or I am going to be really really PO'd. This is one of the HUGE selling points for our upgrading from 6.1. I have been told many times by Epicor that ODBC is virtually dead with regard to Crystal as far as adding fields. It is all done via XML. Granted it might also involve a seperate export but over the past 7 years I can't count the number of times I've told users I can't add a given field and what I have been told sounds like I will be able to do this. I'm not sure if it would require a BAQ if it involves other tables to create a file to suppliment the canned XML but it is supposed to be a feature in 8.x to customize what is exported by the standard file generators.
> -Todd C.
>
> ________________________________
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Matt Caldwell
> Sent: Friday, February 08, 2008 9:52 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] XML Files for Crystal Reports
>
>
> Is there a way to manage the data that goes into the XML
> files(\epicor\mfgsysdata\Reports\username) that Crystal Reports uses to
> print the reports out of Vantage? We would like to add more data to the
> Pick List, for example, as the canned Pick List isn't adequate enough
> for us. I really do not want to use ODBC to get the necessary data
> into the report.
>
> Matt Caldwell
> Technical Support Analyst
>
> KERUSSO
> P.O. Box 32
> Berryville, AR 72616
> Phone: 800-424-0943 Ext. 231
> Fax: 870-423-3568
> Web Site: http://www.kerusso.com
> ******************************************************************
> CONFIDENTIALITY STATEMENT:
> This message, from Kerusso Inc., contains information
> which is privileged and confidential and is solely for the use of
> the intended recipient. If you are not the intended recipient, be
> aware that any review, disclosure, copying, distribution, or use
> of the contents of this message is strictly prohibited. If you have
> received this in error, please destroy it and notify us immediately
> at: 800-424-0943
> ******************************************************************
>
> [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/links
> Yahoo! Groups Links
>
>
>
>
8
Its been a while but you can add data to the pick list. We added the
unit of measure because it was missing. It goes something like this.

Edit the data definition in vantage for the picklist and save it with a
new name. Edit the crystal report so it uses the new data definition.
I can't remember the details but this should point you in the right
direction.



HTH

Mark D



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Matt Caldwell
Sent: Friday, February 08, 2008 10:52 AM
To: vantage@yahoogroups.com
Subject: [Vantage] XML Files for Crystal Reports



Is there a way to manage the data that goes into the XML
files(\epicor\mfgsysdata\Reports\username) that Crystal Reports uses to
print the reports out of Vantage? We would like to add more data to the
Pick List, for example, as the canned Pick List isn't adequate enough
for us. I really do not want to use ODBC to get the necessary data
into the report.

Matt Caldwell
Technical Support Analyst

KERUSSO
P.O. Box 32
Berryville, AR 72616
Phone: 800-424-0943 Ext. 231
Fax: 870-423-3568
Web Site: http://www.kerusso.com <http://www.kerusso.com>
******************************************************************
CONFIDENTIALITY STATEMENT:
This message, from Kerusso Inc., contains information
which is privileged and confidential and is solely for the use of
the intended recipient. If you are not the intended recipient, be
aware that any review, disclosure, copying, distribution, or use
of the contents of this message is strictly prohibited. If you have
received this in error, please destroy it and notify us immediately
at: 800-424-0943
******************************************************************

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





[Non-text portions of this message have been removed]
9
Data can be added to an existing report very easily. However, you will
be limited to the data from the existing tables in the definition.
The addition of other tables to the definition will require the
purchase of the SDK module; well, at least getting data from the
tables. You can add them to the report definition but the data will
be blank when it hits Crystal.

The other option besides ODBC is to use BAQ reports. Most of the time
this functions very well and I use it for the majority of my reports.
There are occasions that I have to generate an ODBC report or use
ODBC for a subreport to a XML report. I actually prefer the latter
because of the ability to keep the report prompts consistent with
normal Vantage reports. This can be done completely transparent to the
user if everything is setup correctly.

--- In vantage@yahoogroups.com, Fons van der Beek
<fons.vanderbeek@...> wrote:
>
> We added a table to the XML data definition for a purchase order, but
> it turned out that when there was no link to the added table
> (it was no standard vendorpart) we got an empty Crystal reports report.
>
> We had to define two purchase orders: one for standard parts, one for
> non-standard parts.
>
>
> Todd Caughey schreef:
> > It had better or I am going to be really really PO'd. This is one
of the HUGE selling points for our upgrading from 6.1. I have been
told many times by Epicor that ODBC is virtually dead with regard to
Crystal as far as adding fields. It is all done via XML. Granted it
might also involve a seperate export but over the past 7 years I can't
count the number of times I've told users I can't add a given field
and what I have been told sounds like I will be able to do this. I'm
not sure if it would require a BAQ if it involves other tables to
create a file to suppliment the canned XML but it is supposed to be a
feature in 8.x to customize what is exported by the standard file
generators.
> > -Todd C.
> >
> > ________________________________
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of Matt Caldwell
> > Sent: Friday, February 08, 2008 9:52 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] XML Files for Crystal Reports
> >
> >
> > Is there a way to manage the data that goes into the XML
> > files(\epicor\mfgsysdata\Reports\username) that Crystal Reports
uses to
> > print the reports out of Vantage? We would like to add more data
to the
> > Pick List, for example, as the canned Pick List isn't adequate enough
> > for us. I really do not want to use ODBC to get the necessary data
> > into the report.
> >
> > Matt Caldwell
> > Technical Support Analyst
> >
> > KERUSSO
> > P.O. Box 32
> > Berryville, AR 72616
> > Phone: 800-424-0943 Ext. 231
> > Fax: 870-423-3568
> > Web Site: http://www.kerusso.com
> > ******************************************************************
> > CONFIDENTIALITY STATEMENT:
> > This message, from Kerusso Inc., contains information
> > which is privileged and confidential and is solely for the use of
> > the intended recipient. If you are not the intended recipient, be
> > aware that any review, disclosure, copying, distribution, or use
> > of the contents of this message is strictly prohibited. If you have
> > received this in error, please destroy it and notify us immediately
> > at: 800-424-0943
> > ******************************************************************
> >
> > [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/links
> > Yahoo! Groups Links
> >
> >
> >
> >
>
10
In version 8.03.403C, I was able to add a table to the report definition
and define the key to access the table.

This is without the SDK.



Dale Schuerman

Sr. Consultant

RAM Software Systems, Inc.

972-669-0763

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of charles06072006
Sent: Friday, February 08, 2008 1:12 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: XML Files for Crystal Reports



Data can be added to an existing report very easily. However, you will
be limited to the data from the existing tables in the definition.
The addition of other tables to the definition will require the
purchase of the SDK module; well, at least getting data from the
tables. You can add them to the report definition but the data will
be blank when it hits Crystal.

The other option besides ODBC is to use BAQ reports. Most of the time
this functions very well and I use it for the majority of my reports.
There are occasions that I have to generate an ODBC report or use
ODBC for a subreport to a XML report. I actually prefer the latter
because of the ability to keep the report prompts consistent with
normal Vantage reports. This can be done completely transparent to the
user if everything is setup correctly.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Fons
van der Beek
<fons.vanderbeek@...> wrote:
>
> We added a table to the XML data definition for a purchase order, but
> it turned out that when there was no link to the added table
> (it was no standard vendorpart) we got an empty Crystal reports
report.
>
> We had to define two purchase orders: one for standard parts, one for
> non-standard parts.
>
>
> Todd Caughey schreef:
> > It had better or I am going to be really really PO'd. This is one
of the HUGE selling points for our upgrading from 6.1. I have been
told many times by Epicor that ODBC is virtually dead with regard to
Crystal as far as adding fields. It is all done via XML. Granted it
might also involve a seperate export but over the past 7 years I can't
count the number of times I've told users I can't add a given field
and what I have been told sounds like I will be able to do this. I'm
not sure if it would require a BAQ if it involves other tables to
create a file to suppliment the canned XML but it is supposed to be a
feature in 8.x to customize what is exported by the standard file
generators.
> > -Todd C.
> >
> > ________________________________
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Matt Caldwell
> > Sent: Friday, February 08, 2008 9:52 AM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] XML Files for Crystal Reports
> >
> >
> > Is there a way to manage the data that goes into the XML
> > files(\epicor\mfgsysdata\Reports\username) that Crystal Reports
uses to
> > print the reports out of Vantage? We would like to add more data
to the
> > Pick List, for example, as the canned Pick List isn't adequate
enough
> > for us. I really do not want to use ODBC to get the necessary data
> > into the report.
> >
> > Matt Caldwell
> > Technical Support Analyst
> >
> > KERUSSO
> > P.O. Box 32
> > Berryville, AR 72616
> > Phone: 800-424-0943 Ext. 231
> > Fax: 870-423-3568
> > Web Site: http://www.kerusso.com <http://www.kerusso.com>
> > ******************************************************************
> > CONFIDENTIALITY STATEMENT:
> > This message, from Kerusso Inc., contains information
> > which is privileged and confidential and is solely for the use of
> > the intended recipient. If you are not the intended recipient, be
> > aware that any review, disclosure, copying, distribution, or use
> > of the contents of this message is strictly prohibited. If you have
> > received this in error, please destroy it and notify us immediately
> > at: 800-424-0943
> > ******************************************************************
> >
> > [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/.
<http://groups.yahoo.com/group/vantage/files/>
> > (2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
> > (3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>
> > Yahoo! Groups Links
> >
> >
> >
> >
>




########################################################################
Attention:
This email message is privileged and confidential. If you are not the
intended recipient please delete the message and notify the sender.
Any views or opinions presented are solely those of the author.

This email message has been scanned for Viruses and Content and cleared
by MailMarshal SMTP

For more information go to http://www.ramsys.com
########################################################################


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

How did you define that key?



--Matt



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Dale Schuerman
Sent: Friday, February 08, 2008 3:31 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: XML Files for Crystal Reports



In version 8.03.403C, I was able to add a table to the report definition
and define the key to access the table.

This is without the SDK.

Dale Schuerman

Sr. Consultant

RAM Software Systems, Inc.

972-669-0763

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of charles06072006
Sent: Friday, February 08, 2008 1:12 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: XML Files for Crystal Reports

Data can be added to an existing report very easily. However, you will
be limited to the data from the existing tables in the definition.
The addition of other tables to the definition will require the
purchase of the SDK module; well, at least getting data from the
tables. You can add them to the report definition but the data will
be blank when it hits Crystal.

The other option besides ODBC is to use BAQ reports. Most of the time
this functions very well and I use it for the majority of my reports.
There are occasions that I have to generate an ODBC report or use
ODBC for a subreport to a XML report. I actually prefer the latter
because of the ability to keep the report prompts consistent with
normal Vantage reports. This can be done completely transparent to the
user if everything is setup correctly.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> , Fons
van der Beek
<fons.vanderbeek@...> wrote:
>
> We added a table to the XML data definition for a purchase order, but
> it turned out that when there was no link to the added table
> (it was no standard vendorpart) we got an empty Crystal reports
report.
>
> We had to define two purchase orders: one for standard parts, one for
> non-standard parts.
>
>
> Todd Caughey schreef:
> > It had better or I am going to be really really PO'd. This is one
of the HUGE selling points for our upgrading from 6.1. I have been
told many times by Epicor that ODBC is virtually dead with regard to
Crystal as far as adding fields. It is all done via XML. Granted it
might also involve a seperate export but over the past 7 years I can't
count the number of times I've told users I can't add a given field
and what I have been told sounds like I will be able to do this. I'm
not sure if it would require a BAQ if it involves other tables to
create a file to suppliment the canned XML but it is supposed to be a
feature in 8.x to customize what is exported by the standard file
generators.
> > -Todd C.
> >
> > ________________________________
> > 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 Matt Caldwell
> > Sent: Friday, February 08, 2008 9:52 AM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] XML Files for Crystal Reports
> >
> >
> > Is there a way to manage the data that goes into the XML
> > files(\epicor\mfgsysdata\Reports\username) that Crystal Reports
uses to
> > print the reports out of Vantage? We would like to add more data
to the
> > Pick List, for example, as the canned Pick List isn't adequate
enough
> > for us. I really do not want to use ODBC to get the necessary data
> > into the report.
> >
> > Matt Caldwell
> > Technical Support Analyst
> >
> > KERUSSO
> > P.O. Box 32
> > Berryville, AR 72616
> > Phone: 800-424-0943 Ext. 231
> > Fax: 870-423-3568
> > Web Site: http://www.kerusso.com <http://www.kerusso.com>
> > ******************************************************************
> > CONFIDENTIALITY STATEMENT:
> > This message, from Kerusso Inc., contains information
> > which is privileged and confidential and is solely for the use of
> > the intended recipient. If you are not the intended recipient, be
> > aware that any review, disclosure, copying, distribution, or use
> > of the contents of this message is strictly prohibited. If you have
> > received this in error, please destroy it and notify us immediately
> > at: 800-424-0943
> > ******************************************************************
> >
> > [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/.
<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
<http://groups.yahoo.com/group/vantage/messages>
> > (3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>
> > Yahoo! Groups Links
> >
> >
> >
> >
>

########################################################################
Attention:
This email message is privileged and confidential. If you are not the
intended recipient please delete the message and notify the sender.
Any views or opinions presented are solely those of the author.

This email message has been scanned for Viruses and Content and cleared
by MailMarshal SMTP

For more information go to http://www.ramsys.com
########################################################################

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





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