Hi
Please help me out!
I have recently purchased a licence for the Q2 2016 devcraft tools and I am working on a website update...
I have a database in which numeric values have been recorded historically in an nvarchar column. I can't readily change the column type as it is in production and has several years of data in it.
However I would now like to use the aggregate function to put sum totals in a footer. How can I achieve this from where we are now - i.e. with a non-numeric data column? Obviously I get an error just adding aggregate="Sum" ( 'Sum is not supported for type system.object').
I tried cheating by just changing the column from gridbound to gridnumeric but it is not so easily fooled!
Can you suggest what is the best way to get from the nvarchar database column I have now, to getting an aggregate sum in the footer?
Thanks
Clive
Using Q2 2016 controls in VS 2015

I have a grid with two datetime column.
When i export this to Excel the time part of the date is not getting exported. only the date exported.
Hi,
How do I get RadImageGallery to restart the slideshow again, once it has finishes cycling through the images?
Thanks.
An

Hi, I used some code I found here to create a dependent grid. When the user clicks on a row, it opens two dependent grids that filter based on the row he/she clicked on. I am experiencing an error when I submit the form:
Exception of type 'System.Web.HttpUnhandledException' was thrown.
A control with ID 'ctl00$ctl04$fvlc$Form1$Grid1' could not be found for the trigger in UpdatePanel 'ctl00$ctl04$fvlc$Form1$Grid1Panel'.
As far as I can tell the Grid1 was defined in the form.
<sq:AjaxManager ID="AjaxManager1" runat="server">
<AjaxSettings>
<sq:AjaxSetting AjaxControlID="Grid1">
<UpdatedControls>
<sq:AjaxUpdatedControl ControlID="Grid1"></sq:AjaxUpdatedControl>
<sq:AjaxUpdatedControl ControlID="Grid2" LoadingPanelID="AjaxLoadingPanel1"></sq:AjaxUpdatedControl>
<sq:AjaxUpdatedControl ControlID="Grid3" LoadingPanelID="AjaxLoadingPanel1"></sq:AjaxUpdatedControl>
</UpdatedControls>
</sq:AjaxSetting>
<sq:AjaxSetting AjaxControlID="Grid2">
<UpdatedControls>
<sq:AjaxUpdatedControl ControlID="Grid2"></sq:AjaxUpdatedControl>
<sq:AjaxUpdatedControl ControlID="Grid3" LoadingPanelID="AjaxLoadingPanel1"></sq:AjaxUpdatedControl>
</UpdatedControls>
</sq:AjaxSetting>
<sq:AjaxSetting AjaxControlID="Grid3">
<UpdatedControls>
<sq:AjaxUpdatedControl ControlID="Grid3"></sq:AjaxUpdatedControl>
</UpdatedControls>
</sq:AjaxSetting>
</AjaxSettings>
</sq:AjaxManager>
<sq:AjaxLoadingPanel ID="AjaxLoadingPanel1" runat="server" Skin="Default"></sq:AjaxLoadingPanel>
Thanks for the help.

I am using Excel-Format="Biff" for my excel exports.
If there are no records in the grid, I get an index out of range error on clicking the export button. All other formats work fine. They just output an empty file but does not error out. I am unable to figure out why I get an index out of range error on the "biff" format export. Attached is the error details.
I also tried the code with advanced databinding using NeedDatasource event but I see the same behavior.
<telerik:RadGrid ID="rgParticipantBalances" runat="server" DataSourceID="_dataSrcBalances" OnPreRender="rgParticipantBalances_PreRender" OnItemCommand="rgParticipantBalances_ItemCommand" OnItemDataBound="rgParticipantBalances_ItemDataBound" OnItemCreated="rgParticipantBalances_ItemCreated" AllowFilteringByColumn="true" > <FilterItemStyle HorizontalAlign="Left" /> <MasterTableView TableLayout="Fixed" HierarchyDefaultExpanded="false" CommandItemDisplay="Top" DataKeyNames="" EnableNoRecordsTemplate="true"> <CommandItemSettings ShowAddNewRecordButton="false" ShowRefreshButton="false" ShowExportToExcelButton="true" ExportToExcelText="" ExportToCsvText="" ExportToPdfText="" ExportToWordText="" ShowExportToPdfButton="true" ShowExportToWordButton="true" ShowExportToCsvButton="true" /> <NoRecordsTemplate> <div style="color: Red; font-size: 12px; font-family: Verdana, Arial, Helvetica, sans-serif; font-weight: bold"> <br /> Please select a plan to show activity for the specific plan. </div> </NoRecordsTemplate> <Columns> <telerik:GridTemplateColumn UniqueName="Participant" HeaderText="Participant" SortExpression="FullName" HeaderStyle-HorizontalAlign="Left" CurrentFilterFunction="Contains" ShowFilterIcon="false" DataField="FullName" ItemStyle-HorizontalAlign="Left" FooterStyle-HorizontalAlign="Left" AutoPostBackOnFilter="true" HeaderStyle-Width="16%" FilterControlWidth="130px" FilterControlToolTip="Input a name or part of name to search"> <ItemTemplate> <%# Eval("FullName")%> </ItemTemplate> <FooterTemplate> <asp:Label ID="lblGrandTotal" runat="server" Text="Grand Total" Font-Bold="true"></asp:Label> </FooterTemplate> </telerik:GridTemplateColumn> </Columns> </MasterTableView> <ExportSettings ExportOnlyData="true" IgnorePaging="true" FileName="Activity" OpenInNewWindow="true" HideStructureColumns="true" SuppressColumnDataFormatStrings="false"> <Pdf PaperSize="A4" PageLeftMargin="5px" PageRightMargin="5px" PageWidth="297mm" PageHeight="210mm" /> <Excel Format="Biff" /> </ExportSettings> </telerik:RadGrid>Hi,
I'm using OrgChart in one project to display some hierarchies. To adapt the look of it to my project design i'm using the code posted below.
Now, locally it works fine on all browsers I test it (chrome, IE 11, Firefox). If I publish it on the server (IIS 8.5 .NET 4.5) the look on IE change badly.(on other browsers looks fine)
Attached , the images with differences.
Remarks:
Thank you,
Ionel
html .RadOrgChart_Default .rocItemContent, html .RadOrgChart_Default .rocItemTemplate { /*background-color: rgba(255,255,255,0.2);*/ background-image: none; /*color: white;*/ border:none; background:none; width:auto; min-width:300px; height:auto; }
<telerik:RadOrgChart RenderMode="Lightweight" ID="RadOrgChartHorizontal" runat="server"
DataSourceID="SQLDataSourceHorizontalHierarchy"
DataFieldID="Contract_Key"
DataFieldParentID="Contract_Parent_Key"
DataTextField="Name" EnableCollapsing="True" EnableGroupCollapsing="True" Orientation="Horizontal">
<ItemTemplate >
<section class="panel panel-featured panel-featured-tertiary">
<div class="panel-body">
<div class="widget-summary">
<div class="widget-summary-col">
<div class="summary">
<h4 class="amount"><%#Eval("Name")%></h4>
<div class="info">
<strong class="title"><%#Eval("Contract_Type_Name")%></strong>
<span class="text-primary">(<%#Eval("Contract_Type_Category")%>)</span>
</div>
</div>
<div class="summary-footer">
<a class="text-muted text-uppercase">Details</a>
</div>
</div>
</div>
</div>
</section>
</ItemTemplate>
<RenderedFields>
<NodeFields>
<telerik:OrgChartRenderedField DataField="Name" Label="Name" />
</NodeFields>
<ItemFields>
<telerik:OrgChartRenderedField DataField="Contract_Type_Category" Label="Category" />
</ItemFields>
<ItemFields>
<telerik:OrgChartRenderedField DataField="Contract_Type_Name" Label="Type" />
</ItemFields>
</RenderedFields>
</telerik:RadOrgChart>
I have inherited an application that has used Telerik.Web.Mvc DLL. It was developed circa 2010. I needed to work on the menu sizes and I asked for help from the Telerik guys. They suggested that the application being so old I should migrate to the latest code. Which I did. But I lost all the Telerik.Web.Mvc sitemap part. And now I am lost. I am not sure what comes after SiteMapManager. I cannot find any documentation on it, I do not understand how to migrate.
Can somebody help me with this issue?
Thank you.
I am changing the background color of a date ( that is being provided from the database ) by using the Calendar OnDayRender. The problem is that when the page initially loads the background color is not present. But if I change the month, then go back to the previous month, the background color appears.
ASP:
<telerik:RadDatePicker AutoPostBack="true" OnSelectedDateChanged="rdpEnd_SelectedDateChanged" ID="rdpEnd" ToolTip="" class="form-control" Style="width: 100%;" Height="30px" aria-describedby="ptoEndDate" runat="server"><DatePopupButton ToolTip="" /><Calendar runat="server" ShowRowHeaders="false" OnDayRender="CustomizeDay"></Calendar></telerik:RadDatePicker>
C#
protected void CustomizeDay(object sender, Telerik.Web.UI.Calendar.DayRenderEventArgs e){ DateTime CurrentDate = e.Day.Date; using (DataClassesDataContext db = new DataClassesDataContext()) { if(db.Calendars.Where(x => x.date.Value.Date == e.Day.Date).Any()) { TableCell currentCell = e.Cell; currentCell.Style["background-color"] = "#000000"; } }}
