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