# Integration with Telerik Reporting
## Environment
Product
Telerik WebForms Grid for ASP.NET AJAX
## Description
This article demonstrates how to integrate the Grid with the [***Telerik Reporting***](https://www.telerik.com/products/reporting.aspx) product to embed reporting functionality in your ASP.NET app.\
The integration itself depends on external assemblies, such as:
* Latest version of the **Telerik.ReportViewer.Html5.WebForms.dll** (distributed with the Telerik Reporting product)
* **Newtonsoft.Json.dll** (version 12.0.0 or later)
If Telerik Reporting is not included in your license you can [download a free trial](https://www.telerik.com/try) or consider upgrading to [Telerik DevCraft Complete](https://www.telerik.com/devcraft).
## Solution
The code below covers the following main points:
* The components from both suites are defined in separate WebUserControl(s) and loaded in a RadTabStrip component. The first tab shows the RadGrid, loaded and populated with sample data. The second one opens a report viewer displaying the data obtained from the Grid.
* The RadGrid is configured with a three-level hierarchy and with enabled sorting, filtering, and paging.
* During the ReportViewer initialization, the data is gathered from the current state of the RadGrid and passed to a report definition in JSON format. The generated report provides interactivity features like sorting and collapsing, similarly to the Grid behavior.
Default.aspx
```ASP.NET
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="Default" %>
<%@ Register Src="~/GridUC_CS.ascx" TagPrefix="uc1" TagName="GridUC_CS" %>
<%@ Register Src="~/ReportViewerUC_CS.ascx" TagPrefix="uc1" TagName="ReportViewerUC_CS" %>
```
```C#
using System;
using System.Collections;
using System.Collections.Generic;
using Telerik.ReportViewer.Html5.WebForms;
using Telerik.Web.UI;
public partial class Default : System.Web.UI.Page
{
protected void RadTabStrip1_TabClick(object sender, RadTabStripEventArgs e)
{
if (e.Tab.Value == "1")
{
var grid = (GridUC_CS.FindControl("RadGrid1") as RadGrid);
ReportViewerUC_CS.Visible = true;
var htmlReportViewer = (ReportViewerUC_CS.FindControl("ReportViewer1") as ReportViewer);
ExtractGridDataToReport(grid, htmlReportViewer);
}
}
private void ExtractGridDataToReport(RadGrid grid, ReportViewer htmlReportViewer)
{
var customers = new List();
foreach (GridDataItem parentItem in grid.MasterTableView.Items)
{
var customer = ExtractCustomerFromGridItem(parentItem);
customers.Add(customer);
}
var ser = new AdvancedJavaScriptSerializer();
var jsonGridCustomerData = ser.Serialize(customers);
htmlReportViewer.ReportSource.Parameters.Add("JsonGridCustomerData", jsonGridCustomerData);
}
private Customer ExtractCustomerFromGridItem(GridDataItem gridDataItem)
{
var customerID = gridDataItem.GetDataKeyValue("CustomerID").ToString();
var customer = new Customer(customerID);
var table = new Hashtable();
gridDataItem.ExtractValues(table);
customer.ContactName = (string)table["ContactName"];
customer.Company = (string)table["CompanyName"];
customer.Country = (string)table["Country"];
customer.City = (string)table["City"];
customer.Address = (string)table["Address"];
customer.HomePhone = (string)table["Phone"];
customer.Orders = GetOrdersFromCustomerGridItem(gridDataItem);
return customer;
}
private List GetOrdersFromCustomerGridItem(GridDataItem parentItem)
{
var orders = new List();
if (parentItem.HasChildItems && parentItem.ChildItem.NestedTableViews[0].Items.Count > 0)
{
var nestedTableView = parentItem.ChildItem.NestedTableViews[0];
foreach (GridDataItem childItem in nestedTableView.Items)
{
var orderID = (int)(childItem.GetDataKeyValue("OrderID"));
var order = new Order(orderID, parentItem.GetDataKeyValue("CustomerID").ToString());
var table = new Hashtable();
childItem.ExtractValues(table);
order.OrderDate = DateTime.Parse(table["OrderDate"].ToString());
order.Freight = Double.Parse(table["Freight"].ToString());
order.OrderDetails = GetOrdersDetailsFromOrderGridItem(childItem);
orders.Add(order);
}
}
return orders;
}
private List GetOrdersDetailsFromOrderGridItem(GridDataItem parentItem)
{
var ordersDetails = new List();
if (parentItem.HasChildItems && parentItem.ChildItem.NestedTableViews[0].Items.Count > 0)
{
var nestedTableView = parentItem.ChildItem.NestedTableViews[0];
foreach (GridDataItem childItem in nestedTableView.Items)
{
var table = new Hashtable();
childItem.ExtractValues(table);
var orderID = (int)(parentItem.GetDataKeyValue("OrderID"));
var orderDetails = new OrderDetails(orderID)
{
ProductID = int.Parse(table["ProductID"].ToString()),
Discount = Decimal.Parse(table["Discount"].ToString()),
Quantity = int.Parse(table["Quantity"].ToString()),
UnitPrice = Decimal.Parse(table["UnitPrice"].ToString())
};
ordersDetails.Add(orderDetails);
}
}
return ordersDetails;
}
}
public class Customer
{
public Customer(string customerID)
{
this.CustomerID = customerID;
}
public string CustomerID { get; private set; }
public string ContactName { get; set; }
public string Company { get; set; }
public string Country { get; set; }
public string City { get; set; }
public string Address { get; set; }
public string HomePhone { get; set; }
public List Orders { get; set; }
}
public class Order
{
public Order(int orderID, string CustomerID)
{
this.OrderID = orderID;
this.CustomerID = CustomerID;
}
public string CustomerID { get; private set; }
public int OrderID { get; private set; }
public DateTime OrderDate { get; set; }
public Double Freight { get; set; }
public List OrderDetails { get; set; }
}
public class OrderDetails
{
public OrderDetails(int orderID)
{
this.OrderID = orderID;
}
public int OrderID { get; private set; }
public int ProductID { get; set; }
public int Quantity { get; set; }
public Decimal UnitPrice { get; set; }
public Decimal Discount { get; set; }
}
```
**GridUC_CS** User control
```ASP.NET
<%@ Control Language="C#" ClassName="GridUC_CS" %>
```
**ReportViewerUC_CS** User Control
```ASP.NET
<%@ Control Language="C#" ClassName="ReportViewerUC_CS" %>
<%@ Register Assembly="Telerik.ReportViewer.Html5.WebForms" Namespace="Telerik.ReportViewer.Html5.WebForms" TagPrefix="telerikRep" %>
```
**Optional:** Setting the version of the additional **Newtonsoft.Json.dll** in the dependentAssembly element in the **web.config**, e.g. version **13**:
```XML
```