Crystal reports SQL Server connection problem.

30 Jun 2005 4:19 AM

Marcos Beccar Varela

Hello, does anyone knows how to make a SQL Server connection from a string
not using the "wizard"? I have various reports and I need to make a
connection that when the parameters are changed in that string, all
connections in reports change too.
Thank you and sorry for my english!

30 Jun 2005 5:15 AM

Terry Olsen

http://www.connectionstrings.com

Show quote Hide quote

"Marcos Beccar Varela" <marcosbv@ga m a c o m .com.ar> wrote in message
news:OwNXXoSfFHA.2156@TK2MSFTNGP14.phx.gbl...
> Hello, does anyone knows how to make a SQL Server connection from a string
> not using the "wizard"? I have various reports and I need to make a
> connection that when the parameters are changed in that string, all
> connections in reports change too.
> Thank you and sorry for my english!
>

30 Jun 2005 7:14 AM

Peter Proost

Hi this is an example how you can change the connectionstring of a crystal
report:

http://groups.google.be/group/microsoft.public.dotnet.languages.vb/msg/a8936
29aeaa89fa1?hl=nl

hth Greetz Peter

--
Programming today is a race between software engineers striving to build
bigger and better idiot-proof programs, and the Universe trying to produce
bigger and better idiots. So far, the Universe is winning.

Show quoteHide quote

"Terry Olsen" <tolse***@hotmail.com> schreef in bericht
news:OtibILTfFHA.3940@tk2msftngp13.phx.gbl...
> http://www.connectionstrings.com
>
> "Marcos Beccar Varela" <marcosbv@ga m a c o m .com.ar> wrote in message
> news:OwNXXoSfFHA.2156@TK2MSFTNGP14.phx.gbl...
> > Hello, does anyone knows how to make a SQL Server connection from a
string
> > not using the "wizard"? I have various reports and I need to make a
> > connection that when the parameters are changed in that string, all
> > connections in reports change too.
> > Thank you and sorry for my english!
> >
>
>

30 Jun 2005 8:58 AM

Armin Zingler

"Marcos Beccar Varela" <marcosbv@ga m a c o m .com.ar> schrieb
> Hello, does anyone knows how to make a SQL Server connection from a
> string not using the "wizard"? I have various reports and I need to
> make a connection that when the parameters are changed in that
> string, all connections in reports change too.
> Thank you and sorry for my english!
>

http://msdn.microsoft.com/library/en-us/crystlmn/html/crtskaccessingsecuredatabases.asp

Armin