Is it possible to create group column totals for every column without having to specify individual columns? My grid is actually a pivot table and my columns are generated dynamically by a sql statement that is created by drop down menus. There are 55 different combinations so I don’t want to have to program each individual column. My thought was to specify the group by’s and auto total the rest of the columns. For instance in this example, http://img843.imageshack.us/img843/3719/groupsql.jpg I would specify group by city and sex and the rest of the columns will total automatically. Any ideas will help. Thanks in advance.
I have large amount of data and I’m trying out the example found here: http://demos.telerik.com/clientbinding3/
I managed to get it working with my data and filtering works, but I can’t seem to get it to change the pages. It also doesn’t update the “Time to get data” or “Time to update Grid”.
I’m wondering if it’s not getting the “ClientBindingExample.js”, because if I comment the javascript out of my ASPX file, it still loads the grid fine.
Is there something I could be missing? I’m sure it has to be easy, but I don't see it. :(
Thanks!
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="test.aspx.cs" Inherits="test" MasterPageFile="~/Site.master" Theme="EventDrive" %>
<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>
<
asp:Content
ID
=
"BodyContent"
runat
=
"server"
ContentPlaceHolderID
=
"MainContent"
>
<
telerik:RadScriptManager
ID
=
"RadScriptManager"
runat
=
"server"
/>
<
telerik:RadGrid
ID
=
"RadGrid1"
OnNeedDataSource
=
"RadGrid_NeedDataSource"
runat
=
"server"
AllowPaging
=
"True"
AllowSorting
=
"True"
>
</
telerik:RadGrid
>
<
asp:EntityDataSource
ID
=
"edsED"
runat
=
"server"
ConnectionString
=
"name=EventdriveEntities"
DefaultContainerName
=
"EventdriveEntities"
EntitySetName
=
"Person"
AutoSort
=
"true"
/>
</
asp:Content
>
using
System;
using
System.Collections.Generic;
using
System.Linq;
using
System.Web;
using
System.Web.UI;
using
System.Web.UI.WebControls;
using
Telerik.Web.UI;
public
partial
class
test : System.Web.UI.Page
{
protected
void
RadGrid_NeedDataSource(
object
sender, GridNeedDataSourceEventArgs e)
{
edsED.Where =
"it.EventID = 2324"
;
//fetch EventID here.
RadGrid1.DataSource = edsED;
}
}