I&#039;m trying to get the sql statement to view the crystal report.<BR>But seem that i view all (Select *) instead of the condition that I pass.<BR>I&#039;m using the OLEDB connection for the crystal report. <BR><BR>Private Sub btnView_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnView.Click<BR> Dim objReport As New CrystalReport1()<BR> Dim myDataSet As New Dataset1() &#039;the xml Connection <BR> CrystalReportViewer1.Visible = True<BR> SqlStmt = "SELECT * from vPerson"<BR> mySqlAdapter = New SqlDataAdapter(SqlStmt, sqlConn)<BR><BR> mySqlAdapter.Fill(myDataSet, "vPerson")<BR> objReport.SetDataSource(myDataSet)<BR> CrystalReportViewer1.ReportSource = objReport<BR> End Sub<BR><BR>Pls help.<BR>Thanks