Matt Thrower
Top achievements
Rank 1
Rank 1
Matt Thrower
asked on 14 Nov 2008, 02:17 PM
Hi,
Is it possible to have some guidance on how one can create reports without using the built in Wizards? All the existing documention seems to be pointing heavily toward wizard-driven development, which is causing me immense problems. All our data access, for example, is through our own custom classes calling stored procs in SQL Server and not through MSDataSetGenerator objects or whatever it is that the wizard puts in your classes for you. The Query Builder doesn't seem to support direct calls to sprocs either, which makes matters more awkward.
Any help very gratefully appreciated!
cheers,
Matt
Is it possible to have some guidance on how one can create reports without using the built in Wizards? All the existing documention seems to be pointing heavily toward wizard-driven development, which is causing me immense problems. All our data access, for example, is through our own custom classes calling stored procs in SQL Server and not through MSDataSetGenerator objects or whatever it is that the wizard puts in your classes for you. The Query Builder doesn't seem to support direct calls to sprocs either, which makes matters more awkward.
Any help very gratefully appreciated!
cheers,
Matt
1 Answer, 1 is accepted
0
Hi Matt,
Our documentation points heavily toward wizard-driven development, because using our wizard is sufficient in 98% of the scenarios where you do not need to use our events and write a single line of code. 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 a stored procedure that requires parameters.
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.Report.DataSource.
Step by step instructions are available in the following KB article: Using data source with parameters in Telerik Reporting
Best wishes,
Steve
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.
Our documentation points heavily toward wizard-driven development, because using our wizard is sufficient in 98% of the scenarios where you do not need to use our events and write a single line of code. 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 a stored procedure that requires parameters.
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.Report.DataSource.
Step by step instructions are available in the following KB article: Using data source with parameters in Telerik Reporting
Best wishes,
Steve
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.