Crystal Reports DSN

How to set SystemDSN of a server to .rpt files SQL statements?

I want to set DSN names of .rpt files with the servers DSN names automatically.

I am using Crystal Reports Ver 7.0

Reply to this at the earliest...

Thanks
Kiran

Take a look at Crystal Report's LogOnInfo property - you can set this at runtime to connect to whatever server/database you need to.

------------------
Mark "Buzby" Beeton
VB Developer
[email protected]

Hi

Many thanks for ur reply,


Even though it is simple. I have not understood properly,

As u wrote "Log On Info" means Log On Server...

Here is the querry.

I have some .rpt fils in those files i used Oracle Server.

Actually, all my .rpt files are in IIS.

I am passing CGI script for user and password like follows:
http://testserver/osiwms/reports/rep...1)&prompt2=All

In the above example user = em; password = em;

I created a system DSN - Microsoft ODBC for Oracle, with userid - em, password - em and sid - orcl. in the testserver (SERVER)

I created the above report CategoryVolumeU.rpt file using the above details. I wanted to execute that URL at any client machine which is not having any DSNs, Crystalreports installed on it.

I could able to get it only this .rpt file is from the server which is having user-em, password-em and sid-orcl

If i copy the same .rpt file in another server which is having another SID., userid, Password

It is fine if it asks those details at runtime.

How to set it while creating a .rpt file...


Please help me to resolve the above problem

Thanks

regards,
Kiran

Pass a cc: to [email protected]