This is a migrated thread and some comments may be shown as answers.

How to bind data to telerik reporting

1 Answer 117 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
livashini
Top achievements
Rank 1
livashini asked on 05 Jun 2014, 06:18 AM
Hi
I am new to telerik reporting.
I currently have a MVC web application that shows a telerik report. I want to get and pass multi parameter to telerik report given by  input from stored procedure.
Now I want to know  how to bind and load data to telerik report. anyone can help me?


Thank You

1 Answer, 1 is accepted

Sort by
0
Peter
Telerik team
answered on 09 Jun 2014, 02:03 PM
Hi,

The DataSource Components do not support MultiValue Report Parameter for Stored Procedures because it is based on ADO.NET and does not allow you to pass a collection of values (set, array). The SqlDataSource component supports parameterized SQL queries by associating the parameters you add to the Parameters collection with placeholders in the SelectCommand query. Parameter values can be evaluated with any expression which conforms to the common expression syntax supported by the reporting engine. This grants you a great deal of flexibility on how you can supply your SQL queries with parameters. Unfortunately the above approach is not applicable for stored procedures.

For a workaround sample check out the following forum thread.

For more information on the report data binding check out the Connecting to Data help article.

Regards,
Peter
Telerik
 

Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

 
Tags
General Discussions
Asked by
livashini
Top achievements
Rank 1
Answers by
Peter
Telerik team
Share this question
or