I am doing crystal reports in asp.net.When i run my .aspx page its giving below error.But When i see the my .aspx page in design mode result displaying correctly.Problem coulb be my code behind my code is like this .
Pl advice me where coulb be the problem.Actually i am doing windows authentication to connect to Sql Server.
thanks

Dim myReport = New cr1
Dim myTableLogonInfos = New CrystalDecisions.Shared.TableLogOnInfos
Dim myTableLogonInfo = New CrystalDecisions.Shared.TableLogOnInfo
Dim myConnectionInfo = New CrystalDecisions.Shared.ConnectionInfo
With myConnectionInfo
.ServerName = "mdt"
.DatabaseName = "Accounts"
End With
myTableLogonInfo.ConnectionInfo = myConnectionInfo
myTableLogonInfo.TableName = "accmst"
myTableLogonInfos.Add(myTableLogonInfo)
CrystalReportViewer1.LogOnInfo = myTableLogonInfos
CrystalReportViewer1.ReportSource = myReport
CrystalReportViewer1.DataBind()

Error Message:

Logon failed.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: CrystalDecisions.CrystalReports.Engine.LogOnExcept ion: Logon failed.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Hope this helps:

 Dim connInfo As New ConnectionInfo()

        Dim crDatabase As Database
        Dim crTables As Tables
        Dim crTable As Table
        Dim crLogOnInfo As TableLogOnInfo

        crDatabase = objReport.Database
        crTables = crDatabase.Tables

        For Each crTable In crTables
            With connInfo
                .ServerName = "SERVER"
                .UserID = "USERID"
                .Password = "PASSWORD"
            End With

            crLogOnInfo = crTable.LogOnInfo
            crLogOnInfo.ConnectionInfo = connInfo
            crTable.ApplyLogOnInfo(crLogOnInfo)

hi friend
this code definitely works for u
 U need to do is

steps:

1) when u r designing report select database source as odbc or oledb as u wish specifying userid and password and other details it asks

Now the report will be ready

2)Put a crystal report viewer on the web form
3)double click on crystal report viewer

dim objectname as new crystalreport1()

 Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

        objectname.SetDatabaseLogon("userid", "password")
        crystalreportviewer1.ReportSource = objectname
        crystalreportviewer1.Visible = True

    End Sub

This code works for u fine with out any problems

Even I am facing the same problem and solution suggested here is not the solution I am looking for.
I have my application connect to the SQL Server using Integrated Security; in this my application gives me an error "Invalid table number" and my code is as below:

            For inCtr = 0 To pobjReportObject.Database.Tables.Count - 1
                'Assinging Parameters
                crLogonInfo = pobjReportObject.Database.Tables(inCtr).LogOnInfo
                crLogonInfo.ConnectionInfo.ServerName = Framework.Classes.clsAppSettings.fnGetSetting(modC TConstants.CONST_REPORT_SERVER, Framework.Classes.clsFrameworkConfigs.enumSections .AppSettings)
                'crLogonInfo.ConnectionInfo.UserID = Framework.Classes.clsAppSettings.fnGetSetting(modC TConstants.CONST_REPORT_UID, Framework.Classes.clsFrameworkConfigs.enumSections .AppSettings)
                'crLogonInfo.ConnectionInfo.Password = Framework.Classes.clsAppSettings.fnGetSetting(modC TConstants.CONST_REPORT_PWD, Framework.Classes.clsFrameworkConfigs.enumSections .AppSettings)
                crLogonInfo.ConnectionInfo.DatabaseName = Framework.Classes.clsAppSettings.fnGetSetting(modC TConstants.CONST_REPORT_DATABASE, Framework.Classes.clsFrameworkConfigs.enumSections .AppSettings)
                pobjReportObject.Database.Tables(inCtr).ApplyLogOn Info(crLogonInfo)
                pobjReportObject.Database.Tables(inCtr).Location = crLogonInfo.ConnectionInfo.DatabaseName & ".dbo." & crLogonInfo.TableName
            Next


Please suggest