Hello -
I am trying to create a subreport to be used to display the details for a master/parent report.
Are there any examples in which stored procedures are used? I see all of the examples use straight t-sql queries, but I have to use a stored procedure that is expecting a parameter - the ID value for the master record. If anyone can help me find such an example, that would be great.
thanks
I am trying to create a subreport to be used to display the details for a master/parent report.
Are there any examples in which stored procedures are used? I see all of the examples use straight t-sql queries, but I have to use a stored procedure that is expecting a parameter - the ID value for the master record. If anyone can help me find such an example, that would be great.
thanks
2 Answers, 1 is accepted
0
Hello Will,
The Telerik Reporting does not provide its own data layer but depends on the existing .NET objects (DataSet, Data Table, DataView, ADO.NET, lists - for more information on report data binding, please, refer to this help topic).
I am afraid that you cannot use the Telerik's Data Source Wizard to connect to a stored procedure that requires parameters. What you have to do is manually execute it, feed the returned result set in a DataSet and then pass this DataSet to the Telerik.Reporting.Report.DataSource.
For more information how to use ADO.NET to call a parameterized stored procedure please refer to this KB article.
I hope this information helps. Please, let me know if I can assist you any further.
Thank you.
Kind regards,
Svetoslav
the Telerik team
Instantly find answers to your questions at the new Telerik Support Center
The Telerik Reporting does not provide its own data layer but depends on the existing .NET objects (DataSet, Data Table, DataView, ADO.NET, lists - for more information on report data binding, please, refer to this help topic).
I am afraid that you cannot use the Telerik's Data Source Wizard to connect to a stored procedure that requires parameters. What you have to do is manually execute it, feed the returned result set in a DataSet and then pass this DataSet to the Telerik.Reporting.Report.DataSource.
For more information how to use ADO.NET to call a parameterized stored procedure please refer to this KB article.
I hope this information helps. Please, let me know if I can assist you any further.
Thank you.
Kind regards,
Svetoslav
the Telerik team
Instantly find answers to your questions at the new Telerik Support Center
0
Will
Top achievements
Rank 1
Rank 1
answered on 22 Nov 2007, 05:04 PM
Thanks...I figured out that I cannot use the Telerik Report Wizard if I want to use a stored procedure. Too bad! As it is, I just manually add the sql data adapter to my report and then go from there.