How to change Report Data Source for the Telerik Report?

[Snehal]

Hi 

Am new to telerik report. I just check the sample reports where the data source is fixed. I want like through Web API, I can call the database SQL procedure and what the output comes from store procedure will be the data source for the Telerik Report. Is it possible? or how can we achieve the same?

Another question, will telerik reports will run on azure web service without Virtual Machine? Can we take print out or download PDF from Azure web service? 

Thanks 

[Katia]

Hi Snehal,

If you wish to connect the report to data that comes from a service you can use ObjectDataSource component. ObjectDataSource.DataSource property should be the assembly qualified name or the Type of the data access layer (class), where the reporting engine will use System.Reflection to create the instance of the class by using its default constructor, and to execute its method specified by the ObjectDataSource.DataMember property.
Check an example provided in Connecting Telerik Reporting to OData feeds blog.

Reporting engine can work in Azure App Services when Basic or higher plan is used.


Regards,
Katia
Progress Telerik

[Snehal]

Thanks for the reply.

I tested the telerik report in Azure App Services (Basic) its works great. Few more questions. 

Our app developed in Kendo UI control 2014 versions. Newtonsoft.JSON version 6.0 we are using. What if we want to integrate latest reporting tool in that application. will it conflict dll's and js files?

 

Thanks

[Katia]

Hi Snehal,

HTML5 report viewer requires Kendo UI libraries Q3 2015 (2015.3.930) or higher - HTML5 viewer requirements. Kendo UI Professional license is not required if you are only going to use the widgets for the needs of HTML5 Report Viewer. Telerik Reporting provides a JS file containing a subset of the used by default Kendo UI widgets - telerikReportViewer.kendo-x.x.x.x.min.js.
However, if you use Kendo UI for the rest of the application it will be required to upgrade to at least Kendo UI Q3 2015.

The oldest version of Newtonsoft.Json.dll we support is 4.5.1.0. Therefore, it is possible to use version 6.0. Still, we recommend getting the latest available via NuGet.


Regards,
Katia
Progress Telerik