<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
	<head runat="server">
		<title></title>
	<telerik:RadStyleSheetManager ID="RadStyleSheetManager1" runat="server" />
	<style type="text/css">
		.RadPivotGrid .rpgColumnHeader .rotated {
			display: inline-block;
			width: 40px;
			padding-top: 70px;
			height: 120px;
    		-webkit-transform: rotate(-90deg);
    		-moz-transform: rotate(-90deg);
    		-ms-transform: rotate(-90deg);
    		-o-transform: rotate(-90deg);
    		transform: rotate(-90deg);
			filter: progid:DXImageTransform.Microsoft.BasicImage(rotation=3);
		}
	</style>
	</head>
<body>
	<form id="form1" runat="server">
		<telerik:RadScriptManager ID="RadScriptManager1" runat="server">
		</telerik:RadScriptManager>
		<script type="text/javascript">
			function onPivotCreated(sender, eventArgs) {
				var columnHeaders = $telerik.getElementsByClassName(sender.get_columnHeaderTable(), "rpgColumnHeader"),
					content;
				content = columnHeaders[8].innerHTML
				columnHeaders[8].innerHTML = '<span class="rotated">' + content + '</span>';
				content = columnHeaders[9].innerHTML
				columnHeaders[9].innerHTML = '<span class="rotated">' + content + '</span>';
			}
		</script>
		<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">
		</telerik:RadAjaxManager>
		<telerik:RadPivotGrid ID="RadPivotGrid2" runat="server"
			AllowPaging="true" OnNeedDataSource="RadPivotGrid1_NeedDataSource">
			<ClientSettings Scrolling-AllowVerticalScroll="true">
				<ClientEvents OnPivotGridCreated="onPivotCreated" />
			</ClientSettings>
			<Fields>
				<telerik:PivotGridRowField DataField="TransportType">
				</telerik:PivotGridRowField>
				<telerik:PivotGridRowField DataField="Company">
				</telerik:PivotGridRowField>
				<telerik:PivotGridColumnField DataField="Country">
				</telerik:PivotGridColumnField>
				<telerik:PivotGridColumnField DataField="City">
				</telerik:PivotGridColumnField>
				<telerik:PivotGridAggregateField DataField="Profit" Aggregate="Sum" DataFormatString="{0:C}">
				</telerik:PivotGridAggregateField>
				<telerik:PivotGridAggregateField IsHidden="true" DataField="Expenses" Aggregate="Sum">
				</telerik:PivotGridAggregateField>
			</Fields>
		</telerik:RadPivotGrid>
		<%--<asp:SqlDataSource runat="server" ID="SqlDataSource1" ConnectionString='<%$ ConnectionStrings:TelerikConnectionString %>'
				SelectCommand="SELECT [OrderID], [ProductID], [UnitPrice], [Quantity], [Discount] FROM [Order Details]"></asp:SqlDataSource>--%>
	</form>
</body>
</html>
