Bind Telerik Report with Stored Procedure

[kunal patel]

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

[Massimiliano Bassili]

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!

[Khoa Ho]

It's there: http://blogs.telerik.com/kevinbabcock/posts/09-03-14/telerik_reporting_connecting_to_stored_procedures.aspx

[Jasnil]

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

[Nasko]

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