public DataTable PivotTable(DataTable source)

{

DataTable dest = new DataTable("Pivoted" + source.TableName);

dest.Columns.Add(

" ");

foreach (DataRow r in source.Rows)

dest.Columns.Add(r[0].ToString());

for (int i = 0; i < source.Columns.Count - 1; i++)

{

dest.Rows.Add(dest.NewRow());

}

for (int r = 0; r < dest.Rows.Count; r++)

{

for (int c = 0; c < dest.Columns.Count; c++)

{

if (c == 0)

dest.Rows[r][0] = source.Columns[r + 1].ColumnName;

else

return dest;

}

protected void RadGrid1_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)

{

RadGrid1.DataSource = PivotTable(GetDataTable(

"SELECT CONVERT(varchar,StatDate,101) StatDate,FelonyArrests,MisdArrests,NTA,FSAO,TrafficArrests,WarrantArrests,DispCalls,SelfInitActivities,[BackUp] BackUps,FIR," +

"VehRecov,TrafficCitations,CourtesyNotices,TrafficStops,WarrantsServed,WarrantsObtained,NewGangFiles,GangFileUpd,Presentations,InvestHours," +

"IntelRpts,PropValRecov,GunsRecov,IntelBullitens,SearchWarrantHours,TasksAssigned,TasksTrans,TasksCleared,AssignedActive,Transfered," +

"ClearedByArrest,EC,Unfounded,Closed,Inactive,Surveillance,Callouts,SearchWarrants FROM Gang_Stats ORDER BY StatDate asc"));

protected void RadGrid1_ColumnCreated(object sender, Telerik.Web.UI.GridColumnCreatedEventArgs e)

{

if (e.Column.UniqueName == "StatDate")

{

GridBoundColumn boundColumn = e.Column as GridBoundColumn;

boundColumn.DataFormatString =

"{0:d}";

boundColumn.ItemStyle.Font.Bold =

true;

}

}