Productivity: Reporting

Introduction A while back, someone pointed me to this news article containing a Google Documents based spreadsheet with information about UK Inflation. Since I typically spend a lot of time working with Telerik Reporting, I thought it would be fun to create my own report based on this data. Accessing Google Data from .NET One of the cool things about Google is that they are a very data oriented company. Pretty much all of their services are centered on storing, organizing, and maintaining different types of data. They make this data extremely easy to access through the use of ...

Download SqlAzure.EntityFramework (C# VS2010) - 160KB In the previous blog post from the series we discussed how to connect Telerik Reporting to a SQL Azure database using Open Access ORM with the OpenAccessDataSource component. Now it is time to demonstrate how to perform this with another very popular ORM – Microsoft ADO.NET Entity Framework and the EntityDataSource component. For the sake of this example we assume an existing SQL Azure account with the Adventure Works sample database already installed. Let’s start with a new ADO.NET Entity Data Model. To connect to the SQL Azure database specify the server name and the login credentials of your SQL Azure account, then choose the AdventureWorksLTAZ2008R2 sample database as shown below: To create the entity model,...

Download SqlAzure.OpenAccess (C# VS2010) - 163KB In the previous blog post from the series we discussed how to connect Telerik Reporting to a SQL Azure database using ADO.NET with the help of the SqlDataSource component. Now we will demonstrate how to accomplish the same task with Open Access ORM utilizing the OpenAccessDataSource component. For the sake of this example we assume an existing SQL Azure account with the Adventure Works sample database already installed. Let’s start with a new Open Access domain model – the Open Access ORM Data Wizard starts. Choose Microsoft SQL Azure as a backend for the database connection and specify the connection string to your SQL Azure database as shown in the screenshot below: Choose the following tables...

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...