I have an ASP.NET 2003 application with 3 crystal reports. Two of them are subreports that display inside the third. If I try to run the application, it asks me to log on to the server, then displays a blank page. If I remove the sub-reports and just set the ReportSource to either of the other two reports, it runs perfect without asking me to log in. It knows the server, database and user, but wants the password.
Is there some trick to getting Subreports to display correctly? I have not had much luck in finding an answer.
Here is a code snippet with what I am doing
==================================================
selectString = "SELECT ..." ' not showing actual sql to save space
Dim dsDaveTest1 As DataSet = New DataSet
Dim hpdata1 As SqlDataAdapter = New SqlDataAdapter(selectString, goConn)
hpdata1.Fill(dsDaveTest1, "MASTER1")
Dim cr1 As CrystalReport1
cr1 = New CrystalReport1
cr1.SetDataSource(dsDaveTest1)
selectString = "SELECT ..." 'not showing actual sql string to save space
Dim dsDaveTest2 As DataSet = New DataSet
Dim hpdata2 As SqlDataAdapter = New SqlDataAdapter(selectString, goConn)
hpdata2.Fill(dsDaveTest2, "MASTER2")
Dim cr2 As CrystalReport2
cr2 = New CrystalReport2
cr2.SetDataSource(dsDaveTest2)
Dim cr3 As CrystalReport3
cr3 =
New CrystalReport3
CrystalReportViewer2.ReportSource = cr3
==================================================
Thanks in advance....
Mongoose