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

Bind Telerik Report with Stored Procedure

4 Answers 380 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
kunal patel
Top achievements
Rank 1
kunal patel asked on 03 Aug 2009, 11:42 AM
Hello,

I am using Telerik reporting in order to generate report

Now, at present i am binding the Telerik Report with the Dataset
as DataSource.

But, i want to give datasource as the table which is created from
stored Procedure in MSSQL Server 2005.

In short, i dont want to use dataset as Datasource.
I want to bind report with the Stored Procedure.

The reason behind this is, it takes too much time to bind report with
dataset.

If anybody can help me to bind report with stored procedure it will be
great.

Also, if there are any suggestions regarding how to bind report using
dataset by some method which will load report faster, that are most welcome.

Please reply as soon as possible,


Thanks,
Kunal

4 Answers, 1 is accepted

Sort by
0
Massimiliano Bassili
Top achievements
Rank 1
answered on 03 Aug 2009, 12:43 PM
Check out the following KB: http://www.telerik.com/support/kb/reporting/general/using-telerik-s-data-source-wizard-to-connect-to-a-stored-procedure-that-requires-parameters.aspx

Cheers!



0
Khoa Ho
Top achievements
Rank 1
answered on 03 Dec 2009, 03:57 AM
0
Jasnil
Top achievements
Rank 1
answered on 05 Feb 2014, 07:02 AM
Hi Kunal,

I am new to Telerik report and i have to bind the Telerik report with the Dataset as DataSource.
Currently i am just binding the database table using reporting wizard.

It will be much appreciated if you could help me.

Regards, 
Jasnil
0
Nasko
Telerik team
answered on 07 Feb 2014, 03:36 PM
Hello Jasnil,

You can use ObjectDataSource component to bind to a DataSet. The ObjectDataSource component works with any component that implements IListSource, including DataTable, DataSet and DataView.
Note that if the DataSource reference contains more than one table, you must set the DataMember property to a string that specifies the table to bind to.

For more information, please follow the ObjectDataSource help and how-to articles.

Regards,
Nasko
Telerik

New HTML5/JS REPORT VIEWER with MOBILE AND TOUCH SUPPORT available in Telerik Reporting Q3 2013! Get the new Reporting version from your account or download a trial.

Tags
General Discussions
Asked by
kunal patel
Top achievements
Rank 1
Answers by
Massimiliano Bassili
Top achievements
Rank 1
Khoa Ho
Top achievements
Rank 1
Jasnil
Top achievements
Rank 1
Nasko
Telerik team
Share this question
or