why is it that when i have join statement in my query string and run my report there's a dialog box will show asking for Server Name, Database, User Name and Password? but if i read on 1 table in the database it works fine. im using the cr which is bundled in visual studio .net. i really have trouble with this and i need ur help. i tried searching in google but i haven't found any answer. any suggestions or code snippet will be greatly appreciated!

regards

Hi,

  You need to provide DB details explicitly to the report.

Try with below block
'-----------------------------

 Private Sub LogOnReport(ByVal cr As CrystalDecisions.CrystalReports.Engine.ReportDocum ent)
        Dim myTable As CrystalDecisions.CrystalReports.Engine.Table
        Dim myLogin As CrystalDecisions.Shared.TableLogOnInfo
        For Each myTable In cr.Database.Tables
            myLogin = myTable.LogOnInfo
            myLogin.ConnectionInfo.ServerName = strInfo(0)
            myLogin.ConnectionInfo.DatabaseName = strInfo(1)
            myLogin.ConnectionInfo.UserID = strInfo(2)
            myLogin.ConnectionInfo.Password = strInfo(3)
            myTable.ApplyLogOnInfo(myLogin)
          Next
'If report has any subreports then use this
        Dim RepObject As CrystalDecisions.CrystalReports.Engine.ReportObjec t
        Dim SubRepDoc As CrystalDecisions.CrystalReports.Engine.SubreportOb ject
        Dim RepDoc As CrystalDecisions.CrystalReports.Engine.ReportDocum ent
        For Each RepObject In cr.ReportDefinition.ReportObjects
            If RepObject.Kind = CrystalDecisions.Shared.ReportObjectKind.Subreport Object Then
                SubRepDoc = CType(RepObject, CrystalDecisions.CrystalReports.Engine.SubreportOb ject)
                RepDoc = cr.OpenSubreport(SubRepDoc.SubreportName)
                For Each myTable In RepDoc.Database.Tables
                    myLogin = myTable.LogOnInfo
                    myLogin.ConnectionInfo.ServerName = strInfo(0)
                    myLogin.ConnectionInfo.DatabaseName = strInfo(1)
                    myLogin.ConnectionInfo.UserID = strInfo(2)
                    myLogin.ConnectionInfo.Password = strInfo(3)
                    myTable.ApplyLogOnInfo(myLogin)
                  Next
            End If
        Next

    End Sub

'----------------------------