Pass Data Table to Report
Posted: Thu Nov 15, 2012 2:10 pm
Hi,
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.
When da.Fill(dt) executes, the datatable contains the correct data based on the user input.
Me.StiWebViewer1.Report = Report triggers
But when my report renders, I get only the page header and no data. I have only previously used Stimulsoft WinForms with XML data and had no problems. I do not understand how to change the data in my report at runtime with the web version. Can you please advise. I have read all posts I can find in the forum but none help.
Thanks,
Jon.
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.