When exporting a RadGrid to excel, how do I get the backcolor of my rows to not extend infinitely. My RadGrid has 11 columns but when I export to excel, the backcolor of my alternateitemstyle extends past 11 columns. This is my RadGrid code:
<telerik:RadGrid ID="On_Time_Receipt_Summary" runat="server" RenderMode="Lightweight" Height="700px" Width="1300px" ShowFooter="true"OnCustomAggregate="On_Time_Receipt_Summary_CustomAggregate" OnExportCellFormatting="On_Time_Receipt_Summary_ExportCellFormatting"> <ClientSettings><Scrolling AllowScroll="True" UseStaticHeaders="true" /><Resizing AllowColumnResize="true" AllowRowResize="true" ClipCellContentOnResize="false" ResizeGridOnColumnResize="true" /></ClientSettings><ExportSettings ExportOnlyData="true" Excel-FileExtension="xls" Excel-Format="ExcelML" FileName="On_Time_Receipt_Summary" OpenInNewWindow="true" UseItemStyles="true"></ExportSettings><MasterTableView AutoGenerateColumns="false"><HeaderStyle BackColor="#839DBE" BorderStyle="Solid" Font-Bold="False" Wrap="False"ForeColor="White" Font-Names="Arial" Font-Size="8pt" BorderWidth="1px"Height="50px" /><ItemStyle BackColor="White" Font-Size="8pt" Font-Names="Arial" ForeColor="Black" Wrap="False" /><AlternatingItemStyle BackColor="#e1e6ef" Font-Size="8pt" Font-Names="Arial" ForeColor="Black" Wrap="False" /><FooterStyle BackColor="#839DBE" BorderStyle="Solid" Font-Bold="False" Wrap="False"ForeColor="White" Font-Names="Arial" Font-Size="8pt" BorderWidth="1px"Height="25px" /><Columns><telerik:GridBoundColumn DataField="Vendor" HeaderText="Vendor" HeaderStyle-Width="65px" FooterText="Total:"></telerik:GridBoundColumn><telerik:GridBoundColumn DataField="Vendor Name" HeaderText="Vendor Name" HeaderStyle-Width="225px"></telerik:GridBoundColumn><telerik:GridNumericColumn DataField="Total Receipt Lines" HeaderText="Total Receipt Lines" HeaderStyle-Width="50px" DataFormatString="{0:#,##0;}" Aggregate="Sum"><ItemStyle HorizontalAlign="Right" /><FooterStyle HorizontalAlign="Right" /></telerik:GridNumericColumn><telerik:GridNumericColumn DataField="Total Received Qty" HeaderText="Total Received Qty" HeaderStyle-Width="65px" DataFormatString="{0:#,##0;}" Aggregate="Sum"><ItemStyle HorizontalAlign="Right" /><FooterStyle HorizontalAlign="Right" /></telerik:GridNumericColumn><telerik:GridNumericColumn DataField="Cost Amount" HeaderText="Cost Amount" HeaderStyle-Width="70px" DataFormatString="{0:$#,##0;}" Aggregate="Sum"><ItemStyle HorizontalAlign="Right" /><FooterStyle HorizontalAlign="Right" /></telerik:GridNumericColumn><telerik:GridNumericColumn DataField="On Time" HeaderText="On Time" HeaderStyle-Width="50px" DataFormatString="{0:#,##0;}" Aggregate="Sum"><ItemStyle HorizontalAlign="Right" /><FooterStyle HorizontalAlign="Right" /></telerik:GridNumericColumn><telerik:GridNumericColumn DataField="On Time Pct" HeaderText="On Time Pct" HeaderStyle-Width="50px" UniqueName="OnTimePct" Aggregate="Custom" FooterAggregateFormatString="{0:0%}"><ItemStyle HorizontalAlign="Right" /><FooterStyle HorizontalAlign="Right" /></telerik:GridNumericColumn><telerik:GridNumericColumn DataField="On Time 90% Fill Rate" HeaderText="On Time 90% Fill Rate" HeaderStyle-Width="65px" DataFormatString="{0:#,##0;}" Aggregate="Sum"><ItemStyle HorizontalAlign="Right" /><FooterStyle HorizontalAlign="Right" /></telerik:GridNumericColumn><telerik:GridNumericColumn DataField="On Time 90% Fill Rate Pct" HeaderText="On Time 90% Fill Rate Pct" HeaderStyle-Width="65px" UniqueName="OnTimeFillRatePct" Aggregate="Custom" FooterAggregateFormatString="{0:0%}"><ItemStyle HorizontalAlign="Right" /><FooterStyle HorizontalAlign="Right" /></telerik:GridNumericColumn><telerik:GridBoundColumn DataField="Purchaser" HeaderText="Purchaser" HeaderStyle-Width="100px"></telerik:GridBoundColumn><telerik:GridBoundColumn DataField="Responsibility Center" HeaderText="Responsibility Center" HeaderStyle-Width="100px"></telerik:GridBoundColumn></Columns></MasterTableView></telerik:RadGrid>
If you go at the demo https://demos.telerik.com/aspnet-ajax/fileexplorer/examples/server-sideapi/dbfilebrowsercontentprovider/defaultcs.aspx and try to rename the file with a extension that are not accepted (example ".txt" that are not in Configuration.SearchPatterns) you obtain the message "The selected folder could not be created because the application did not have enough permissions. Please, contact the administrator.".
The same error are displayed if you edit have the Configuration-AllowFileExtensionRename="false" and use a dot in the name of file.
This message are inappropriate for the context.

<telerik:RadGrid ID="gvPreAddReturnsRequiringUserConfirmation" runat="server" Width="100%" AllowPaging="true" BorderStyle="None" ShowHeader="true" ShowFooter="false" PageSize="2" AutoGenerateColumns="false"> <PagerStyle AlwaysVisible="false" /> <MasterTableView RetrieveAllDataFields="false" ClientDataKeyNames="PreAddReturnID" DataKeyNames="PreAddReturnID"> <Columns> <telerik:GridBoundColumn UniqueName="UniqueIdentifier" DataField="UniqueIdentifier" HeaderText="Unique ID"> <ItemStyle Width="15%" /> <HeaderStyle Width="15%" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn UniqueName="FirstName" DataField="FirstName" HeaderText="First Name"> <ItemStyle Width="20%" HorizontalAlign="Center" /> <HeaderStyle Width="20%" HorizontalAlign="Center" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn UniqueName="LastOrBusinessName" DataField="LastOrBusinessName" HeaderText="Last/Business Name"> <ItemStyle Width="20%" HorizontalAlign="Center" /> <HeaderStyle Width="20%" HorizontalAlign="Center" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn UniqueName="StreetAddress" DataField="StreetAddress" HeaderText="Address"> <ItemStyle Width="15%" HorizontalAlign="Center" /> <HeaderStyle Width="15%" HorizontalAlign="Center" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn UniqueName="City" DataField="City" HeaderText="City"> <ItemStyle Width="10%" HorizontalAlign="Center" /> <HeaderStyle Width="10%" HorizontalAlign="Center" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn UniqueName="StateCode" DataField="StateCode" HeaderText="State"> <ItemStyle Width="5%" HorizontalAlign="Center" /> <HeaderStyle Width="5%" HorizontalAlign="Center" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn UniqueName="ZipCode" DataField="ZipCode" HeaderText="Zip Code"> <ItemStyle Width="10%" HorizontalAlign="Center" /> <HeaderStyle Width="10%" HorizontalAlign="Center" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn UniqueName="IOCMatchIndicator" DataField="IOCMatchIndicator" HeaderText="Match Indicator"> <ItemStyle Width="5%" HorizontalAlign="Center" /> <HeaderStyle Width="5%" HorizontalAlign="Center" /> </telerik:GridBoundColumn> </Columns> <NoRecordsTemplate> <div class="box_notification info"> No PreAdd Returns</div> </NoRecordsTemplate> </MasterTableView> </telerik:RadGrid>Hello,
I have a <telerik:RadGrid> which contains some <telerik:GridBoundColumn> elements. Until now the AutoPostBackOnFilter value was set to true. This means the grid had its contents updated every time I left the focus of one of the GridBoundColumns. This is not a desired behavior anymore. Now I just want to trigger the filtering manually by let's say clicking on a button. So I set all the AutoPostBackOnFilter values to false and created a button with the according serverside event handler, which is empty so far :)
How could I implement this requirement?
Thanks in advance!

I have a situation in which I create the next level of items in a TreeList in the ChildItemsDataBind event.
At some levels of the tree, there are a large number of child items being created.
And, each of these items requires a lengthy query to obtain the fields to populate it.
This scenario can take as long as 10 seconds or more in some cases.
When this case arises, the user has no idea if anything is happening and may believe the page is frozen or has crashed.
I need to display a ProgressArea or UpdateProgress to make it clear work is being done.
I can do this no problem by initiating the process with something like a button click event.
What I would like to do is have this process initiated when a specific item of the TreeList level is selected.
Is there a way to initiate and display a ProgressArea or UpdateProcess from some TreeList event?

I'm trying to get a row of a TreeList to change appearance when the mouse is over it.
I can do this in css style for a GridView.
But there doesn't seem to be similar functionality for a tree list row.
Does anyone know if this can be done?

We did some research on Azure Bot Framework and we found out that we need to use code to build our Chatbot's dialog.
Does Telerik has plan to build something similar to IBM Watson Assistant's visual dialog editor?
Screencap: https://www.ibm.com/cloud/watson-assistant/assets/img/image_1.png
The visual dialog editor is very easy to use to create complex dialogues for their Chatbot.
Thanks.
Hi
I am implementing a reporting dashboard ASP.NET page. To do this I have an ASPX page with multiple RadDockZones and RadDocks, each containing a reference to a user control (ASCX page) which contains the RadHtmlChart.
Several of these charts have drill-downs which use RadAjaxManager and a client side function called from the chart. See...
https://demos.telerik.com/aspnet-ajax/htmlchart/examples/drilldownchart/defaultvb.aspx
Individually, the charts work fine but when incorporated within the parent dashboard page I get a message saying you can't have more than one RadAjaxManager on the same page.
Google searches told me to use RadAjaxManagerProxy instead, with the RadAjaxManager on the parent page. However, I have no idea how to do this. None of the solutions I found seem to be suitable for my problem. One said that RadAjaxManagerProxy does not have client-side object or functions. I am using the ajaxRequest client-side function, so perhaps this is my problem.
Is what I am trying to do even possible? If so, how?
Thanks
Nick
Hi
I hope you can help. We are implementing a .NET reporting dashboard whereby our page will consist of multiple RadHtmlChart controls. Each control sits in its own web part called from the parent page and housed in RadDocks.
For performance reasons we'd like the charts to render asynchronously. We have tried to achieve this using a web service in the manner shown below.
However, the charts do not render at all. Any other control we place in our web parts work fine (dropdown, radgrid etc.). Just not RadHtmlChart. Have you any ideas why this would be? Should we be using another method of doing this?
function DockInitialize(dock, args) {
logIt("INVOKE WidgetsWebService:" + dock.get_id());
var dockID = dock.get_id();
var CompanyID = $get(dockID).attributes["CompanyID"].value;
Revolution.WidgetsWebService.GetData(CompanyID, function (result) {
$get(dockID + "_C").innerHTML = result;
logIt("END INVOKE WidgetsWebService:" + dock.get_id());
});
}
<asp:ScriptManager ID="ScriptManager1" runat="server">
<Services>
<asp:ServiceReference Path="~/Services/WidgetsWebService.asmx" />
</Services>
</asp:ScriptManager>
------------------------------------------------------------------------------------------------------------------------------
<System.Web.Script.Services.ScriptService()>
<System.Web.Services.WebService(Namespace:="http://tempuri.org/")> _
<System.Web.Services.WebServiceBinding(ConformsTo:=WsiProfiles.BasicProfile1_1)> _
<ToolboxItem(False)> _
Public Class WidgetsWebService
Inherits System.Web.Services.WebService
<WebMethod()>
Public Function GetData(ByVal elementID As String) As String
Thread.Sleep(2000)
If elementID = String.Empty Then
Throw New Exception("No Value argument is provided to the webservice!")
End If
Return ViewManager.RenderView("~/Dev/Consultants/Dashboard/Widgets/Other/TestControl.ascx")
End Function
End Class
------------------------------------------------------------------------------------------------------------------------------
Public Shared Function RenderView(ByVal path As String) As String
Thread.Sleep(200)
Dim pageHolder As Test = New Test()
Dim tempForm As HtmlForm = New HtmlForm()
tempForm.ID = "TempForm"
pageHolder.Controls.Add(tempForm)
Dim viewControl As UserControl = CType(pageHolder.LoadControl(path), UserControl)
viewControl.ID = Guid.NewGuid().ToString()
Dim scriptManager As New ScriptManager()
tempForm.Controls.Add(scriptManager)
tempForm.Controls.Add(viewControl)
Dim output As StringWriter = New StringWriter()
HttpContext.Current.Server.Execute(pageHolder, output, False)
Dim result As String = output.ToString()
Return result
End Function
------------------------------------------------------------------------------------------------------------------------------
and this is our TestControl.ascx web part
<%@ Control Language="vb" AutoEventWireup="false" CodeBehind="TestControl.ascx.vb" Inherits="Revolution.TestControl" %>
<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>
<div id="content">
<telerik:RadHtmlChart runat="server" ID="ColumnChart">
<PlotArea>
<Series>
<telerik:ColumnSeries Name="Wooden Table">
<SeriesItems>
<telerik:CategorySeriesItem Y="25000"></telerik:CategorySeriesItem>
<telerik:CategorySeriesItem Y="12000"></telerik:CategorySeriesItem>
</SeriesItems>
</telerik:ColumnSeries>
</Series>
<XAxis>
<Items>
<telerik:AxisItem LabelText="1"></telerik:AxisItem>
</Items>
<TitleAppearance Position="Center" RotationAngle="0" Text="Quarters">
</TitleAppearance>
</XAxis>
<YAxis>
<LabelsAppearance DataFormatString="{0} sales" RotationAngle="0" Skip="0" Step="1"></LabelsAppearance>
<TitleAppearance Position="Center" RotationAngle="0" Text="Sales">
</TitleAppearance>
</YAxis>
</PlotArea>
</telerik:RadHtmlChart>
</div>
<form id="form1" runat="server"> <telerik:RadScriptManager ID="RadScriptManager1" runat="server" /> <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server"> <AjaxSettings> <telerik:AjaxSetting AjaxControlID="RadGrid1"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="RadGrid1" /> </UpdatedControls> </telerik:AjaxSetting> </AjaxSettings> </telerik:RadAjaxManager> <telerik:RadGrid ID="RadGrid1" runat="server" AutoGenerateColumns="false" DataSourceID="gridRequest" Edit = "true"> <MasterTableView EditMode = "InPlace" > <Columns> <telerik:GridBoundColumn DataField="Program" HeaderText="Program" ></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Organization" HeaderText="Organization"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Campaign" HeaderText="Campaign" ></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="MinEmployeeCnt" HeaderText="MinEmployeeCnt" ></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="MaxEmployeeCnt" HeaderText="MaxEmployeeCnt" ></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="MinSalesVolume" HeaderText="MinSalesVolume" ></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="MaxSalesVolume" HeaderText="MaxSalesVolume" ></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="LandLineOnly" HeaderText="LandLineOnly" ></telerik:GridBoundColumn> </Columns> </MasterTableView> </telerik:RadGrid> <asp:ObjectDataSource ID="gridRequest" runat="server" SelectMethod="SelectBusiness" TypeName="G2WebBL.DataMappers.LeadsRequest.LeadsRequestDataAccess"> <SelectParameters><asp:SessionParameter Name="id" DbType="String" DefaultValue="%" SessionField="ID" /></SelectParameters> </asp:ObjectDataSource></form>