Crystal Report On Vantage 8.03 BD SQL Server 2005

system · February 17, 2009, 9:08am

Did you try adding another ODBC user with limited read only table
access and no password for that ODBC user?

--- In vantage@yahoogroups.com, "fnaslis" <fnaslis@...> wrote:
>
> Same thing, i also change the Use DSN Default Properties to TRUE in
> crystal report but the result is the same :(
>
> --- In vantage@yahoogroups.com, Bartosz Niemczewski
> <bartoszniemczewski@> wrote:
> >
> > Did you try LogonID , too?

system · February 13, 2009, 3:46pm

Hi all,

I'd like to add custom table on vantage existing report (Order
Acknowlegment), does someone know how to use the user sysprogress in
order to not having a user/ password prompt when opening the report.

Thanks in advance.
Fred.

system · February 13, 2009, 4:05pm

Fred,

A custom table? Meaning a non-Vantage table within the database?

If it's simply another Vantage system table, you should be modifying the Report Data Definition to get your tables joined, not ODBC.

However, if you do, in fact, have a non-standard Vantage table that you've created within the Mfgsys803 database, then ODBC is your only option.

Go to www.connectionstrings.com and you should be able to find a connection string there. Use that in your Crystal Reports report instead of an ODBC DSN.

Hth.

Vic

Vic Drecchio
ERP Administrator
TIMCO Aviation Services
Greensboro, NC
Email:Â Â vic.drecchio@...
Office:Â 336.668.4410 x3091
Mobile:Â 704.530.3092

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of fnaslis
Sent: Friday, February 13, 2009 3:47 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Report On Vantage 8.03 BD SQL Server 2005

Hi all,

I'd like to add custom table on vantage existing report (Order
Acknowlegment), does someone know how to use the user sysprogress in
order to not having a user/ password prompt when opening the report.

Thanks in advance.
Fred.

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

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

system · February 16, 2009, 11:34am

Thanks Vic,

That it i want to connect to other database, my point is taht i don't
want a login prompt as i got when i use a DSN.
Any Ideas ?
Maybe by use a RDO connectionstring property ?.

--- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...>
wrote:

>
> Fred,
>
> A custom table? Meaning a non-Vantage table within the database?
>
> If it's simply another Vantage system table, you should be

modifying the Report Data Definition to get your tables joined, not
ODBC.

>
> However, if you do, in fact, have a non-standard Vantage table that

you've created within the Mfgsys803 database, then ODBC is your only
option.

>
> Go to www.connectionstrings.com and you should be able to find a

connection string there. Use that in your Crystal Reports report
instead of an ODBC DSN.

>
> Hth.
>
>
>
> Vic
>
>
>
> Vic Drecchio
> ERP Administrator
> TIMCO Aviation Services
> Greensboro, NC
> Email:Â Â vic.drecchio@...
> Office:Â 336.668.4410 x3091
> Mobile:Â 704.530.3092
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On

Behalf Of fnaslis

> Sent: Friday, February 13, 2009 3:47 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Crystal Report On Vantage 8.03 BD SQL Server 2005
>
> Hi all,
>
> I'd like to add custom table on vantage existing report (Order
> Acknowlegment), does someone know how to use the user sysprogress

in

> order to not having a user/ password prompt when opening the report.
>
> Thanks in advance.
> Fred.
>
>
>
>
> ------------------------------------
>
> 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

>

system · February 16, 2009, 11:52am

In Registry for your odbc connection add two string keys UserName and password, then set your values for that parameters .

________________________________
From: fnaslis <fnaslis@...>
To: vantage@yahoogroups.com
Sent: Monday, February 16, 2009 10:34:16 AM
Subject: [Vantage] Re: Crystal Report On Vantage 8.03 BD SQL Server 2005

Thanks Vic,

That it i want to connect to other database, my point is taht i don't
want a login prompt as i got when i use a DSN.
Any Ideas ?
Maybe by use a RDO connectionstring property ?.

--- In vantage@yahoogroups .com, "Vic Drecchio" <vic.drecchio@ ...>
wrote:

>
> Fred,
>
> A custom table? Meaning a non-Vantage table within the database?
>
> If it's simply another Vantage system table, you should be

modifying the Report Data Definition to get your tables joined, not
ODBC.

>
> However, if you do, in fact, have a non-standard Vantage table that

you've created within the Mfgsys803 database, then ODBC is your only
option.

>
> Go to www.connectionstrin gs.com and you should be able to find a

connection string there. Use that in your Crystal Reports report
instead of an ODBC DSN.

>
> Hth.
>
>
>
> Vic
>
>
>
> Vic Drecchio
> ERP Administrator
> TIMCO Aviation Services
> Greensboro, NC
> Email:Â Â vic.drecchio@ ...
> Office:Â 336.668.4410 x3091
> Mobile:Â 704.530.3092
>
>
> -----Original Message-----
> From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On

Behalf Of fnaslis

> Sent: Friday, February 13, 2009 3:47 PM
> To: vantage@yahoogroups .com
> Subject: [Vantage] Crystal Report On Vantage 8.03 BD SQL Server 2005
>
> Hi all,
>
> I'd like to add custom table on vantage existing report (Order
> Acknowlegment) , does someone know how to use the user sysprogress

in

> order to not having a user/ password prompt when opening the report.
>
> Thanks in advance.
> Fred.
>
>
>
>
> ------------ --------- --------- ------
>
> 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

>

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

system · February 16, 2009, 12:35pm

Doesn't work either, also i add pwd and Uid and i m always prompt to
login :(
--- In vantage@yahoogroups.com, Bartosz Niemczewski
<bartoszniemczewski@...> wrote:

>
> In Registry for your odbc connection add two string keys UserName

and password, then set your values for that parameters .

>
>
>
>
> ________________________________
> From: fnaslis <fnaslis@...>
> To: vantage@yahoogroups.com
> Sent: Monday, February 16, 2009 10:34:16 AM
> Subject: [Vantage] Re: Crystal Report On Vantage 8.03 BD SQL Server

2005

>
>
> Thanks Vic,
>
> That it i want to connect to other database, my point is taht i

don't

> want a login prompt as i got when i use a DSN.
> Any Ideas ?
> Maybe by use a RDO connectionstring property ?.
>
> --- In vantage@yahoogroups .com, "Vic Drecchio" <vic.drecchio@ ...>
> wrote:
> >
> > Fred,
> >
> > A custom table? Meaning a non-Vantage table within the database?
> >
> > If it's simply another Vantage system table, you should be
> modifying the Report Data Definition to get your tables joined, not
> ODBC.
> >
> > However, if you do, in fact, have a non-standard Vantage table

that

> you've created within the Mfgsys803 database, then ODBC is your

only

> option.
> >
> > Go to www.connectionstrin gs.com and you should be able to find a
> connection string there. Use that in your Crystal Reports report
> instead of an ODBC DSN.
> >
> > Hth.
> >
> >
> >
> > Vic
> >
> >
> >
> > Vic Drecchio
> > ERP Administrator
> > TIMCO Aviation Services
> > Greensboro, NC
> > Email:Â Â vic.drecchio@ ...
> > Office:Â 336.668.4410 x3091
> > Mobile:Â 704.530.3092
> >
> >
> > -----Original Message-----
> > From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com]

On

> Behalf Of fnaslis
> > Sent: Friday, February 13, 2009 3:47 PM
> > To: vantage@yahoogroups .com
> > Subject: [Vantage] Crystal Report On Vantage 8.03 BD SQL Server

2005

> >
> > Hi all,
> >
> > I'd like to add custom table on vantage existing report (Order
> > Acknowlegment) , does someone know how to use the user

sysprogress

> in
> > order to not having a user/ password prompt when opening the

report.

> >
> > Thanks in advance.
> > Fred.
> >
> >
> >
> >
> > ------------ --------- --------- ------
> >
> > 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
> >
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

system · February 16, 2009, 12:57pm

Did you try LogonID , too?

________________________________
From: fnaslis <fnaslis@...>
To: vantage@yahoogroups.com
Sent: Monday, February 16, 2009 11:35:26 AM
Subject: [Vantage] Re: Crystal Report On Vantage 8.03 BD SQL Server 2005

Doesn't work either, also i add pwd and Uid and i m always prompt to
login :(
--- In vantage@yahoogroups .com, Bartosz Niemczewski
<bartoszniemczewski @...> wrote:

>
> In Registry for your odbc connection add two string keys UserName

and password, then set your values for that parameters .

>
>
>
>
> ____________ _________ _________ __
> From: fnaslis <fnaslis@... >
> To: vantage@yahoogroups .com
> Sent: Monday, February 16, 2009 10:34:16 AM
> Subject: [Vantage] Re: Crystal Report On Vantage 8.03 BD SQL Server

2005

>
>
> Thanks Vic,
>
> That it i want to connect to other database, my point is taht i

don't

> want a login prompt as i got when i use a DSN.
> Any Ideas ?
> Maybe by use a RDO connectionstring property ?.
>
> --- In vantage@yahoogroups .com, "Vic Drecchio" <vic.drecchio@ ...>
> wrote:
> >
> > Fred,
> >
> > A custom table? Meaning a non-Vantage table within the database?
> >
> > If it's simply another Vantage system table, you should be
> modifying the Report Data Definition to get your tables joined, not
> ODBC.
> >
> > However, if you do, in fact, have a non-standard Vantage table

that

> you've created within the Mfgsys803 database, then ODBC is your

only

> option.
> >
> > Go to www.connectionstrin gs.com and you should be able to find a
> connection string there. Use that in your Crystal Reports report
> instead of an ODBC DSN.
> >
> > Hth.
> >
> >
> >
> > Vic
> >
> >
> >
> > Vic Drecchio
> > ERP Administrator
> > TIMCO Aviation Services
> > Greensboro, NC
> > Email:Â Â vic.drecchio@ ...
> > Office:Â 336.668.4410 x3091
> > Mobile:Â 704.530.3092
> >
> >
> > -----Original Message-----
> > From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com]

On

> Behalf Of fnaslis
> > Sent: Friday, February 13, 2009 3:47 PM
> > To: vantage@yahoogroups .com
> > Subject: [Vantage] Crystal Report On Vantage 8.03 BD SQL Server

2005

> >
> > Hi all,
> >
> > I'd like to add custom table on vantage existing report (Order
> > Acknowlegment) , does someone know how to use the user

sysprogress

> in
> > order to not having a user/ password prompt when opening the

report.

> >
> > Thanks in advance.
> > Fred.
> >
> >
> >
> >
> > ------------ --------- --------- ------
> >
> > 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
> >
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

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

system · February 16, 2009, 1:20pm

Same thing, i also change the Use DSN Default Properties to TRUE in
crystal report but the result is the same :(

--- In vantage@yahoogroups.com, Bartosz Niemczewski
<bartoszniemczewski@...> wrote:

>
> Did you try LogonID , too?
>
>
>
>
> ________________________________
> From: fnaslis <fnaslis@...>
> To: vantage@yahoogroups.com
> Sent: Monday, February 16, 2009 11:35:26 AM
> Subject: [Vantage] Re: Crystal Report On Vantage 8.03 BD SQL Server

2005

>
>
> Doesn't work either, also i add pwd and Uid and i m always prompt

to

> login :(
> --- In vantage@yahoogroups .com, Bartosz Niemczewski
> <bartoszniemczewski @...> wrote:
> >
> > In Registry for your odbc connection add two string keys UserName
> and password, then set your values for that parameters .
> >
> >
> >
> >
> > ____________ _________ _________ __
> > From: fnaslis <fnaslis@ >
> > To: vantage@yahoogroups .com
> > Sent: Monday, February 16, 2009 10:34:16 AM
> > Subject: [Vantage] Re: Crystal Report On Vantage 8.03 BD SQL

Server

> 2005
> >
> >
> > Thanks Vic,
> >
> > That it i want to connect to other database, my point is taht i
> don't
> > want a login prompt as i got when i use a DSN.
> > Any Ideas ?
> > Maybe by use a RDO connectionstring property ?.
> >
> > --- In vantage@yahoogroups .com, "Vic Drecchio"

<vic.drecchio@ ...>

> > wrote:
> > >
> > > Fred,
> > >
> > > A custom table? Meaning a non-Vantage table within the database?
> > >
> > > If it's simply another Vantage system table, you should be
> > modifying the Report Data Definition to get your tables joined,

not

> > ODBC.
> > >
> > > However, if you do, in fact, have a non-standard Vantage table
> that
> > you've created within the Mfgsys803 database, then ODBC is your
> only
> > option.
> > >
> > > Go to www.connectionstrin gs.com and you should be able to find

a

> > connection string there. Use that in your Crystal Reports report
> > instead of an ODBC DSN.
> > >
> > > Hth.
> > >
> > >
> > >
> > > Vic
> > >
> > >
> > >
> > > Vic Drecchio
> > > ERP Administrator
> > > TIMCO Aviation Services
> > > Greensboro, NC
> > > Email:Â Â vic.drecchio@ ...
> > > Office:Â 336.668.4410 x3091
> > > Mobile:Â 704.530.3092
> > >
> > >
> > > -----Original Message-----
> > > From: vantage@yahoogroups .com [mailto:vantage@

yahoogroups .com]

> On
> > Behalf Of fnaslis
> > > Sent: Friday, February 13, 2009 3:47 PM
> > > To: vantage@yahoogroups .com
> > > Subject: [Vantage] Crystal Report On Vantage 8.03 BD SQL Server
> 2005
> > >
> > > Hi all,
> > >
> > > I'd like to add custom table on vantage existing report (Order
> > > Acknowlegment) , does someone know how to use the user
> sysprogress
> > in
> > > order to not having a user/ password prompt when opening the
> report.
> > >
> > > Thanks in advance.
> > > Fred.
> > >
> > >
> > >
> > >
> > > ------------ --------- --------- ------
> > >
> > > 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
> > >
> >
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

system · February 16, 2009, 3:34pm

Yes, Fred, in your database setup on the Crystal Reports report, use a connection string. Visit www.connectionstrings.com for a comprehensive list of connection strings to use.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of fnaslis
Sent: Monday, February 16, 2009 11:34 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal Report On Vantage 8.03 BD SQL Server 2005

Thanks Vic,

That it i want to connect to other database, my point is taht i don't
want a login prompt as i got when i use a DSN.
Any Ideas ?
Maybe by use a RDO connectionstring property ?.

--- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...>
wrote:

>
> Fred,
>
> A custom table? Meaning a non-Vantage table within the database?
>
> If it's simply another Vantage system table, you should be

modifying the Report Data Definition to get your tables joined, not
ODBC.

>
> However, if you do, in fact, have a non-standard Vantage table that

you've created within the Mfgsys803 database, then ODBC is your only
option.

>
> Go to www.connectionstrings.com and you should be able to find a

connection string there. Use that in your Crystal Reports report
instead of an ODBC DSN.

>
> Hth.
>
>
>
> Vic
>
>
>
> Vic Drecchio
> ERP Administrator
> TIMCO Aviation Services
> Greensboro, NC
> Email:Â Â vic.drecchio@...
> Office:Â 336.668.4410 x3091
> Mobile:Â 704.530.3092
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On

Behalf Of fnaslis

> Sent: Friday, February 13, 2009 3:47 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Crystal Report On Vantage 8.03 BD SQL Server 2005
>
> Hi all,
>
> I'd like to add custom table on vantage existing report (Order
> Acknowlegment), does someone know how to use the user sysprogress

in

> order to not having a user/ password prompt when opening the report.
>
> Thanks in advance.
> Fred.
>
>
>
>
> ------------------------------------
>
> 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

system · February 17, 2009, 8:44am

I already set a connectionstring and everything works fine in
Crystal , but i always got a login prompt when i load the report in
Vantage.

--- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...>
wrote:

>
> Yes, Fred, in your database setup on the Crystal Reports report,

use a connection string. Visit www.connectionstrings.com for a
comprehensive list of connection strings to use.

>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On

Behalf Of fnaslis

> Sent: Monday, February 16, 2009 11:34 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Crystal Report On Vantage 8.03 BD SQL Server

2005

>
> Thanks Vic,
>
> That it i want to connect to other database, my point is taht i

don't

> want a login prompt as i got when i use a DSN.
> Any Ideas ?
> Maybe by use a RDO connectionstring property ?.
>
> --- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@>
> wrote:
> >
> > Fred,
> >
> > A custom table? Meaning a non-Vantage table within the database?
> >
> > If it's simply another Vantage system table, you should be
> modifying the Report Data Definition to get your tables joined, not
> ODBC.
> >
> > However, if you do, in fact, have a non-standard Vantage table

that

> you've created within the Mfgsys803 database, then ODBC is your

only

> option.
> >
> > Go to www.connectionstrings.com and you should be able to find a
> connection string there. Use that in your Crystal Reports report
> instead of an ODBC DSN.
> >
> > Hth.
> >
> >
> >
> > Vic
> >
> >
> >
> > Vic Drecchio
> > ERP Administrator
> > TIMCO Aviation Services
> > Greensboro, NC
> > Email:Â Â vic.drecchio@
> > Office:Â 336.668.4410 x3091
> > Mobile:Â 704.530.3092
> >
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of fnaslis
> > Sent: Friday, February 13, 2009 3:47 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Crystal Report On Vantage 8.03 BD SQL Server

2005

> >
> > Hi all,
> >
> > I'd like to add custom table on vantage existing report (Order
> > Acknowlegment), does someone know how to use the user sysprogress
> in
> > order to not having a user/ password prompt when opening the

report.

> >
> > Thanks in advance.
> > Fred.
> >
> >
> >
> >
> > ------------------------------------
> >
> > 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

>

system · February 17, 2009, 9:01am

Have you populated the two fields on System Agent for ODBC Connection info?

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of fnaslis
Sent: Tuesday, February 17, 2009 8:45 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal Report On Vantage 8.03 BD SQL Server 2005

I already set a connectionstring and everything works fine in
Crystal , but i always got a login prompt when i load the report in
Vantage.

--- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...>
wrote:

>
> Yes, Fred, in your database setup on the Crystal Reports report,

use a connection string. Visit www.connectionstrings.com for a
comprehensive list of connection strings to use.

>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On

Behalf Of fnaslis

> Sent: Monday, February 16, 2009 11:34 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Crystal Report On Vantage 8.03 BD SQL Server

2005

>
> Thanks Vic,
>
> That it i want to connect to other database, my point is taht i

don't

> want a login prompt as i got when i use a DSN.
> Any Ideas ?
> Maybe by use a RDO connectionstring property ?.
>
> --- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@>
> wrote:
> >
> > Fred,
> >
> > A custom table? Meaning a non-Vantage table within the database?
> >
> > If it's simply another Vantage system table, you should be
> modifying the Report Data Definition to get your tables joined, not
> ODBC.
> >
> > However, if you do, in fact, have a non-standard Vantage table

that

> you've created within the Mfgsys803 database, then ODBC is your

only

> option.
> >
> > Go to www.connectionstrings.com and you should be able to find a
> connection string there. Use that in your Crystal Reports report
> instead of an ODBC DSN.
> >
> > Hth.
> >
> >
> >
> > Vic
> >
> >
> >
> > Vic Drecchio
> > ERP Administrator
> > TIMCO Aviation Services
> > Greensboro, NC
> > Email:Â Â vic.drecchio@
> > Office:Â 336.668.4410 x3091
> > Mobile:Â 704.530.3092
> >
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of fnaslis
> > Sent: Friday, February 13, 2009 3:47 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Crystal Report On Vantage 8.03 BD SQL Server

2005

> >
> > Hi all,
> >
> > I'd like to add custom table on vantage existing report (Order
> > Acknowlegment), does someone know how to use the user sysprogress
> in
> > order to not having a user/ password prompt when opening the

report.

> >
> > Thanks in advance.
> > Fred.
> >
> >
> >
> >
> > ------------------------------------
> >
> > 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

>

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

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