Using Telerik's Data Source Wizard to connect to a stored procedure that requires parameters

[OBSOLETE ARTICLE: Check out the SqlDataSource help articles.]


HOW-TO
Use Telerik's Data Source Wizard to connect to a stored procedure that requires parameters.

SOLUTION
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). Because of that, the Telerik Reporting Data Source Wizard cannot be used to connect to parameterized data source such as stored procedure or a Select command with parameters out of the box.
 
What can be done is to manually execute it, feed the returned result set in a DataSet and then pass this DataSet to the Telerik Reporting DataSource. Another approach using our report parameters and NeedDataSource event is shown in this KB article.

For more information how to use ADO.NET to call a parameterized stored procedure, please refer to this KB article.