I feel like I went backward on this one... Anyone using SQL Server Table Valued Parameters (TVP) in a stored procedure and then using the results in a Telerik report? (Nice Code Project TVP and C# discussion in case you're not familiar http://www.codeproject.com/Articles/39161/C-and-Table-Value-Parameters)
For a 'normal' report, you create a report and a datasource and some parameters (single values or multiple values) using the excellent interface and hey presto! everything works out of the box.
Telerik reporting does not support TVP though, so you go back, strip out report's datasource and nice built-in parameter UI you had in there and
1) create a routine to make DataTable(s) from a RadComboBox(es) for the TVP
2) create a routine using SqlConnection, SqlCommand, SqlDataAdapters and the TVP DataTable(s) above to return another DataTable from your stored procedure
3) instantiate your report from your class library and hand it the DataTable above as the record source
4) if you're in ASP.NET, hand the loaded up Report to the ReportViewer.
It's what's going on behind the scenes, I guess, but it feels kludgy.
We have a fairly large library of stored procedures that use TVP and rewriting them all as VIEWs with IN clauses is not really an option. I'm worried about performance and size limitations as the above downloads ALL of the data into the DataTable and ... and does what with it?
Again, the above is working. Anyone else have a technique for working with Reports and TVP?
For a 'normal' report, you create a report and a datasource and some parameters (single values or multiple values) using the excellent interface and hey presto! everything works out of the box.
Telerik reporting does not support TVP though, so you go back, strip out report's datasource and nice built-in parameter UI you had in there and
1) create a routine to make DataTable(s) from a RadComboBox(es) for the TVP
2) create a routine using SqlConnection, SqlCommand, SqlDataAdapters and the TVP DataTable(s) above to return another DataTable from your stored procedure
3) instantiate your report from your class library and hand it the DataTable above as the record source
4) if you're in ASP.NET, hand the loaded up Report to the ReportViewer.
It's what's going on behind the scenes, I guess, but it feels kludgy.
We have a fairly large library of stored procedures that use TVP and rewriting them all as VIEWs with IN clauses is not really an option. I'm worried about performance and size limitations as the above downloads ALL of the data into the DataTable and ... and does what with it?
Again, the above is working. Anyone else have a technique for working with Reports and TVP?