SQLTeam.com | Weblogs | Forums

ReportViewer won't display report. Blank screen

        Using connection
            Using command
                Using adapter
                    Using ds
                        connection.Open()
                        command.Connection = connection
                        command.CommandType = CommandType.StoredProcedure
                        command.CommandText = "usp_ShipperRecNonRoyalAll_Select"
                        command.Parameters.AddWithValue("@LabelID", LabelID)
                        adapter.SelectCommand = command
                        adapter.Fill(ds)
                    End Using
                End Using
            End Using
        End Using

    ReportViewer1.Reset()
    ReportViewer1.ProcessingMode = ProcessingMode.Local

        ReportViewer1.LocalReport.ReportPath = "c:\\WSG-WinApps\\Wolverine.Shippers\\SSRS\\ShipperRpts\\rpt_LS_Shipper.rdl"

        ReportViewer1.LocalReport.DisplayName = "rpt_LS_Shipper"
        ReportDataSource.Name = "dsShipper"
        ReportDataSource.Value = ds.Tables(0)
        ReportViewer1.LocalReport.DataSources.Add(ReportDataSource)
    ReportViewer1.RefreshReport()
    ReportViewer1.Show()

--Report displays fine is Visual Studio Reports Project