if (cell.CellType == PivotGridDataCellType.ColumnGrandTotalDataCell || cell.CellType == PivotGridDataCellType.RowGrandTotalDataCell)
{
if ((cell.Field as PivotGridAggregateField).DataField == "Amount")
{
string maxvaluerow = cell.ParentRowIndexes[1].ToString();
if (maxvaluerow == "11")
{
cell.Text = "";
// here i want to set the grandtotal result as Max value of row
}
}
}
<telerik:GridTemplateColumn HeaderText="Code" SortExpression="Code" UniqueName="Code" AllowFiltering="True"> <ItemTemplate> <asp:LinkButton ID="lbCCode" runat="server" Text='<%# Eval("Code") %>' /> </ItemTemplate></telerik:GridTemplateColumn>Width="98%" and etc information.
the MasterTableView TableLayout="Fixed"
I have a table with 40 columns, so the user can select many columns to show in the grid.
the grid had 40 telerik:GridTemplateColumn, and in the code behind in the event of _ItemCreated set the property visible (true/false).
and the <HeaderStyle without Width
And the propertys of grid Scrolling-AllowScroll ="true" Scrolling-UseStaticHeaders="true"
But dont work!
pls help!
<div ID="divGrid" runat="server" style="width:1900; background-color:Red;"> <telerik:RadGrid ID="rgvMainGrid" runat="server" DataSourceID="SQLDS_Receivables" EnableEmbeddedSkins="true" Skin="Office2010Silver" EnableAjaxSkinRendering="true" Height="600px" Width="1800px" EnableViewState="true" AutoGenerateColumns="false" AllowMultiRowSelection="false" AllowFilteringByColumn="false" EnableHeaderContextMenu="false" EnableHeaderContextFilterMenu="false" ShowGroupPanel="false" AllowAutomaticDeletes="false" AllowAutomaticInserts="false" AllowAutomaticUpdates="false" AllowSorting="true" EnableLinqExpressions="false" AllowPaging="false" PageSize="100" > <ItemStyle Wrap="true" /> <AlternatingItemStyle Wrap="true" /> <ActiveItemStyle BackColor="CornflowerBlue"/> <HeaderStyle HorizontalAlign="Center"/> <EditItemStyle BackColor="CornflowerBlue"/> <ClientSettings AllowColumnsReorder="true" ReorderColumnsOnClient="true" ColumnsReorderMethod="Reorder" AllowDragToGroup="false" EnablePostBackOnRowClick="false" EnableRowHoverStyle="false" > <Resizing AllowColumnResize="false" EnableRealTimeResize="true" ResizeGridOnColumnResize="false" AllowRowResize="false" /> <Selecting AllowRowSelect="true"/> <Scrolling AllowScroll="true" UseStaticHeaders="true" /> </ClientSettings> <GroupHeaderItemStyle Font-Size="11px" Font-Names="calibri" Font-Bold="true" Height="12px"/> <MasterTableView Name="Invoices" DataSourceID="SQLDS_Receivables" DataKeyNames="RecordId" ClientDataKeyNames="RecordId" EnableViewState="true" EditMode="EditForms" CommandItemDisplay="None" TableLayout="Fixed" Width="1800px" EnableNoRecordsTemplate="true" ShowHeadersWhenNoRecords="true" > <NoRecordsTemplate> <div>There are no records to display. </div></NoRecordsTemplate> <Columns> <telerik:GridBoundColumn UniqueName="Job" DataField="Job" HeaderText="Job" HeaderStyle-Width="87px" ReadOnly="true" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" /> <telerik:GridBoundColumn UniqueName="JobDescription" DataField="JobDescription" HeaderText="Job Name" HeaderStyle-Width="200px" ReadOnly="true" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" /> <telerik:GridBoundColumn UniqueName="Extra" DataField="Extra" HeaderText="Extra" HeaderStyle-Width="87px" ReadOnly="true" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" /> <telerik:GridBoundColumn UniqueName="CustomerName" DataField="CustomerName" HeaderText="Customer Name" HeaderStyle-Width="200px" ReadOnly="true" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" /> <telerik:GridBoundColumn UniqueName="ContractNumber" DataField="ContractNumber" HeaderText="Contract" HeaderStyle-Width="100px" ReadOnly="true" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" /> <telerik:GridBoundColumn UniqueName="DocumentId" DataField="DocumentId" HeaderText="Document Id" HeaderStyle-Width="100px" ReadOnly="true" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" /> <telerik:GridBoundColumn UniqueName="Draw" DataField="Draw" HeaderText="Draw" HeaderStyle-Width="125px" ReadOnly="true" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" /> <telerik:GridBoundColumn UniqueName="InvoiceDate" DataField="InvoiceDate" HeaderText="Inv Date" HeaderStyle-Width="80px" ReadOnly="true" DataType="System.DateTime" DataFormatString="{0:MM/dd/yy}" ItemStyle-HorizontalAlign="Center" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" /> <telerik:GridBoundColumn UniqueName="DaysOld" DataField="DaysOld" HeaderText="Days Old" HeaderStyle-Width="40px" ReadOnly="true" DataType="System.Int16" DataFormatString="{0:#,###,###}" ItemStyle-HorizontalAlign="Right" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" /> <telerik:GridBoundColumn UniqueName="AccountingDate" DataField="AccountingDate" HeaderText="Acct Date" HeaderStyle-Width="80px" ReadOnly="true" DataType="System.DateTime" DataFormatString="{0:MM/dd/yy}" ItemStyle-HorizontalAlign="Center" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" /> <telerik:GridBoundColumn UniqueName="BilledLessRetainage" DataField="BilledLessRetainage" HeaderText="Billed Less Ret" HeaderStyle-Width="100px" ReadOnly="true" DataType="System.Decimal" DataFormatString="{0:#,###,###.#0}" ItemStyle-HorizontalAlign="Right" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" /> <telerik:GridBoundColumn UniqueName="UnbilledRetainage" DataField="UnbilledRetainage" HeaderText="Unbilled Retainage" HeaderStyle-Width="100px" ReadOnly="true" DataType="System.Decimal" DataFormatString="{0:#,###,###.#0}" ItemStyle-HorizontalAlign="Right" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" /> <telerik:GridTemplateColumn UniqueName="gtcUpdateAll" HeaderText="Update All Transactions" AllowFiltering="false" > <ItemTemplate></ItemTemplate> <EditItemTemplate><asp:CheckBox ID = "chkUpdateAll" runat="server" Checked="true" /></EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn UniqueName="gtcExpectedPaymentDate" DataField="ExpectedPaymentDate" HeaderText="Exp Pay Date" HeaderStyle-Width="80px" ItemStyle-HorizontalAlign="Center" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" > <ItemTemplate><asp:Label ID="lblExpectedPaymentDate" runat="server" Text='<%# Eval("ExpectedPaymentDate", "{0:MM-dd-yy}" ) %>' /></ItemTemplate> <EditItemTemplate><telerik:RadDatePicker ID = "rdpExpectedPaymentDate" runat="server" Width="85px" DbSelectedDate='<%# Bind("ExpectedPaymentDate") %>' SkinID="skn_RadDatePicker" /></EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridBoundColumn UniqueName="DaysToPay" DataField="DaysToPay" HeaderText="Days To Pay" HeaderStyle-Width="55px" ReadOnly="true" DataType="System.Int16" DataFormatString="{0:#,###,###}" ItemStyle-HorizontalAlign="Right" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" /> <telerik:GridDropDownColumn UniqueName="ActionCode" DataField="ActionCode" HeaderText="Action" HeaderStyle-Width="100px" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" ListTextField="LevelCode" ListValueField="IdentifierCode" DataSourceID="SQLDS_ActionCode" DropDownControlType="RadComboBox" DefaultInsertValue="NA" /> <telerik:GridDropDownColumn UniqueName="StatusCode" DataField="StatusCode" HeaderText="Status" HeaderStyle-Width="120px" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" ListTextField="LevelCode" ListValueField ="IdentifierCode" DataSourceID="SQLDS_StatusCode" DropDownControlType="RadComboBox" DefaultInsertValue="NA"/> <telerik:GridDropDownColumn UniqueName="ResponsibleParty" DataField="ResponsibleParty" HeaderText="Responsible Party" HeaderStyle-Width="150px" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" ListTextField="LevelCode" ListValueField ="IdentifierCode" DataSourceID="SQLDS_ResponsibleParty" DropDownControlType="RadComboBox" DefaultInsertValue="NA"/> <telerik:GridTemplateColumn UniqueName="Comments" DataField="Comments" HeaderText="Comments" HeaderStyle-Width="120px" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" > <ItemTemplate> <asp:Label ID="lblComments" runat="server" Text='<%# Bind("Comments") %>' /> <asp:ImageButton ID="ibtHistory" runat="server" ImageUrl='<%# Eval("HistoryImage") %>' ToolTip="Click To Show Status History" /> </ItemTemplate> <EditItemTemplate><telerik:RadTextBox ID="txtComments" runat="server" Text='<%# Bind("Comments") %>' TextMode="MultiLine" InputType="Text" Width="500px" Rows="5" Height="50px" Resize="Both" ButtonsPosition="Right"/></EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridBoundColumn UniqueName="CurrentlyDue" DataField="CurrentlyDue" HeaderText="Currently Due" HeaderStyle-Width="100px" ReadOnly="true" DataType="System.Decimal" DataFormatString="{0:#,###,###.#0}" ItemStyle-HorizontalAlign="Right" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" /> <telerik:GridBoundColumn UniqueName="Days31" DataField="Days31" HeaderText="Age 31-60 Days" HeaderStyle-Width="100px" ReadOnly="true" DataType="System.Decimal" DataFormatString="{0:#,###,###.#0}" ItemStyle-HorizontalAlign="Right" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" /> <telerik:GridBoundColumn UniqueName="Days61" DataField="Days61" HeaderText="Age 61-90 Days" HeaderStyle-Width="100px" ReadOnly="true" DataType="System.Decimal" DataFormatString="{0:#,###,###.#0}" ItemStyle-HorizontalAlign="Right" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" /> <telerik:GridBoundColumn UniqueName="Days91" DataField="Days91" HeaderText="Age > 90 Days" HeaderStyle-Width="100px" ReadOnly="true" DataType="System.Decimal" DataFormatString="{0:#,###,###.#0}" ItemStyle-HorizontalAlign="Right" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" /> <telerik:GridBoundColumn UniqueName="PastDue" DataField="PastDue" HeaderText="Payment Past Due" HeaderStyle-Width="100px" ReadOnly="true" DataType="System.Decimal" DataFormatString="{0:#,###,###.#0}" ItemStyle-HorizontalAlign="Right" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" /> <telerik:GridBoundColumn UniqueName="Pay30" DataField="Pay30" HeaderText="Due 0-30 Days" HeaderStyle-Width="100px" ReadOnly="true" DataType="System.Decimal" DataFormatString="{0:#,###,###.#0}" ItemStyle-HorizontalAlign="Right" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" /> <telerik:GridBoundColumn UniqueName="Pay60" DataField="Pay60" HeaderText="Due 31-60 Days" HeaderStyle-Width="100px" ReadOnly="true" DataType="System.Decimal" DataFormatString="{0:#,###,###.#0}" ItemStyle-HorizontalAlign="Right" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" /> <telerik:GridBoundColumn UniqueName="Pay90" DataField="Pay90" HeaderText="Due 61-90 Days" HeaderStyle-Width="100px" ReadOnly="true" DataType="System.Decimal" DataFormatString="{0:#,###,###.#0}" ItemStyle-HorizontalAlign="Right" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" /> <telerik:GridBoundColumn UniqueName="Pay91" DataField="Pay91" HeaderText="Due >90 Days" HeaderStyle-Width="100px" ReadOnly="true" DataType="System.Decimal" DataFormatString="{0:#,###,###.#0}" ItemStyle-HorizontalAlign="Right" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" /> <telerik:GridBoundColumn UniqueName="RecordId" DataField="RecordId" HeaderText="Record Id" HeaderStyle-Width="50px" ReadOnly="true" DataType="System.Int32" DataFormatString="{0:###}" ItemStyle-HorizontalAlign="Right" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" /> </Columns> </MasterTableView> </telerik:RadGrid></div>string username = (string)RadGrid1.SelectedValues["UserName"];
<telerik:RadGrid ID="RadGrid1" runat="server" ShowStatusBar="True" AutoGenerateColumns="False" PageSize="3" AllowSorting="True" AllowMultiRowSelection="False" AllowPaging="True" OnItemCreated="RadGrid1_ItemCreated" AllowAutomaticUpdates="True" OnItemUpdated="RadGrid1_ItemUpdated" Width="843px" onupdatecommand="RadGrid1_UpdateCommand" OnItemCommand="RadGrid1_ItemCommand" GridLines="None" Height="248px"> <MasterTableView DataSourceID="SqlDataSourceGrades" DataKeyNames="StudentID" AllowMultiColumnSorting="True" Width="100%" CommandItemDisplay="Top" Name="StudentID"> <Columns> <telerik:GridEditCommandColumn ButtonType="ImageButton" UniqueName="EditCommandColumn"> <HeaderStyle Width="20px"></HeaderStyle> <ItemStyle CssClass="MyImageButton"></ItemStyle> </telerik:GridEditCommandColumn> <telerik:GridBoundColumn SortExpression="StudentID" HeaderText="ID" HeaderButtonType="TextButton" DataField="StudentID" UniqueName="StudentID" MaxLength="7"> </telerik:GridBoundColumn><telerik:GridBoundColumn SortExpression="AC1" HeaderText="AC1" HeaderButtonType="TextButton" DataField="AC1" UniqueName="AC1"> </telerik:GridBoundColumn><telerik:GridBoundColumn SortExpression="GR1" HeaderText="GR1" HeaderButtonType="TextButton" DataField="GR1" UniqueName="GR1"> </telerik:GridBoundColumn><telerik:GridBoundColumn SortExpression="T1" HeaderText="T1" HeaderButtonType="TextButton" DataField="T1" UniqueName="T1"> </telerik:GridBoundColumn><telerik:GridBoundColumn SortExpression="AC2" HeaderText="AC2" HeaderButtonType="TextButton" DataField="AC2" UniqueName="AC2"> </telerik:GridBoundColumn><telerik:GridBoundColumn SortExpression="GR2" HeaderText="GR2" HeaderButtonType="TextButton" DataField="GR2" UniqueName="GR2"> </telerik:GridBoundColumn><telerik:GridBoundColumn SortExpression="T2" HeaderText="T2" HeaderButtonType="TextButton" DataField="T2" UniqueName="T2"> </telerik:GridBoundColumn><telerik:GridBoundColumn SortExpression="AC3" HeaderText="AC3" HeaderButtonType="TextButton" DataField="AC3" UniqueName="AC3"> </telerik:GridBoundColumn><telerik:GridBoundColumn SortExpression="GR3" HeaderText="GR3" HeaderButtonType="TextButton" DataField="GR3" UniqueName="GR3"> </telerik:GridBoundColumn><telerik:GridBoundColumn SortExpression="T3" HeaderText="T3" HeaderButtonType="TextButton" DataField="T3" UniqueName="T3"> </telerik:GridBoundColumn><telerik:GridBoundColumn SortExpression="AC4" HeaderText="AC4" HeaderButtonType="TextButton" DataField="AC4" UniqueName="AC4"> </telerik:GridBoundColumn><telerik:GridBoundColumn SortExpression="GR4" HeaderText="GR4" HeaderButtonType="TextButton" DataField="GR4" UniqueName="GR4"> </telerik:GridBoundColumn><telerik:GridBoundColumn SortExpression="T4" HeaderText="T4" HeaderButtonType="TextButton" DataField="T4" UniqueName="T4"> </telerik:GridBoundColumn><telerik:GridBoundColumn SortExpression="Sem1" HeaderText="Sem1" HeaderButtonType="TextButton" DataField="Sem1" UniqueName="Sem1"> </telerik:GridBoundColumn><telerik:GridBoundColumn SortExpression="Sem2" HeaderText="Sem2" HeaderButtonType="TextButton" DataField="Sem2" UniqueName="Sem2"> </telerik:GridBoundColumn><telerik:GridBoundColumn SortExpression="G" HeaderText="G" HeaderButtonType="TextButton" DataField="G" UniqueName="G"> </telerik:GridBoundColumn> <telerik:GridTemplateColumn> <ItemTemplate> <asp:Label ID="lblEvaluate" runat="server"></asp:Label> </ItemTemplate> </telerik:GridTemplateColumn> </Columns> <EditFormSettings EditFormType="Template"> <EditColumn UniqueName="EditCommanColumn1"></EditColumn> <FormTemplate> Test </FormTemplate> </EditFormSettings> <SortExpressions> <telerik:GridSortExpression FieldName="StudentID"></telerik:GridSortExpression> </SortExpressions> </MasterTableView> </telerik:RadGrid>