• .NET

    Creating a Calendar Report with Telerik Reporting

    An interesting question that we frequently are being asked is: How to create a calendar report? Generally, the requirement is to create a report showing appointments and bookings just as in a month planner calendar/scheduler. When you think about it, tracking tasks and events when displayed in a calendar is instant - the users have all the information they need into a well known layout that allows to easily analyze tasks and projects. It is no wonder that our clients request this type of report. The easiest way to prepare a dynamic calendar report is to utilize our flexible crosstab/table/list item. Due to the...
  • .NET

    Page Aggregates (Page Totals) in Telerik Reporting Q1 2011

    In some report scenarios, it is useful to include a page-scoped aggregate in Page Header or Page Footer section. As of Q1 2011, the powerful expression engine of Telerik Reporting has been extended with page aggregates, which allow you to add customizable sub-totals and summary data at the bottom of every page, such as total number of Unit X sold, or the average number of processes that have passed. You can add counts, sums, and averages to each page, even if your report consists of subreports and several tables. To add a page aggregate you need to utilize the new PageExec function that takes...
  • .NET

    Connecting Telerik Reporting to SQL Azure via Entity Framework

    January 11, 2011 Share
    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,...
  • .NET

    Connecting Telerik Reporting to SQL Azure via Open Access

    December 16, 2010 Share
    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...
  • .NET

    Connecting Telerik Reporting to SQL Azure via ADO.NET

    December 10, 2010 Share
     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...