I am using crystal 10 and it works for me, sorry.
There is no way to do this within the ODBC data sources.
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of sharma_nalini
Sent: Wednesday, January 18, 2006 1:32 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: ODBC Connection to Crystal reports
I am using Crystal 8.5 and i don't see that option in set location
I also tried to find that in ODBC connections from control panel but
i didn't find the place to set the connection string.
There is no way to do this within the ODBC data sources.
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of sharma_nalini
Sent: Wednesday, January 18, 2006 1:32 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: ODBC Connection to Crystal reports
I am using Crystal 8.5 and i don't see that option in set location
I also tried to find that in ODBC connections from control panel but
i didn't find the place to set the connection string.
--- In vantage@yahoogroups.com, "Gerard Wadman" <gwadman@s...> wrote:
>
> You need to create a connection string to your ODBC DSN which
includes
> the PWD option.
>
>
>
> There are instructions in the group file library here:
> http://groups.yahoo.com/group/vantage/files/Reports%20-%20Crystal%
<http://groups.yahoo.com/group/vantage/files/Reports%20-%20Crystal%25>
20Repo
> rts/
>
>
>
> The file is called Crystal_DSN.pdf
>
>
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of sharma_nalini
> Sent: Wednesday, January 18, 2006 9:47 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: ODBC Connection to Crystal reports
>
>
>
> Hi,
>
> My outer join error is resolved, i ran the registery file again
which
> was in file section(just wanted to check if i made any mistakes)
>
> but rest of the issues are syill open.
>
> Thanks for helping me, atleast i can start some work.
>
> --- In vantage@yahoogroups.com, "Mesick, Todd" <tmesick@t...> wrote:
> >
> > You can edit the mfg file to keep the ODBC connection info.
> >
> > For the outer join need to make a reg entry change.
> >
> > puth the floowinging in a .reg file and run it
> >
> > REGEDIT4
> >
> > [HKEY_CURRENT_USER\Software\Seagate Software\Crystal
> > Reports\DatabaseOptions\OuterJoin]
> > "Informix"="QEINF506, QEINF507, qeinf509, qeinf709, crinf506,
> crinf507,
> > crinf509, crinf709, crinf11, crinf12, ivinf506, ivinf507,
ivinf509,
> > ivinf709, ixinf709, generic_inf7, ivinf11, ivinf12, sginf12"
> > "StarEqual"="sqlsrv32, sqlsrvr, qess03, qedbf03, qetxt03,
qexls03,
> crss03,
> > crdbf03, crtxt03, crxls03, qepdx03, QMDBF03, crtxt04, crxls04,
> crss04,
> > QEIDP06, QEBTR06, crsyb04, crsyb07, crsyb08, crsyb09, crsyb11,
> crsyb12,
> > SYIQNT, syiqnt, ivtxt12, ivsyb12,crdbm07, crdb207, crdb209,
crdb211,
> > crdb212, crxls507, crxls07, crss07, crtxt07, codrv16, _odrv16,
> codrv32,
> > sysyb, sysybw3, sysyb95, sysybnt, qesyb06, qess07, qess04,
qesyb04,
> qesyb07,
> > gppdx06, qess06, qebtr09, qmdbf06, ivdb212"
> > "Sql2OuterJoin"="wsqlodbc, simba, odbcjt16, odbcjt32, oddp,
odtss,
> osiris,
> > wod40w, wod40t, wod50w, wod50t, vfpodbc, sqrdb, sqrdb32, dmbbx,
> crwbw,
> > n32odbc, qbodbc, qbodbc32, Blint04, IVOING09, enhodbc3, cwbodbc,
> db2cli,
> > TDATA32"
> > "PlusEqual"="pgpro915, crora07,cror707,cror709,cror711, cror712,
> crxql07,
> > vsorac32, Relativity, crgup07, qeor706, crgup09, crgup11,
crgup12,
> sqora_73,
> > sqo32_73, oplodbc, w32btint, ivor709, lldriver, dhodbc, polite,
> sqrdb,
> > sqrdb32, ivor711, qmss04, sqora73,sqora7, sqora71, sqora,
sqo32_72,
> ivor712,
> > sgor712, sqora73n"
> > "OJSyntax"="ISCDRV32"
> > "OpenIngres"="ivpro15, ivpro915, ivpro14, ivpro914, oplodbc,
> oplodb32,
> > pgpro915"
> > "SpecialDll"="simclt32"
> > "PlusJoinDBMS"="oracle"
> > "StarJoinDBMS"=""
> > "Sql2JoinDBMS"=""
> > "AccessDriver"="odbcjt16, odbcjt32, qbodbc, qbodbc32, cwbodbc"
> > "SimbaDriver"="simba"
> >
> >
> >
> > -----Original Message-----
> > From: sharma_nalini [mailto:sharma_nalini@y...]
> > Sent: Wednesday, January 18, 2006 9:22 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] ODBC Connection to Crystal reports
> >
> >
> > HI All,
> >
> > I Don't know much about this odbc connection problems, please
help
> me
> > on that.
> >
> > 1. Is there a way to remember username and password for ODBC
> connection
> > for vantage.Every time we open the report we have to reenter the
> > password.
> >
> > 2. I am tryng to get fields from 2 tables in crystal from
vantage,
> but
> > when i drag the field from more than one table i get error
> messages:
> >
> > ODBC Error: The keyword Left outer join were not found in out
join
> > escape sequence.
> >
> > 3. Is there a way to do calculations based on main report and sub
> > report?
> >
> >
> >
> >
> >
> >
> > 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/>
> > <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
> >
> >
> >
> > * Visit your group " vantage
> <http://groups.yahoo.com/group/vantage>
> > " on the web.
> >
> >
> > * To unsubscribe from this group, send an email to:
> > vantage-unsubscribe@yahoogroups.com
> > <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
> >
> >
> > * Your use of Yahoo! Groups is subject to the Yahoo! Terms
of
> Service
> > <http://docs.yahoo.com/info/terms/> .
> >
> >
> > _____
> >
> >
> > TECT Proprietary & Confidential. This message, along with any
> attachments,
> > is intended only for the exclusive use of the individual or
entity
> to which
> > it is addressed and may contain information that is privileged,
> confidential
> > and exempt from disclosure. If you are not the intended
recipient,
> you are
> > hereby notified that any dissemination, distribution, or copying
of
> this
> > message, or any attachment, is strictly prohibited. If you have
> received
> > this message in error, please notify the original sender
> immediately by
> > return email, or by calling 229-228-2600, and delete the message,
> along with
> > any attachments, from your computer.
> >
> >
> > [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
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
>
>
>
>
> ________________________________
>
> YAHOO! GROUPS LINKS
>
>
>
> * Visit your group "vantage
> <http://groups.yahoo.com/group/vantage> " on the web.
>
> * To unsubscribe from this group, send an email to:
> vantage-unsubscribe@yahoogroups.com
> <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/> .
>
>
>
> ________________________________
>
>
>
> [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
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
SPONSORED LINKS
Manufacturing software
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Database
+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA>
Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ>
Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Data
base+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A>
Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Database+
marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg>
Database management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw>
Database marketing software
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manu
facturing+software&w2=Membership+database+software&w3=Database+mortgage+
software&w4=Pda+database+software&w5=Database+management+software&w6=Dat
abase+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw>
________________________________
YAHOO! GROUPS LINKS
* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
________________________________
[Non-text portions of this message have been removed]