I have been working on a program. When I have stumbled across a problem I post it here and get the problem solved. I appreciate all the help I have received.
Now I am needing to find a decent reporting add on. Something decent but won't make me place another mortgage on my home to purchase. I have attempted to use the reporting in vs2005 standard but I have read that i can not pass parameters to the report. I need this for my program. Any ideas? Thanks in advance.

I have been looking at Crystal Reports and DevExpress. Both are a little out of my range. Don't really want to bite that big of a bullet for a report.

generate sqldataadapter first and generate data set to use in your crystal reportfile (when first time you set connection while you add new crystal report file)

Private Sub btnView_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnView.Click
        Dim DS As New DataSet
        SqlDataAdapter1.Fill(DS)
        Dim CRData As New YourCrystalReportFileName
        CRData.SetDataSource(DS)
        CRVOrtu.ReportSource = CRData
        CRVOrtu.SelectionFormula() = "{TableName.Nis}='" & Trim(txtNo.Text) & "' "
        CRVOrtu.RefreshReport()
    End Sub
This article has been dead for over six months. Start a new discussion instead.