Questions on Community Forums Forum

4 answers

268 views

Export asp:Repeater including RadHtmlChart and RadGrid to Excel

Hi Telerik Team,
How to Export asp:Repeater including RadHtmlChart and RadGrid to Excel in C# in Code Behind or JQUERY?
I am trying to export some data to Excel and my code is as below:

<asp:Repeater ID="repeaterStandardQuestion" runat="server" OnItemDataBound="repeaterStandardQuestion_ItemDataBound">

<ItemTemplate>

<div style="border: solid">

<table>

<tr>

<td>

<div style="text-align: left">

<asp:Label ID="lblTitleStandardQuestion" runat="server" />

</div>

<telerik:RadHtmlChart runat="server" ID="radHtmlChartStandardQuestion" Transitions="true" Width="400px" Height="200px" RegisterWithScriptManager="true">

<PlotArea>

<Series>

<telerik:BarSeries Name="Average" DataFieldY="PercentageAccepted">

<TooltipsAppearance DataFormatString="{0:##.##}%"></TooltipsAppearance>

<LabelsAppearance DataFormatString="{0:##.##}%" Position="Center"></LabelsAppearance>

<Appearance FillStyle-BackgroundColor="LightBlue"></Appearance>

</telerik:BarSeries>

</Series>

<XAxis DataLabelsField="Name">

<MajorGridLines Visible="false" />

<MinorGridLines Visible="false" />

</XAxis>

<YAxis MaxValue="100">

<LabelsAppearance DataFormatString="{0:#}%"></LabelsAppearance>

<MinorGridLines Visible="false"></MinorGridLines>

<MajorGridLines Visible="false" />

</YAxis>

</PlotArea>

<Legend>

<Appearance Position="Bottom" Visible="false" />

</Legend>

</telerik:RadHtmlChart>

</td>

<td>

<telerik:RadGrid ID="radGridStandardQuestion" runat="server" AutoGenerateColumns="false" Width="200px">

<MasterTableView>

<Columns>

<telerik:GridBoundColumn DataField="Name" HeaderText="Answer Choices" HeaderStyle-Font-Bold="true"></telerik:GridBoundColumn>

<telerik:GridTemplateColumn HeaderText="Responses" HeaderStyle-Font-Bold="true">

<ItemTemplate>

<%#GetPercentage( Convert.ToDouble(Eval("PercentageAccepted"))) %>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridBoundColumn DataField="NumberAccepted" HeaderText=""></telerik:GridBoundColumn>

</Columns>

</MasterTableView>

</telerik:RadGrid>

</td>

</tr>

</table>

</div>

<br />

</ItemTemplate>

</asp:Repeater>

Regards
Antoine Sweid

AJAX and Web 2.0

answered on 05 Jun 2013

1 answer

96 views

Reporting on Telerik controls

Hello, has anyone ever come across a way to report on which projects in TFS are using some type of Telerik controls such that you can determine by project name the telerik/kendo control name and version used?

Thanks,
Jon

Interesting resources

answered on 22 May 2013

1 answer

96 views

Issue on Resizing RadSlidingZone Panel

Sir/Mam,

I am adding telerik treeview in radpane inside radsliding zone dynamically whenever i re size it inwards i.e if i re size it and reduce its width then it distorts i.e it breaks half and we can see page behind it form half of its region and it sets properly if we again re size and increase its width.

summing up..Radsliding zone gets broken when we re size the radsliding zone and reduce its width
I am not able to attach screenshot here otherwise it would have been more clear.

hopefully i'll get your help soon..

Best Regards,

Chandrashekar A Menga

Telerik Trainer

answered on 22 May 2013

0 answers

118 views

Help in creating a CRUD application

%@ Page Language="VB" AutoEventWireup="false" CodeFile="Daily.aspx.vb" Inherits="Daily" %> <%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <%@ Register Assembly="RJS.Web.WebControl.PopCalendar" Namespace="RJS.Web.WebControl" TagPrefix="rjs" %> <html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server">   <title>Daily Fuel Log</title>   <style type="text/css" media="print">     ..noprint {DISPLAY: none}   </style> </head> <body>     <form id="form1" runat="server">          <telerik:RadScriptManager ID="RadScriptManager1" runat="server"> </telerik:RadScriptManager>       <center>         <asp:Menu ID="MenuAvDaily" CssClass="noprint" runat="server" Orientation="Horizontal">           <StaticMenuStyle BackColor="#0066CC" BorderColor="#0066CC" BorderStyle="Outset" HorizontalPadding="10px"             VerticalPadding="4px" />           <StaticMenuItemStyle BackColor="#0066CC" BorderStyle="None" BorderWidth="0px" Font-Size="Smaller"             ForeColor="White" />           <DynamicHoverStyle Font-Bold="True" />           <Items>             <asp:MenuItem NavigateUrl="~/NewAircraft.aspx" Text="Planes" Value="Planes"></asp:MenuItem>                          <asp:MenuItem Text="Reports"  Value="Reports" Selectable="False">               <asp:MenuItem Text="Bulk Plant" Value="Daily" NavigateUrl="~/ReportBulkPlant.aspx"></asp:MenuItem>               <asp:MenuItem Text="Monthly" Value="Fuel Report" NavigateUrl="~/ReportFuelByPlane.aspx"></asp:MenuItem>               <asp:MenuItem Text="Fuel Used" Value="Fuel Used" NavigateUrl="~/ReportFuelUsed.aspx"></asp:MenuItem>               <asp:MenuItem Text="Fuel Received" Value="Fuel Received" NavigateUrl="~/ReportFuelReceived.aspx"></asp:MenuItem>             </asp:MenuItem>             <asp:MenuItem Text="Exit" Value="Exit"></asp:MenuItem>           </Items>           <StaticHoverStyle Font-Bold="True" />         </asp:Menu>         &nbsp;</center>       <center>         <asp:Label ID="Label1" runat="server" Text="My Aviation Daily Fuel Log" ForeColor="#0066CC" Font-Bold="True" Font-Size="X-Large" Font-Underline="True" ></asp:Label>       </center>       telerik:RadScriptManager ID="RadScriptManager1" runat="server"> </telerik:RadScriptManager> <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">   <AjaxSettings>     <telerik:AjaxSetting AjaxControlID="RadGrid1">       <UpdatedControls>         <telerik:AjaxUpdatedControl ControlID="RadGrid1" LoadingPanelID="RadAjaxLoadingPanel1" />       </UpdatedControls>     </telerik:AjaxSetting>   </AjaxSettings> </telerik:RadAjaxManager> <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" /> <telerik:RadGrid ID="RadGrid1" runat="server" DataSourceID="EntityDataSourceCustomers"   GridLines="None" AllowPaging="True" AllowAutomaticUpdates="True" AllowAutomaticInserts="True"   AllowSorting="true" Width="750px" OnItemCreated="RadGrid1_ItemCreated">   <PagerStyle Mode="NextPrevAndNumeric" />   <MasterTableView DataSourceID="EntityDataSourceCustomers" AutoGenerateColumns="False"     DataKeyNames="PK" CommandItemDisplay="Top">     <Columns>       <telerik:GridEditCommandColumn ButtonType="ImageButton" UniqueName="EditCommandColumn">       </telerik:GridEditCommandColumn>       <telerik:GridBoundColumn DataField="PK" HeaderText="PK" SortExpression="PK"         UniqueName="PK" Visible="false" MaxLength="5">       </telerik:GridBoundColumn>       <telerik:GridBoundColumn DataField="Plane" HeaderText="Plane" SortExpression="Plane"         UniqueName="Plane">       </telerik:GridBoundColumn>       <telerik:GridBoundColumn DataField="Fuel" HeaderText="Fuel" SortExpression="Fuel"         UniqueName="Fuel">       </telerik:GridBoundColumn>       <telerik:GridBoundColumn DataField="Total" HeaderText="Total" SortExpression="Total"         UniqueName="Total">       </telerik:GridBoundColumn>       <%--<telerik:GridBoundColumn DataField="Phone" HeaderText="Phone" SortExpression="Phone"         UniqueName="Phone">       </telerik:GridBoundColumn> --%>     </Columns>     <EditFormSettings>       <EditColumn ButtonType="ImageButton" />     </EditFormSettings>   </MasterTableView> </telerik:RadGrid>       <center>         <br />          <%-- <clientsettings allowcolumnsreorder="True"                allowdragtogroup="True">                             </clientsettings>                             <mastertableview autogeneratecolumns="false"                commanditemdisplay="Bottom" datakeynames="PK" editmode="InPlace">                               <editformsettings captiondatafield="PK"                captionformatstring="Edit Connection: {0}" insertcaption="Add New Connection"                popupsettings-modal="true">                             <editcolumn uniquename="EditCommandColumn1"></editcolumn>                             <popupsettings modal="True"></popupsettings>                                           </editformsettings>                             <rowindicatorcolumn>                             <HeaderStyle Width="20px"></HeaderStyle>                             </rowindicatorcolumn>                                            <commanditemsettings exporttopdftext="Export to Pdf"></commanditemsettings>                             <expandcollapsecolumn visible="True">                             </expandcollapsecolumn>                                 <Columns>                                     <telerik:GridBoundColumn DataField="Plane" HeaderText="Plane" ReadOnly="true"                                          SortExpression="Key" UniqueName="Plane" Visible="false"                                          FilterControlAltText="Filter Plane column">                                     </telerik:GridBoundColumn>                                     <telerik:GridBoundColumn DataField="Fuel" HeaderText="Fuel"                                          ReadOnly="true" SortExpression="Fuel" UniqueName="Fuel"                                          FilterControlAltText="Filter Fuel column">                                     </telerik:GridBoundColumn>                                    <telerik:GridBoundColumn DataField="Total" HeaderText="Total"                                          ReadOnly="true" SortExpression="Total" UniqueName="Total"                                          FilterControlAltText="Filter Total column">                                     </telerik:GridBoundColumn>                                     <telerik:GridTemplateColumn AllowFiltering="False"                                          AndCurrentFilterFunction="Contains" AutoPostBackOnFilter="True"                                          ColumnEditorID="Inventory" CurrentFilterFunction="Contains"                                          DataField="Inventory" DataType="System.String"                                          FilterControlAltText="Filter Inventory column"                                          HeaderText="Inventory" UniqueName="Inventory">                                          <EditItemTemplate>                                             <telerik:RadTextBox ID="txtDecryptedString" runat="server" AllowCustomText="true"                                                   EnableLoadOnDemand="true" EnableScreenBoundaryDetection="true"                                                   Filter="contains" HighlightTemplatedItems="true" MarkFirstMatch="false"                                                   Text='<%# Bind("Inventory") %>' Width="100%">                                             </telerik:RadTextBox>                                             </EditItemTemplate>                                               <ItemTemplate>                                                   <div style="text-align: left">                                                   <asp:Label ID="Label2" runat="server" style="text-align:left"                                                            Text='<%# Bind("Inventory") %>'></asp:Label></div>                                               </ItemTemplate>                                          <HeaderStyle Width="100%" />                                       </telerik:GridTemplateColumn>                                 </Columns>                                 <commanditemsettings exporttopdftext="Export to PDF" />                                 <rowindicatorcolumn                filtercontrolalttext="Filter RowIndicator column">                                     <HeaderStyle Width="20px" />                                 </rowindicatorcolumn>                                 <expandcollapsecolumn                filtercontrolalttext="Filter ExpandColumn column">                                     <HeaderStyle Width="20px" />                                 </expandcollapsecolumn>                                 <editformsettings>                                     <editcolumn                filtercontrolalttext="Filter EditCommandColumn column">                                     </editcolumn>                                 </editformsettings>                             </mastertableview>                             <filtermenu enableimagesprites="False">                             </filtermenu>                             <headercontextmenu                cssclass="GridContextMenu GridContextMenu_Default">                             </headercontextmenu>                         </telerik:RadGrid>       </center>--%>     <%--<telerik:RadGrid ID="RadGrid1" runat="server" Skin="Web20" GridLines="None" AllowPaging="True"   AllowSorting="True" Width="100%" OnNeedDataSource="RadGrid1_NeedDataSource"   OnDeleteCommand="RadGrid1_DeleteCommand" OnInsertCommand="RadGrid1_InsertCommand"   OnUpdateCommand="RadGrid1_UpdateCommand" AllowAutomaticDeletes="True"                AllowAutomaticInserts="True" AllowAutomaticUpdates="True"                AllowFilteringByColumn="True" AutoGenerateDeleteColumn="True"                AutoGenerateEditColumn="True" CellSpacing="0" ShowGroupPanel="True"                AutoGenerateColumns="False">   <PagerStyle Mode="NextPrevAndNumeric"></PagerStyle>       <ClientSettings AllowColumnsReorder="True" AllowDragToGroup="True"            ReorderColumnsOnClient="True">           <Selecting AllowRowSelect="True" />           <Scrolling AllowScroll="True" UseStaticHeaders="True" />       </ClientSettings>   <MasterTableView DataKeyNames="PK" GridLines="None" Width="100%" CommandItemDisplay="Top">     <Columns>       <telerik:GridButtonColumn CommandName="Delete" Text="Delete" UniqueName="Delete">       </telerik:GridButtonColumn>       <telerik:GridBoundColumn DataField="PK" HeaderText="PK" UniqueName="PK"         ReadOnly="True">       </telerik:GridBoundColumn>       <telerik:GridBoundColumn DataField="Date" HeaderText="Date" UniqueName="Date">       </telerik:GridBoundColumn>       <telerik:GridBoundColumn DataField="Fuel" HeaderText="Fuel" UniqueName="Fuel">       </telerik:GridBoundColumn>       <telerik:GridBoundColumn DataField="Gross" HeaderText="Gross" UniqueName="Gross">       </telerik:GridBoundColumn>       <telerik:GridBoundColumn DataField="Invoice" HeaderText="Invoice" UniqueName="Invoice">       </telerik:GridBoundColumn>       <telerik:GridBoundColumn DataField="Plane" HeaderText="Aircraft" UniqueName="Plane">       </telerik:GridBoundColumn>       <telerik:GridBoundColumn DataField="Inventory" HeaderText="Inventory" UniqueName="Inventory">       </telerik:GridBoundColumn>       <telerik:GridEditCommandColumn>       </telerik:GridEditCommandColumn>     </Columns>     <EditFormSettings ColumnNumber="2" CaptionFormatString="Edit details for Fuel for PK with ID {0}"       CaptionDataField="PK">       <FormTableItemStyle Wrap="False"></FormTableItemStyle>       <FormCaptionStyle CssClass="EditFormHeader"></FormCaptionStyle>       <FormMainTableStyle CellSpacing="0" CellPadding="3" Width="100%" />       <FormTableStyle GridLines="Horizontal" CellSpacing="0" CellPadding="2" CssClass="module"         Height="110px" Width="100%" />       <FormTableAlternatingItemStyle Wrap="False"></FormTableAlternatingItemStyle>       <FormStyle Width="100%" BackColor="#EEF2EA"></FormStyle>       <EditColumn UpdateText="Update record" UniqueName="EditCommandColumn1" CancelText="Cancel edit">       </EditColumn>       <FormTableButtonRowStyle HorizontalAlign="Right" CssClass="EditFormButtonRow"></FormTableButtonRowStyle>     </EditFormSettings>     <ExpandCollapseColumn Visible="False">       <HeaderStyle Width="19px"></HeaderStyle>     </ExpandCollapseColumn> <CommandItemSettings ExportToPdfText="Export to PDF"></CommandItemSettings>     <RowIndicatorColumn Visible="False">       <HeaderStyle Width="20px" />     </RowIndicatorColumn>   </MasterTableView> <FilterMenu EnableImageSprites="False"></FilterMenu> <HeaderContextMenu CssClass="GridContextMenu GridContextMenu_Web20"></HeaderContextMenu> </telerik:RadGrid>     %>           </form> </body> </html>

Telerik Trainer

asked on 14 May 2013

1 answer

151 views

asp.net ajax vs Kendo

What is the benefit of moving to Kendo from say asp.net ajax (non-mvc). It seems the Ajax controls now have HTML5 charting elements and the other existing ajax controls provide "touch enabled" capabilities for mobile devices with the .js resource files. So what then is the benefit other than SOE and lighter weight controls as two big reasons (neither of which a big concern to my product)?

Any glaring and big reasons one would make the switch?

The only anwser I've found was from this thread and not sure if that's pretty much it and it truly stands still:
http://www.telerik.com/community/forums/aspnet-ajax/general-discussions/asp-net-ajax-versus-kendoui-clarification.aspx

"This basically should be an architecture decision based on the target users of your application and the goals of it. If the idea for everything working on the client fits your needs, you can try Kendo. If you still prefer the server-side approach, you should continue with ASP.NET AJAX components. "

Miscellaneous

answered on 03 May 2013

8 answers

334 views

RadControls for ASP.NET AJAX Q1 2008 is now available for download!

It is our pleasure to announce the immediate availability of RadControls for ASP.NET AJAX Q1 2008.

Check out the list of What's New as well as the full Release Notes

Happy Coding!
Telerik Team.

Announcements

answered on 24 Apr 2013

1 answer

80 views

Suggestions for JustTest

I use JustTest extensively and there are a few things that could make it that little bit better. Here are my suggestions:

Introduction of an "auto" mode, similar to the NUnit GUI test runner. This would detect a change in one of the assemblies under test and re-run the last test run. Even better would be an auto mode similar to NCrunch where the tests are executed when the code changes without the need to manually rebuild.
In addition to "Repeat Last Test Run", an option to re-run only the failed tests from the last test run would be good.
It would also be good if you had the option to remember the filter. At the moment I can click on the red X to show only failing tests but if I re-run the tests I have to filter again. This is annoying when running tests using the keyboard shortcuts and having to click the button (which I have on a different screen to the actual code).
Similarly, it would be good if it was possible to remember the state of the tree when test results are grouped, instead of it expanding every time you run the tests.
Is it possible to have a button to clear the cached list of tests? This would stop the problem of tests that no longer exist still appearing in the list until you delete the mefcache folder.

Forum suggestions

answered on 23 Apr 2013

5 answers

224 views

Sitefinity 3.7 bug on IE 10

Hi We are using sitefinity 3.7 for two of our applications, found a serious bug when open the site on IE 10, when we go to https://www.medicalhomebuilder.org/sitefinity ( https://www.medicalhomebuilder.org is our domain name) and enter username and pwd, we got a server error: Invalid value for 'encryptedTicket' parameter, it happens on our other site as well.

We can't find the forum for sitefinity on your site now.
Can you tell us how to fix it or tell us where should I post this question.
Thanks,

Let's talk about telerik (the good and the bad)

answered on 19 Apr 2013

1 answer

85 views

Rad combo box with load on demand data is not populating in list

hi,

i am using a rad combo box and loading data with on load demand feature. everything is working fine but the problem is when i focus on rad combo box on page load and when i click on down arrow from keyboard data is not loading and list is showing empty but data is filtering when i enter some text. requesting to provide the solution. if explanation is not clear i will explain in detail

Telerik Trainer

answered on 19 Apr 2013

0 answers

82 views

Telerik & Office integration?

Hi,

is there any idea to build a office integration with telerik tools like "http://www.add-in-express.com/" do?

I'm looking how to add a custom context-menu item in the inbox?!

Thanks best Regards
Rene

Forum suggestions

asked on 08 Apr 2013