I have designed a report which gets its data from a SQL Server Stored Procedure.
At runtime I am calling the Stored Procedure with different parameters based on user input, and populating a DataTable.
Code: Select all
Using objCmd As New SqlCommand
objCmd.Connection = objConn
objCmd.CommandType = CommandType.StoredProcedure
objCmd.CommandText = "GetStores"
With objCmd
.Parameters.AddWithValue("Country", Me.cboCountry.Text)
.Parameters.AddWithValue("StoreType", Me.cboStoreType.Text)
.Parameters.AddWithValue("Cycle", CInt(Me.cboCycle.Text))
End With
Using da As New SqlDataAdapter(objCmd)
da.Fill(dt)
End Using
End Using
'Report.RegData(dt)
Report.Load("D:\Users\Jon\MyReports\AOESQL.mrt")
Me.StiWebViewer1.Report = Report
Report.Render()
Me.StiWebViewer1.Report = Report triggers
Code: Select all
Private Sub StiWebViewer1_GetReportData(sender As Object, e As Stimulsoft.Report.Web.StiReportDataEventArgs) Handles StiWebViewer1.GetReportData
e.Report.Dictionary.Databases.Clear()
e.Report.RegData(dt)
e.Report.Dictionary.Synchronize()
End Sub
Thanks,
Jon.