Crystal+ASP.Net

[scooby77]

I have tried everything to get a Crystal report called Incident.rpt to be displayed based on an number that is retireved from a DataGrid. I am trying to write this in VB and I have exhausted the references that I have. Has anyone tackled this before and if so is there a better method? Here is a sample of my code. Thanks.

Dim myConnectionString As String
Dim myConnection As SqlClient.SqlConnection
Dim myDataAdapter As SqlClient.SqlDataAdapter = New SqlClient.SqlDataAdapter

Dim SQL As String

SQL = "SELECT tb_incidentticket.*, tb_Complaintant.* " & "FROM tb_incidentTicket INNER JOIN tb_complaintant ON tb_incidentTicket.pk_reportNumber = tb_compliantant.fk_reportNumber"

myConnectionString = "Data Source=AGFCDEV;UID=IncidentUser1;pwd=scooby;Database=Incident"

myConnection = New SqlClient.SqlConnection(myConnectionString)

myDataAdapter.SelectCommand = New SqlClient.SqlCommand(SQL, myConnection)

myDataAdapter.Fill(myDataSet, "Customers&quot