I m facing crystal report problems.
I m connecting VB with crystal report with sql server.
When i m connecting crystal report with dsn to SQl Server and calling it from vb its working.But I want to dynamically connect Crystal report with the same connection object as in VB code.How can i do it

Hello Sujoy

try to Set Database Logon method of the report object by passing the values to it.
Its basically used when you create a report w.r.t one SQL server (namely SQLSVR01
for ex) and you want to deploy to another machine where the SQL SERVER name is
diff. So this time you can set the database logon info of the new SQL SERVER
and report will re-links the report object (TABLE or SP) fro new DB.

Hope this helps

With Regards,
Raghavendra Mudugal