Crystal XI Database Connect Document

Yahoo Archive
1
I would actually second that. Once you know the 'fundamentals' so to
speak, it opens up quite a large amount of capabilities. The book
actually has a lot of code samples as well. I've complimented the book
with Epicor's CR/Tooltips/Answerbook search options online as well as
searching the archives of this list for code samples. I've tried to
document some of mine on this list for posterity too.

If you're going to Perspectives, you can order a book and pick it up
while you're there. I've ordered a 2nd copy for distribution
internally.

Ken

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Craig Weiss
Sent: Friday, August 29, 2008 6:39 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal XI Database Connect Document



I strongly recommend the Epicor Tools User Guide for anyone trying to
learn all of the customization features. It has very good
explanations of BAQs, BAQ Reports (Using Crystal), Dashboards,
BAMs,BPMs, etc... You can order it through your Epicor sales person.
Craig

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
<dmaddox@...> wrote:
>
> Lynn,
>
> By perusing #4778MPS, I was able to get to #7567MPS, which provides
instructions on how to add new tables to the Report Definition
Database. While I am still slogging through the details of getting
there, it looks like your answer was a good one.
>
> Dan Maddox
>
> ---- Lynn <lynn.khalife@...> wrote:
> > Perhaps these are the instructions you are looking for: See
> > AnswerBook # 4778MPS on the Epicor website. The topic name of
the
> > AnswerBook is "CR Modifying a Crystal Report form in V8.xx"
> >
> > These are the instructions for ADO.NET.
> >
> > There are instructions for ODBC in the Vantage help screens. And
> > there are a couple of AnswerBooks on the website for bypassing
the
> > username & password if you are using ODBC.
> >
> > Lynn
> >
> >
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Ross Hughes" <ross.hughes@>
wrote:
> > >
> > > I have never seen that document.
> > >
> > > You are either going to connect via ODBC or through ADO.NET
(XML).
> > >
> > > Assuming a report is already created you need to select select
> > Database Expert from the Database menu and choose your
datasource.
> > If it is ODBC you will grab that. It if BAQ or Vantage-driven
you
> > will go for the XML type and grab the associated XML file in the
> > mfgsysdata/reports/[username] folder. You will have to have run
the
> > XML generating report before it will show up the reports folder.
> > >
> > > With a little more information on your direction I can be more
> > specific.
> > >
> > > Ross
> > >
> > > -----Original Message-----
> > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ]
On
> > Behalf Of dmaddox@
> > > Sent: Thursday, August 28, 2008 11:59 AM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Crystal XI Database Connect Document
> > >
> > > I do not have the document onhand for "how to connect Crystal
XI to
> > your V8 database."
> > >
> > > Could someone please forward?
> > >
> > > Thanks,
> > > Dan Maddox
> > >
> > > ------------------------------------
> > >
> > > 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/linksYahoo
<http://groups.yahoo.com/group/vantage/linksYahoo> ! Groups Links
> > >
> >
> >
> >
> > ------------------------------------
> >
> > 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/linksYahoo
<http://groups.yahoo.com/group/vantage/linksYahoo> ! Groups Links
> >
> >
> >
>






[Non-text portions of this message have been removed]
2
I do not have the document onhand for "how to connect Crystal XI to your V8 database."

Could someone please forward?

Thanks,
Dan Maddox
3
I have never seen that document.

You are either going to connect via ODBC or through ADO.NET(XML).

Assuming a report is already created you need to select select Database Expert from the Database menu and choose your datasource. If it is ODBC you will grab that. It if BAQ or Vantage-driven you will go for the XML type and grab the associated XML file in the mfgsysdata/reports/[username] folder. You will have to have run the XML generating report before it will show up the reports folder.

With a little more information on your direction I can be more specific.

Ross

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of dmaddox@...
Sent: Thursday, August 28, 2008 11:59 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal XI Database Connect Document

I do not have the document onhand for "how to connect Crystal XI to your V8 database."

Could someone please forward?

Thanks,
Dan Maddox

------------------------------------

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
4
Perhaps these are the instructions you are looking for: See
AnswerBook # 4778MPS on the Epicor website. The topic name of the
AnswerBook is "CR Modifying a Crystal Report form in V8.xx"

These are the instructions for ADO.NET.

There are instructions for ODBC in the Vantage help screens. And
there are a couple of AnswerBooks on the website for bypassing the
username & password if you are using ODBC.

Lynn



--- In vantage@yahoogroups.com, "Ross Hughes" <ross.hughes@...> wrote:
>
> I have never seen that document.
>
> You are either going to connect via ODBC or through ADO.NET(XML).
>
> Assuming a report is already created you need to select select
Database Expert from the Database menu and choose your datasource.
If it is ODBC you will grab that. It if BAQ or Vantage-driven you
will go for the XML type and grab the associated XML file in the
mfgsysdata/reports/[username] folder. You will have to have run the
XML generating report before it will show up the reports folder.
>
> With a little more information on your direction I can be more
specific.
>
> Ross
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of dmaddox@...
> Sent: Thursday, August 28, 2008 11:59 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Crystal XI Database Connect Document
>
> I do not have the document onhand for "how to connect Crystal XI to
your V8 database."
>
> Could someone please forward?
>
> Thanks,
> Dan Maddox
>
> ------------------------------------
>
> 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
>
5
Thanks, Lynn. I'll give this a look

Dan Maddox

---- Lynn <lynn.khalife@...> wrote:
> Perhaps these are the instructions you are looking for: See
> AnswerBook # 4778MPS on the Epicor website. The topic name of the
> AnswerBook is "CR Modifying a Crystal Report form in V8.xx"
>
> These are the instructions for ADO.NET.
>
> There are instructions for ODBC in the Vantage help screens. And
> there are a couple of AnswerBooks on the website for bypassing the
> username & password if you are using ODBC.
>
> Lynn
>
>
>
> --- In vantage@yahoogroups.com, "Ross Hughes" <ross.hughes@...> wrote:
> >
> > I have never seen that document.
> >
> > You are either going to connect via ODBC or through ADO.NET(XML).
> >
> > Assuming a report is already created you need to select select
> Database Expert from the Database menu and choose your datasource.
> If it is ODBC you will grab that. It if BAQ or Vantage-driven you
> will go for the XML type and grab the associated XML file in the
> mfgsysdata/reports/[username] folder. You will have to have run the
> XML generating report before it will show up the reports folder.
> >
> > With a little more information on your direction I can be more
> specific.
> >
> > Ross
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of dmaddox@...
> > Sent: Thursday, August 28, 2008 11:59 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Crystal XI Database Connect Document
> >
> > I do not have the document onhand for "how to connect Crystal XI to
> your V8 database."
> >
> > Could someone please forward?
> >
> > Thanks,
> > Dan Maddox
> >
> > ------------------------------------
> >
> > 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
> >
>
>
>
> ------------------------------------
>
> 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
>
>
>
6
Lynn,

By perusing #4778MPS, I was able to get to #7567MPS, which provides instructions on how to add new tables to the Report Definition Database. While I am still slogging through the details of getting there, it looks like your answer was a good one.

Dan Maddox

---- Lynn <lynn.khalife@...> wrote:
> Perhaps these are the instructions you are looking for: See
> AnswerBook # 4778MPS on the Epicor website. The topic name of the
> AnswerBook is "CR Modifying a Crystal Report form in V8.xx"
>
> These are the instructions for ADO.NET.
>
> There are instructions for ODBC in the Vantage help screens. And
> there are a couple of AnswerBooks on the website for bypassing the
> username & password if you are using ODBC.
>
> Lynn
>
>
>
> --- In vantage@yahoogroups.com, "Ross Hughes" <ross.hughes@...> wrote:
> >
> > I have never seen that document.
> >
> > You are either going to connect via ODBC or through ADO.NET(XML).
> >
> > Assuming a report is already created you need to select select
> Database Expert from the Database menu and choose your datasource.
> If it is ODBC you will grab that. It if BAQ or Vantage-driven you
> will go for the XML type and grab the associated XML file in the
> mfgsysdata/reports/[username] folder. You will have to have run the
> XML generating report before it will show up the reports folder.
> >
> > With a little more information on your direction I can be more
> specific.
> >
> > Ross
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of dmaddox@...
> > Sent: Thursday, August 28, 2008 11:59 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Crystal XI Database Connect Document
> >
> > I do not have the document onhand for "how to connect Crystal XI to
> your V8 database."
> >
> > Could someone please forward?
> >
> > Thanks,
> > Dan Maddox
> >
> > ------------------------------------
> >
> > 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
> >
>
>
>
> ------------------------------------
>
> 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
>
>
>
7
I strongly recommend the Epicor Tools User Guide for anyone trying to
learn all of the customization features. It has very good
explanations of BAQs, BAQ Reports (Using Crystal), Dashboards,
BAMs,BPMs, etc... You can order it through your Epicor sales person.
Craig

--- In vantage@yahoogroups.com, <dmaddox@...> wrote:
>
> Lynn,
>
> By perusing #4778MPS, I was able to get to #7567MPS, which provides
instructions on how to add new tables to the Report Definition
Database. While I am still slogging through the details of getting
there, it looks like your answer was a good one.
>
> Dan Maddox
>
> ---- Lynn <lynn.khalife@...> wrote:
> > Perhaps these are the instructions you are looking for: See
> > AnswerBook # 4778MPS on the Epicor website. The topic name of
the
> > AnswerBook is "CR Modifying a Crystal Report form in V8.xx"
> >
> > These are the instructions for ADO.NET.
> >
> > There are instructions for ODBC in the Vantage help screens. And
> > there are a couple of AnswerBooks on the website for bypassing
the
> > username & password if you are using ODBC.
> >
> > Lynn
> >
> >
> >
> > --- In vantage@yahoogroups.com, "Ross Hughes" <ross.hughes@>
wrote:
> > >
> > > I have never seen that document.
> > >
> > > You are either going to connect via ODBC or through ADO.NET
(XML).
> > >
> > > Assuming a report is already created you need to select select
> > Database Expert from the Database menu and choose your
datasource.
> > If it is ODBC you will grab that. It if BAQ or Vantage-driven
you
> > will go for the XML type and grab the associated XML file in the
> > mfgsysdata/reports/[username] folder. You will have to have run
the
> > XML generating report before it will show up the reports folder.
> > >
> > > With a little more information on your direction I can be more
> > specific.
> > >
> > > Ross
> > >
> > > -----Original Message-----
> > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
On
> > Behalf Of dmaddox@
> > > Sent: Thursday, August 28, 2008 11:59 AM
> > > To: vantage@yahoogroups.com
> > > Subject: [Vantage] Crystal XI Database Connect Document
> > >
> > > I do not have the document onhand for "how to connect Crystal
XI to
> > your V8 database."
> > >
> > > Could someone please forward?
> > >
> > > Thanks,
> > > Dan Maddox
> > >
> > > ------------------------------------
> > >
> > > 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
> > >
> >
> >
> >
> > ------------------------------------
> >
> > 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
> >
> >
> >
>