Productivity: Reporting

Often times, you’ll need to store data from your application in XML files. Well, what if you want to report on this data… it’s not in a database, so how do you do it? I’m happy to say that you can easily report on XML data through the use of the ObjectDataSource component provided with Telerik Reporting. In this blog entry, we’ll take a look at how this can be accomplished. Working with XML Data For this example, I’ve generated some XML data in advance using this helpful data generation website. <Accounts>      <Account>         ...

 Download SqlAzure.AdoNet (C# VS2010) - 149KB Microsoft SQL Azure is a relational database service that allows you to host your SQL Server based database in the cloud. Since cloud computing is gaining a lot of popularity recently, we decided to demonstrate how to connect and consume an existing SQL Azure database with Telerik Reporting. There are three basic methods for connecting Telerik Reporting to a SQL Azure database: Using ADO.NET and the SqlDataSource component. Using Telerik Open Access and the OpenAccessDataSource component. Using Microsoft Entity Framework and the EntityDataSource component. In this blog post we will cover how to connect Telerik Reporting to SQL Azure via ADO.NET. The other two methods will be discussed in subsequent blog posts of the same series. For...

A few weeks ago, the Q3 2010 release made its official appearance. This release marked the addition of various new features across all Telerik products. As with every release, we try our hardest to create video tutorials corresponding to each new product feature. In these videos we generally write the code to some sort of example application. Often we receive requests for this code, so I thought I would save you the trouble of asking and post the code to the Telerik Reporting videos here in this blog entry. Here is a list of all videos related to Telerik Reporting ...

Download ODataSample (C# VS2010) - 167KB Download ODataSample (VB VS2010) - 180KB The Open Data Protocol, also known as OData recently has gained a lot of popularity. That is why we decided to demonstrate how to connect and consume an existing OData feed from Telerik Reporting with the help of WCF Data Services. For the sake of this example we will connect to the Northwind sample database exposed as an OData service with the following root URL: http://services.odata.org/Northwind/Northwind.svc. Let's start by adding a service reference to the Northwind data service to our report class library - we use the above service URL for this purpose: Visual Studio creates a reference to the service...

Due to the rising popularity of Rich Internet Applications (RIA) e.g. Silverlight applications, the developers get more dependent on services for coordinating application logic between the middle tier and the presentation tier and the logical question raises how to use an already working WCF RIA Service as a datasource for Telerik Report. This is very useful if you want to enable the exact same business data access logic for clients other than Silverlight. For example to a WPF, WinForms or WebForms application. Thus we have made some tests locally and decided to share our observations in this post. Prerequisites: We will examine the WCF...