Hi all,

 I have a crystal report that is using a SQL server stored procedure as a datasource. The problem is i have selected the server and login at design time and when I move my application onto another machine where the SQL server has another name It does not work. Is there a way of specifying the server name and the stored procedure name from the Code?

Yes, you can change the server name and stored procedure name at run time.

 1) Import "CrystalDecisions.Shared" Namespace into your code.
 2) Use the following code.

        Dim objLogonInfo as New TableLogonInfo
        objLogonInfo.ConnectionInfo.ServerName = NewServer
        objLogonInfo.ConnectionInfo.DatabaseName = NewDatabase
        objLogonInfo.ConnectionInfo.UserID = NewUserId
        objLogonInfo.ConnectionInfo.Password = NewPassword

        Dim rptDocument as ReportDocument
        rptDocument = New ReportName

        Dim intIndex as int16
        For intIndex = 0 to rptDocument.Database.Tables.count -1
            rptDocument.Database.Tables(intIndex).ApplyLogOnIn fo(objLogonInfo)
            rptDocument.Database.Tables(intIndex).Location = NewStoredProcedure
        Next

        CrystalViewer1.ReportSource = rptDocument
        CrystalViewer1.DataBind()

:D cool that worked Thanx

hi sureshvb
i tried ur code but its not working for me

i have the same server but diff databse, they have common tablename, and design, i need to create generic report

dim objLogonInfo As New TableLogOnInfo

objLogonInfo.ConnectionInfo.DatabaseName = Module1.dbaseName

Dim rpt As New Report1
crViewer.ReportSource = rpt

our sql2000 is integrated with win2000 security settings
so i rmeoved the username,pasword

waiting for ur help,
tnx

its working for me right now, but the problem is i have two table on subreport
how do i change it

tnx