or
<telerik:RadNumericTextBox ID="txt" runat="server" MinValue="0"> <NumberFormat AllowRounding="true" DecimalDigits="2"></telerik:RadNumericTextBox><telerik:RadGrid ID="grdCurrentandPrior" runat="server" AllowSorting="True" AutoGenerateColumns="False" GridLines="Horizontal" Skin="Web20" Style="margin-right: 0px" Width="897px" Height="252px" OnNeedDataSource="grdCurrentandPrior_NeedDataSource" OnExcelMLExportRowCreated="grdCurrentandPrior_ExcelMLExportRowCreated" OnSortCommand="grdCurrentandPrior_SortCommand"> <exportsettings filename="OpenItemsCurrentInventory" ignorepaging="True" openinnewwindow="True" exportonlydata="true" excel-format="ExcelML"> </exportsettings> <mastertableview commanditemdisplay="Bottom" allownaturalsort="false" usealldatafields="true"> <CommandItemSettings ShowExportToExcelButton="true" ShowAddNewRecordButton="false" ShowRefreshButton="false" /> <Columns> <telerik:GridTemplateColumn DataField="Assignee" HeaderText="Assignee" UniqueName="Assignee" SortExpression="Assignee"> <HeaderStyle Font-Bold="True" Width="150px" HorizontalAlign="Center" Font-Names="Arial" /> <ItemTemplate> <asp:Label ID="lbAssignee" runat="server" Text='<%# Eval("Assignee") %>'></asp:Label> </ItemTemplate> <FooterStyle HorizontalAlign="Right" Font-Bold="true" /> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn DataField="State" HeaderText="State" UniqueName="State" SortExpression="State" Visible="false"> <HeaderStyle Font-Bold="True" Width="150px" HorizontalAlign="Center" Font-Names="Arial" /> <ItemTemplate> <asp:Label ID="lbState" runat="server" Text='<%# Eval("State") %>'></asp:Label> </ItemTemplate> <FooterStyle HorizontalAlign="Right" Font-Bold="true" /> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn DataField="JurisdictionCount" HeaderText="Jurisdictions" UniqueName="JurisdictionCount" SortExpression="JurisdictionCount"> <HeaderStyle Font-Bold="True" Width="80px" HorizontalAlign="Center" Font-Names="Arial" /> <ItemTemplate> <asp:Label ID="lbJurisdiction" runat="server" Text='<%# Eval("JurisdictionCount", "{0:N0}")%>'></asp:Label> </ItemTemplate> <ItemStyle HorizontalAlign="Right" ForeColor="Black" /> <FooterStyle HorizontalAlign="Right" Font-Bold="true" /> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn UniqueName="OpenItemsByAge" > <HeaderTemplate> <table id="Table1" cellspacing="0" cellpadding="0" width="300" border="0"> <tr> <td colspan="3" align="center"> <b>Open Items by Age</b> </td> </tr> <tr> <td align="center" style="width: 33%"> <asp:LinkButton CssClass="Button" ID="btnPrioOpen" Text="Prior" CommandName='Sort' CommandArgument='OpenItemsCountPrior' runat="server" /></td> <td align="center" style="width: 33%"> <asp:LinkButton CssClass="Button" ID="btnLastMonth" Text="Last Month" CommandName='Sort' CommandArgument='OpenItemsCountLastMonth' runat="server" /></td> <td align="center" style="width: 34%"> <asp:LinkButton CssClass="Button" ID="btnCurrentOpen" Text="Current" CommandName='Sort' CommandArgument='OpenItemsCountCurrent' runat="server" /></td> </tr> </table> </HeaderTemplate> <ItemTemplate > <table id="Table2" cellspacing="0" cellpadding="0" width="300" border="0"> <tr> <td align="right" width="33%"> <%# Eval("OpenItemsCountPrior", "{0:N0}") %> </td> <td align="right" width="33%"> <%# Eval("OpenItemsCountLastMonth", "{0:N0}")%> </td> <td align="right" width="34%"> <%# Eval("OpenItemsCountCurrent", "{0:N0}") %> </td> </tr> </table> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn Visible="False" DataField="OpenItemsCountPrior" HeaderText="Prior Open Items" UniqueName="OpenItemsCountPrior" SortExpression="OpenItemsCountPrior"> <HeaderStyle Font-Bold="True" Width="80px" HorizontalAlign="Center" Font-Names="Arial" /> <ItemTemplate> <asp:Label ID="lbPrior" runat="server" Text='<%# Eval("OpenItemsCountPrior", "{0:N0}") %>'></asp:Label> </ItemTemplate> <ItemStyle HorizontalAlign="Right" ForeColor="Black" /> <FooterStyle HorizontalAlign="Right" Font-Bold="true" /> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn Visible="False" DataField="OpenItemsCountLastMonth" HeaderText="Last Month Items" UniqueName="OpenItemsCountLastMonth" SortExpression="OpenItemsCountLastMonth"> <HeaderStyle Font-Bold="True" Width="80px" HorizontalAlign="Center" Font-Names="Arial" /> <ItemTemplate> <asp:Label ID="lbLastMonth" runat="server" Text='<%# Eval("OpenItemsCountLastMonth", "{0:N0}") %>'></asp:Label> </ItemTemplate> <ItemStyle HorizontalAlign="Right" ForeColor="Black" /> <FooterStyle HorizontalAlign="Right" Font-Bold="true" /> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn Visible="False" DataField="OpenItemsCountCurrent" HeaderText="Current Open Items" UniqueName="OpenItemsCountCurrent" SortExpression="OpenItemsCountCurrent"> <HeaderStyle Font-Bold="True" Width="100px" HorizontalAlign="Center" Font-Names="Arial" /> <ItemTemplate> <asp:Label ID="lbCurrent" runat="server" Text='<%# Eval("OpenItemsCountCurrent", "{0:N0}") %>'></asp:Label> </ItemTemplate> <ItemStyle HorizontalAlign="Right" ForeColor="Black" /> <FooterStyle HorizontalAlign="Right" Font-Bold="true" /> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn DataField="TotalRemainingItems" HeaderText="Items Left to Pay" UniqueName="TotalRemainingItems" SortExpression="TotalRemainingItems"> <HeaderStyle Font-Bold="True" Width="95px" HorizontalAlign="Center" Font-Names="Arial" /> <ItemTemplate> <asp:Label ID="lblTotalRemain" runat="server" Text='<%# Eval("TotalRemainingItems", "{0:N0}") %>'></asp:Label> </ItemTemplate> <ItemStyle HorizontalAlign="Right" ForeColor="Black" /> <FooterStyle HorizontalAlign="Right" Font-Bold="true" /> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn DataField="CompleteCount" HeaderText="Complete" UniqueName="CompleteCount" SortExpression="CompleteCount"> <HeaderStyle Font-Bold="True" Width="80px" HorizontalAlign="Center" Font-Names="Arial" /> <ItemTemplate> <asp:Label ID="lblCompleteCount" runat="server" Text='<%# Eval("CompleteCount", "{0:N0}") %>'></asp:Label> </ItemTemplate> <ItemStyle HorizontalAlign="Right" ForeColor="Black" /> <FooterStyle HorizontalAlign="Right" Font-Bold="true" /> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn DataField="PercentComplete" HeaderText="% Complete" UniqueName="clmPctComplete" SortExpression="PercentComplete"> <HeaderStyle Font-Bold="True" Width="85px" HorizontalAlign="Center" Font-Names="Arial" /> <ItemTemplate> <asp:Label ID="lblPctComplete" runat="server" Text='<%# Eval("PercentComplete", "{0:N2}%")%>'></asp:Label> </ItemTemplate> <ItemStyle HorizontalAlign="Right" ForeColor="Black" /> <FooterStyle HorizontalAlign="Right" Font-Bold="true" /> </telerik:GridTemplateColumn> <telerik:GridBoundColumn DataField="AssigneeEmployeeKey" ReadOnly="True" UniqueName="AssigneeEmployeeKey" Visible="False"> </telerik:GridBoundColumn> </Columns> </mastertableview> <headerstyle borderstyle="Solid" /> <clientsettings> <Scrolling AllowScroll="True" UseStaticHeaders="True" /> </clientsettings> </telerik:RadGrid>protected void grdCurrentandPrior_ExcelMLExportRowCreated(object source, GridExportExcelMLRowCreatedArgs e) { Int32 JurisdictionCount = 0; Int32 OpenItemsCountPrior = 0; Int32 OpenItemsCountCurrent = 0; Int32 TotalRemainingItems = 0; Int32 LastMonthItemsCount = 0; Int32 CompleteCount = 0; foreach (GridDataItem item in grdCurrentandPrior.MasterTableView.Items) { Label jc = (Label)item.FindControl("lbJurisdiction"); JurisdictionCount += Int32.Parse(jc.Text.Replace(",", "").Trim()); Label oipc = (Label)item.FindControl("lbPrior"); OpenItemsCountPrior += Int32.Parse(oipc.Text.Replace(",", "").Trim()); Label oicc = (Label)item.FindControl("lbCurrent"); OpenItemsCountCurrent += Int32.Parse(oicc.Text.Replace(",", "").Trim()); Label tr = (Label)item.FindControl("lblTotalRemain"); TotalRemainingItems += Int32.Parse(tr.Text.Replace(",", "").Trim()); Label lc = (Label)item.FindControl("lbLastMonth"); LastMonthItemsCount += Int32.Parse(lc.Text.Replace(",", "").Trim()); Label cc = (Label)item.FindControl("lblCompleteCount"); CompleteCount += Int32.Parse(cc.Text.Replace(",", "").Trim()); } if (e.Worksheet.Table.Rows.Count == grdCurrentandPrior.Items.Count + 1) { RowElement row = new RowElement(); GridFooterItem footer = (source as RadGrid).MasterTableView.GetItems(GridItemType.Footer)[0] as GridFooterItem; foreach (GridColumn column in (source as RadGrid).MasterTableView.Columns) { column.Visible = true; } foreach (GridColumn column in (source as RadGrid).MasterTableView.Columns) { CellElement cell = new CellElement(); string cellText = ""; if ((column.UniqueName == "Assignee") && (rdoAssignee.Checked == true)) cellText = "Totals"; else { if ((column.UniqueName == "State") && (rdoState.Checked == true)) cellText = "Totals"; } if (column.UniqueName == "JurisdictionCount") cellText = JurisdictionCount.ToString(); if (column.UniqueName == "OpenItemsCountPrior") cellText = OpenItemsCountPrior.ToString(); if (column.UniqueName == "OpenItemsCountCurrent") cellText = OpenItemsCountCurrent.ToString(); if (column.UniqueName == "TotalRemainingItems") cellText = TotalRemainingItems.ToString(); if (column.UniqueName == "OpenItemsCountLastMonth") cellText = LastMonthItemsCount.ToString(); if (cellText != "") { cell.Data.DataItem = cellText == " " ? "" : cellText; row.Cells.Add(cell); } } e.Worksheet.Table.Rows.Add(row); } }vb code
For Each a In aList ' Dynamically create radWindows '************************************************************************ Dim radWindow As New Telerik.Web.UI.RadWindow With radWindow .ID = "radWindow" & a .Modal = True .NavigateUrl = "http://test.aspx?a=" & a End With ' Add new radWindow to radWindowManager Me.RadWindowManager1.Windows.Add(radWindow) ' Dynamically create linkbutton ' ************************************************************************* Dim lbtnSchool As New LinkButton With lbtnSchool .ID = "lbtn" & a .OnClientClick = "openWindow('" & radWindow.ClientID & "');return false;" End With ' ************************************************************************** NextJavascript function
function openWindow(id) { var win; win = $find(id); win.show();}