Support & Learning
Application Development and Deployment
Data Connectivity and Integration
Web Content Management
Get A Free Trial
close mobile menu
Testing & ALM
Stefan’s main interests outside the .NET domain include rock music, playing the guitar and swimming.
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...
May 03, 2011
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...
March 29, 2011
Connecting Telerik Reporting to SQL Azure via Entity Framework
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,...
January 11, 2011
Connecting Telerik Reporting to SQL Azure via Open Access
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...
December 16, 2010
Connecting Telerik Reporting to SQL Azure via ADO.NET
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...
December 10, 2010
Testing & ALM
Latest updates in your inbox
Cooking with ASP.NET Core and Angular
July 26, 2017
How To Submit a Support Ticket
June 27, 2017
Security Alert for Telerik UI for ASP.NET AJAX and Progress Sitefinity
June 29, 2017