hi,
when i use stored procedure, i am not able to use the Wizard so i have to add the reports column one by one manually by adding
the textboxes.
is there an easy way to use the stored procedure.
is there anyway to use wizard for creating the report and using the stored procedure?
Thanks
3 Answers, 1 is accepted
0
Steve
Telerik team
answered on 11 Sep 2009, 07:22 AM
Hello Zahra,
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.
Thanks Steve for your reply.
i have another question.
when i use a report viewer to display my telerik report, the height of the report is not %100 of the page.
here is my code.
do you know how i can increase the height of the report section to full page?
hi Steve,
i figured out how to solve it.
i had to remove this line of code from my aspx page.
i guess that is not necessary to specify which version of Xhtml i am using. right?
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">