[Vantage 8.03] Crystal ODBC Reports

Yahoo Archive
1
I use the following FileDSN with Crystal. Not the same, I know, but
should be something similar:
[ODBC]
DRIVER=DataDirect 4.20 32-BIT OpenEdge SQL v10.0B
UID=SYSPROGRESS
HOST=Lemon
PORT=8350
DB=mfgsys803
DIL=READ UNCOMMITTED
PWD=sysprogress

The Driver Name is the same as shown on the Drivers tab of the ODBC
Administrator.
The DB name is the same as shown in the Progress Explorer Tool, not
the actual db name.
Your Port seems to be wrong - at least according to my setup. 8360
should point to the Training DB, 8350 points to the Live DB.

Hope that's some help.

Nigel.


--- In vantage@yahoogroups.com, "tsvantage" <bbutler@...> wrote:
>
> I am trying to connect my SQL server to Progress (OpenEdge 10B) via
> linked tables, and cannot seem to get the following provider
> (connection) string to work;
>
> DRIVER=DataDirect 4.20 32-Bit Progress SQL92
>
v10.0B;HOST=epicsvr;DB=mfgsys;UID=sysprogress;PWD=sysprogress;PORT=836
> 0;
>
> I can successfully test the connection with these exact parameters
> through ODBC. Anybody see what I might be missing?
>
> --- In vantage@yahoogroups.com, "laidig.systems" <laidig.systems@>
> wrote:
> >
> > Thanks so much Gary! It worked great!
> > Daniel
> >
> >
> > --- In vantage@yahoogroups.com, "Gary Parfrey" <garyp@> wrote:
> > >
> > > Daniel
> > >
> > >
> > >
> > > Go to http://www.connectionstrings.com/ to get a better
> understanding
> > >
> > >
> > >
> > > Your connection string for progress should look something like
> > >
> > >
> > >
> > > DRIVER=DataDirect 4.20 32-BIT OpenEdge SQL
> > >
>
v10.0B;DB=mfgsys;PORT=8050;HOST='servername'1;UID=sysprogress;Password
> =s
> > > ysprogress
> > >
> > >
> > >
> > > A connection string for SQL may look like the following
> > >
> > >
> > >
> > > Driver={SQL
> > >
> Server};Server='servername';Database=mfgsys;Trusted_Connection=yes;
> > >
> > >
> > >
> > > Gary
> > >
> > >
> > >
> > >
> > >
> > > ________________________________
> > >
> > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
On
> Behalf
> > > Of laidig.systems
> > > Sent: 05 February 2007 17:43
> > > To: vantage@yahoogroups.com
> > > Subject: [Vantage] Re: [Vantage 8.03] Crystal ODBC Reports
> > >
> > >
> > >
> > > When I try to create a new report using an ODBC connection, I
> don't
> > > see my database in the "Data Source Name" category. Gary had
> > > mentioned that you have to use an ODBC string. What does that
> mean?
> > > In my ODBC connection, i have the option of using "Enter
> Connection
> > > String" If that is what Gary is talking about, what would the
> string
> > > format look like?
> > >
> > > Thanks
> > >
> > > Daniel
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%
> 40yahoogroups.com> ,
> > > "Gary Parfrey" <garyp@> wrote:
> > > >
> > > >
> > > >
> > > > Connect through ODBC using an ODBC string to write reports.
You
> should
> > > > only really need to use the data definition for forms or
> embedded
> > > > reports.
> > > >
> > > >
> > > >
> > > > They also run a lot faster through ODBC
> > > >
> > > >
> > > >
> > > > Gary
> > >
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>
2
Could someone walk me through the process of adding a report to an
Action menu? For instance, in the sales order, i want a link under
Actions to be my custom report. Is this possible?
3
Also, for some reason, when I create a report from scratch, without
duplicating it, i can never get it to generate an xml file for me to
use. Any suggestions?


--- In vantage@yahoogroups.com, "laidig.systems" <laidig.systems@...>
wrote:
>
> Could someone walk me through the process of adding a report to an
> Action menu? For instance, in the sales order, i want a link under
> Actions to be my custom report. Is this possible?
>
4
You need the SDK in order to create new report data definitions.

In 8.03 they added the ability to create reports from BAQs.

Nice feature but not the same as being able to create new report data
defs.



Thanks,

Joe Rojas

IT Manager

TNCO, Inc.

781-447-6661 x7506

jrojas@...



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of laidig.systems
Sent: Friday, February 02, 2007 9:31 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: [Vantage 8.03] Add report to actions menu



Also, for some reason, when I create a report from scratch, without
duplicating it, i can never get it to generate an xml file for me to
use. Any suggestions?

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"laidig.systems" <laidig.systems@...>
wrote:
>
> Could someone walk me through the process of adding a report to an
> Action menu? For instance, in the sales order, i want a link under
> Actions to be my custom report. Is this possible?
>





[Non-text portions of this message have been removed]
5
Can i just duplicate an existing definition and get rid of all the
existing tabes in that definition and add my own without SDK?
How can i write any new reports otherwise? Can i get to my database
with crystal in a defferent way than by going through vantage and the
Data Definitions?

--- In vantage@yahoogroups.com, "Joe Rojas" <jrojas@...> wrote:
>
> You need the SDK in order to create new report data definitions.
>
> In 8.03 they added the ability to create reports from BAQs.
>
> Nice feature but not the same as being able to create new report
data
> defs.
>
>
>
> Thanks,
>
> Joe Rojas
>
> IT Manager
>
> TNCO, Inc.
>
> 781-447-6661 x7506
>
> jrojas@...
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of laidig.systems
> Sent: Friday, February 02, 2007 9:31 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: [Vantage 8.03] Add report to actions menu
>
>
>
> Also, for some reason, when I create a report from scratch, without
> duplicating it, i can never get it to generate an xml file for me to
> use. Any suggestions?
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "laidig.systems" <laidig.systems@>
> wrote:
> >
> > Could someone walk me through the process of adding a report to an
> > Action menu? For instance, in the sales order, i want a link under
> > Actions to be my custom report. Is this possible?
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
6
Connect through ODBC using an ODBC string to write reports. You should
only really need to use the data definition for forms or embedded
reports.



They also run a lot faster through ODBC



Gary





________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of laidig.systems
Sent: 04 February 2007 19:34
To: vantage@yahoogroups.com
Subject: [Vantage] Re: [Vantage 8.03] Add report to actions menu



Can i just duplicate an existing definition and get rid of all the
existing tabes in that definition and add my own without SDK?
How can i write any new reports otherwise? Can i get to my database
with crystal in a defferent way than by going through vantage and the
Data Definitions?

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Joe
Rojas" <jrojas@...> wrote:
>
> You need the SDK in order to create new report data definitions.
>
> In 8.03 they added the ability to create reports from BAQs.
>
> Nice feature but not the same as being able to create new report
data
> defs.
>
>
>
> Thanks,
>
> Joe Rojas
>
> IT Manager
>
> TNCO, Inc.
>
> 781-447-6661 x7506
>
> jrojas@...
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of laidig.systems
> Sent: Friday, February 02, 2007 9:31 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: [Vantage 8.03] Add report to actions menu
>
>
>
> Also, for some reason, when I create a report from scratch, without
> duplicating it, i can never get it to generate an xml file for me to
> use. Any suggestions?
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
> "laidig.systems" <laidig.systems@>
> wrote:
> >
> > Could someone walk me through the process of adding a report to an
> > Action menu? For instance, in the sales order, i want a link under
> > Actions to be my custom report. Is this possible?
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
7
When I try to create a new report using an ODBC connection, I don't
see my database in the "Data Source Name" category. Gary had
mentioned that you have to use an ODBC string. What does that mean?
In my ODBC connection, i have the option of using "Enter Connection
String" If that is what Gary is talking about, what would the string
format look like?

Thanks

Daniel


--- In vantage@yahoogroups.com, "Gary Parfrey" <garyp@...> wrote:
>
>
>
> Connect through ODBC using an ODBC string to write reports. You should
> only really need to use the data definition for forms or embedded
> reports.
>
>
>
> They also run a lot faster through ODBC
>
>
>
> Gary
8
Daniel



Go to http://www.connectionstrings.com/ to get a better understanding



Your connection string for progress should look something like



DRIVER=DataDirect 4.20 32-BIT OpenEdge SQL
v10.0B;DB=mfgsys;PORT=8050;HOST='servername'1;UID=sysprogress;Password=s
ysprogress



A connection string for SQL may look like the following



Driver={SQL
Server};Server='servername';Database=mfgsys;Trusted_Connection=yes;



Gary





________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of laidig.systems
Sent: 05 February 2007 17:43
To: vantage@yahoogroups.com
Subject: [Vantage] Re: [Vantage 8.03] Crystal ODBC Reports



When I try to create a new report using an ODBC connection, I don't
see my database in the "Data Source Name" category. Gary had
mentioned that you have to use an ODBC string. What does that mean?
In my ODBC connection, i have the option of using "Enter Connection
String" If that is what Gary is talking about, what would the string
format look like?

Thanks

Daniel

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Gary Parfrey" <garyp@...> wrote:
>
>
>
> Connect through ODBC using an ODBC string to write reports. You should
> only really need to use the data definition for forms or embedded
> reports.
>
>
>
> They also run a lot faster through ODBC
>
>
>
> Gary





[Non-text portions of this message have been removed]
9
Thanks so much Gary! It worked great!
Daniel


--- In vantage@yahoogroups.com, "Gary Parfrey" <garyp@...> wrote:
>
> Daniel
>
>
>
> Go to http://www.connectionstrings.com/ to get a better understanding
>
>
>
> Your connection string for progress should look something like
>
>
>
> DRIVER=DataDirect 4.20 32-BIT OpenEdge SQL
> v10.0B;DB=mfgsys;PORT=8050;HOST='servername'1;UID=sysprogress;Password=s
> ysprogress
>
>
>
> A connection string for SQL may look like the following
>
>
>
> Driver={SQL
> Server};Server='servername';Database=mfgsys;Trusted_Connection=yes;
>
>
>
> Gary
>
>
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of laidig.systems
> Sent: 05 February 2007 17:43
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: [Vantage 8.03] Crystal ODBC Reports
>
>
>
> When I try to create a new report using an ODBC connection, I don't
> see my database in the "Data Source Name" category. Gary had
> mentioned that you have to use an ODBC string. What does that mean?
> In my ODBC connection, i have the option of using "Enter Connection
> String" If that is what Gary is talking about, what would the string
> format look like?
>
> Thanks
>
> Daniel
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Gary Parfrey" <garyp@> wrote:
> >
> >
> >
> > Connect through ODBC using an ODBC string to write reports. You should
> > only really need to use the data definition for forms or embedded
> > reports.
> >
> >
> >
> > They also run a lot faster through ODBC
> >
> >
> >
> > Gary
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
10
I am trying to connect my SQL server to Progress (OpenEdge 10B) via
linked tables, and cannot seem to get the following provider
(connection) string to work;

DRIVER=DataDirect 4.20 32-Bit Progress SQL92
v10.0B;HOST=epicsvr;DB=mfgsys;UID=sysprogress;PWD=sysprogress;PORT=836
0;

I can successfully test the connection with these exact parameters
through ODBC. Anybody see what I might be missing?

--- In vantage@yahoogroups.com, "laidig.systems" <laidig.systems@...>
wrote:
>
> Thanks so much Gary! It worked great!
> Daniel
>
>
> --- In vantage@yahoogroups.com, "Gary Parfrey" <garyp@> wrote:
> >
> > Daniel
> >
> >
> >
> > Go to http://www.connectionstrings.com/ to get a better
understanding
> >
> >
> >
> > Your connection string for progress should look something like
> >
> >
> >
> > DRIVER=DataDirect 4.20 32-BIT OpenEdge SQL
> >
v10.0B;DB=mfgsys;PORT=8050;HOST='servername'1;UID=sysprogress;Password
=s
> > ysprogress
> >
> >
> >
> > A connection string for SQL may look like the following
> >
> >
> >
> > Driver={SQL
> >
Server};Server='servername';Database=mfgsys;Trusted_Connection=yes;
> >
> >
> >
> > Gary
> >
> >
> >
> >
> >
> > ________________________________
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> > Of laidig.systems
> > Sent: 05 February 2007 17:43
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re: [Vantage 8.03] Crystal ODBC Reports
> >
> >
> >
> > When I try to create a new report using an ODBC connection, I
don't
> > see my database in the "Data Source Name" category. Gary had
> > mentioned that you have to use an ODBC string. What does that
mean?
> > In my ODBC connection, i have the option of using "Enter
Connection
> > String" If that is what Gary is talking about, what would the
string
> > format look like?
> >
> > Thanks
> >
> > Daniel
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%
40yahoogroups.com> ,
> > "Gary Parfrey" <garyp@> wrote:
> > >
> > >
> > >
> > > Connect through ODBC using an ODBC string to write reports. You
should
> > > only really need to use the data definition for forms or
embedded
> > > reports.
> > >
> > >
> > >
> > > They also run a lot faster through ODBC
> > >
> > >
> > >
> > > Gary
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>