Questions on UI for ASP.NET AJAX Forum

1 answer

103 views

Exporting Grouped Grid & Grid With Detail Tables

Requirements
Telerik Product and Version	RadGrid 2016.3.914
Supported Browsers and Platforms	IE 11
Components/Widgets used (JS frameworks, etc.)

PROJECT DESCRIPTION
I'm working on Exporting a Grouped RadGrid, but I'm only getting the top level rows. I've followed the examples I found here but must be doing something else wrong.

My grid is defined as follows:

<MasterTableView>

<SortExpressions>

<telerik:GridSortExpression FieldName="FULLNAME" SortOrder="Ascending" />

</SortExpressions>

<NoRecordsTemplate>

<asp:Label ID="Label1" Text="No Records Found" runat="server" />

</NoRecordsTemplate>

<Columns>

<telerik:GridTemplateColumn UniqueName="FULLNAME" ShowFilterIcon="false" DataField="FULLNAME" SortExpression="FULLNAME" HeaderText="Name" CurrentFilterFunction="Contains" AutoPostBackOnFilter="true">

<ItemTemplate>

<asp:LinkButton ID="lbUserName" runat="server" CommandArgument='<%# Eval("USERID") %>'

Text='<%# Eval("FULLNAME") %>' OnClick="lbUserName_Click" />

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridBoundColumn UniqueName="COMPANY" HeaderText="CO" DataField="COMPANY" ShowFilterIcon="false" CurrentFilterFunction="Contains" AutoPostBackOnFilter="true" DataType="System.String" />

<telerik:GridBoundColumn UniqueName="PLATOON" HeaderText="PLT" DataField="PLATOON" ShowFilterIcon="false" CurrentFilterFunction="Contains" AutoPostBackOnFilter="true" DataType="System.String" />

<telerik:GridBoundColumn UniqueName="SQUADRON" HeaderText="SQD" DataField="SQUADRON" ShowFilterIcon="false" CurrentFilterFunction="Contains" AutoPostBackOnFilter="true" DataType="System.String" />

<telerik:GridBoundColumn UniqueName="TOTALCOUNT" HeaderText="Soldiers" DataField="TOTALCOUNT" ShowFilterIcon="false" CurrentFilterFunction="EqualTo" AutoPostBackOnFilter="true" DataType="System.Int32" Aggregate="Sum" />

</Columns>

<GroupByExpressions>

<telerik:GridGroupByExpression>

<GroupByFields>

<telerik:GridGroupByField FieldName="FULLNAME" HeaderText=" " />

</GroupByFields>

<SelectFields>

<telerik:GridGroupByField FieldName="FULLNAME" HeaderText=" " HeaderValueSeparator=" " />

<telerik:GridGroupByField FieldName="TOTALCOUNT" HeaderText=" " HeaderValueSeparator="Soldiers: " Aggregate="Sum" />

</SelectFields>

</telerik:GridGroupByExpression>

</GroupByExpressions>

</MasterTableView>

</telerik:RadGrid>

My code in the ItemCommand is:

grid.MasterTableView.HierarchyDefaultExpanded = true;

grid.MasterTableView.GroupsDefaultExpanded = true;

grid.MasterTableView.ExportToExcel();

I'm having the same problem with a grid with DetialTables. the code for that is as follows:

<MasterTableView

DataKeyNames="COMPANYID" >

<DetailTables>

<telerik:GridTableView DataKeyNames="PLATOONID" Name="PLATOONVIEW" runat="server" AllowNaturalSort="false" AllowMultiColumnSorting="false" ShowHeader="false">

<DetailTables>

<telerik:GridTableView DataKeyNames="SQUADRONID" Name="SQUADRONVIEW" runat="server" AllowNaturalSort="false" AllowMultiColumnSorting="false" ShowHeader="false">

<SortExpressions>

<telerik:GridSortExpression FieldName="SQUADRON" SortOrder="Ascending" />

</SortExpressions>

<Columns>

<telerik:GridTemplateColumn UniqueName="SQUADRON" AllowFiltering="false" DataField="SQUADRON" SortExpression="SQUADRON" CurrentFilterFunction="Contains" AutoPostBackOnFilter="true">

<ItemTemplate>

<asp:LinkButton ID="lbSquadName" runat="server" CommandName="VIEWSQUADRON" CommandArgument='<%# Eval("SQUADRONNAME") %>' Text='<%# Eval("SQUADRON") %>' />

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridBoundColumn UniqueName="COMPANYNAME" DataField="COMPANYNAME" Display="false" />

<telerik:GridBoundColumn UniqueName="PLATOON" DataField="PLATOON" Display="false" />

<telerik:GridBoundColumn UniqueName="TOTALSQUADCOUNT" HeaderText="Soldiers" DataField="TOTALSQUADCOUNT" ShowFilterIcon="false" AllowFiltering="false" DataType="System.Int32"/>

</Columns>

</telerik:GridTableView>

</DetailTables>

<SortExpressions>

<telerik:GridSortExpression FieldName="PLATOON" SortOrder="Ascending" />

</SortExpressions>

<Columns>

<telerik:GridTemplateColumn UniqueName="PLATOON" AllowFiltering="false" DataField="PLATOON" SortExpression="PLATOON" HeaderText="PLT Name" CurrentFilterFunction="Contains" AutoPostBackOnFilter="true">

<ItemTemplate>

<asp:LinkButton ID="lbPlatoonName" runat="server" CommandName="VIEWPLATOON" CommandArgument='<%# Eval("PLATOONNAME") %>' Text='<%# Eval("PLATOON") %>'/>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridBoundColumn UniqueName="COMPANYNAME" DataField="COMPANYNAME" Display="false" />

<telerik:GridBoundColumn UniqueName="PLATOONID" DataField="PLATOONID" ShowFilterIcon="false" AllowFiltering="false" Display="false" />

<telerik:GridBoundColumn UniqueName="TOTALPLATOONCOUNT" HeaderText="Soldiers" DataField="TOTALPLATOONCOUNT" ShowFilterIcon="false" AllowFiltering="false" DataType="System.Int32"/>

</Columns>

</telerik:GridTableView>

</DetailTables>

<CommandItemSettings ShowExportToPdfButton="false" ShowAddNewRecordButton="false" ShowRefreshButton="false" />

<SortExpressions>

<telerik:GridSortExpression FieldName="COMPANYNAME" SortOrder="Ascending" />

</SortExpressions>

<NoRecordsTemplate>

<asp:Label ID="Label1" Text="No Records Found" runat="server" />

</NoRecordsTemplate>

<Columns>

<telerik:GridTemplateColumn UniqueName="COMPANYNAME" AllowFiltering="false" DataField="COMPANYNAME" SortExpression="COMPANYNAME" HeaderText="CO Name">

<ItemTemplate>

<asp:LinkButton ID="lbCompanyName" runat="server" CommandName="VIEWCOMPANY" CommandArgument='<%# Eval("COMPANYNAME") %>' Text='<%# Eval("COMPANYNAME") %>' />

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridBoundColumn UniqueName="COMPANYID" DataField="COMPANYID" ShowFilterIcon="false" AllowFiltering="false" Display="false" />

<telerik:GridBoundColumn UniqueName="TOTALCOMPANYCOUNT" HeaderText="Soldiers" DataField="TOTALCOMPANYCOUNT" ShowFilterIcon="false" AllowFiltering="false" DataType="System.Int32"/>

</Columns>

</MasterTableView>

Any help would be appreciated.

Grid

answered on 03 Oct 2016

3 answers

266 views

Narrow range not respected after upgrading from 2015.2.826 to 2016.3.914.45

I have a box and whisker plot (boxplotseries)

I have a server version and a local version of the same project.

The only difference between the projects is that I upgraded my local project from 2015.2 to 2016.3.914 this morning.

I have NarrowRange="true" set both in the front side and in the code behind for this graph. 2015.2 shows a non-zero based chart in production, and local shows zero based regardless of range.

Is there a different way to define narrowrange in the latest release, or is this a bug?

I have reverted back to 2015.2 via the VS/Telerik upgrade wizard and have resolved my issue for now.

<telerik:RadHtmlChart runat="server" ID="rcBP" Width="250px" Height="300px">

<Legend>

<Appearance Visible="True" BackgroundColor="Yellow"></Appearance>

</Legend>

<PlotArea>

<XAxis></XAxis>

<Series >

<telerik:BoxPlotSeries>

<TooltipsAppearance Color="White" BackgroundColor="#4f99d2" >

<ClientTemplate >

Avg: #=kendo.format(\'{0:N2}\',dataItem.Avg)# <br />

P10: #=kendo.format(\'{0:N0}\',dataItem.D10)# <br />

P25: #=kendo.format(\'{0:N0}\',dataItem.D25)# <br />

P50: #=kendo.format(\'{0:N0}\',dataItem.P50)# <br />

P75: #=kendo.format(\'{0:N2}\',dataItem.P75)# <br />

P90: #=kendo.format(\'{0:N2}\',dataItem.P90)#

</ClientTemplate>

</TooltipsAppearance>

<Appearance FillStyle-BackgroundColor="#4f99d2" ></Appearance>

</telerik:BoxPlotSeries>

</Series>

<XAxis Visible="False" >

<Items >

<telerik:AxisItem LabelText="" />

</Items>

<MajorGridLines Visible="False" />

<MinorGridLines Visible="False" />

</XAxis>

<YAxis MinorTickType="None" MajorTickType="None" NarrowRange="true" >

<MinorGridLines Visible="False" />

<MajorGridLines Visible="False" />

<LabelsAppearance DataFormatString="{0:C2}">

</LabelsAppearance>

</YAxis>

</PlotArea>

</telerik:RadHtmlChart>

Chart (HTML5)

answered on 03 Oct 2016

6 answers

452 views

selecting multiple item in radcombobox without checkbox option

Hello experts..

I have a scenario in my application where end users can send mail to multiple users with seperator ' ; ', they can select from combo items(contact name) or they can enter a new contact's email id. when they enter mail id which is not in the combo list item, i shoud popup the add contact modal popup and once they add it, i will bind the added user and they can select it from combo. so when user sends the mail, i need to get selected contact's contact id and send the mail to those id's

I was able to achieve the above functionality with few issues,
they are
1. when user type a text 'Ra' and combo lists the 'Raja', if user uses keyboard and presses END button and ' ; ', my code assumes it as some text entered other than item frm combo, if user presses 'Ra' and user selects the Raja using mouse and presses ';' means my code works fine.
2. when users enters mail id alone and not entering ';' means, i cant prompt user to add contact.
3. Im storing the contact id in hidden field and when i click send button I'm retrieving it.

I used radcombo, binding its data from web method as follows

<telerik:RadComboBox ID="rdCombotxtToUser" runat="server" Width="397px" Height="140px" Enabled="false"

EmptyMessage="Please enter your contacts (e.g John Doe;Jane Doe)" AllowCustomText="true" AutoCompleteSeparator=";" EnableAutomaticLoadOnDemand="true" EnableItemCaching="true" MarkFirstMatch="true" OnClientKeyPressing="OnClientKeyPressing">

</telerik:RadComboBox>

When users enters ; im firing following below javascript

function OnClientKeyPressing(sender, e)

{

var strSelecteditem

if (e._domEvent.keyCode == "186")

{

var combo = $find("<%= rdCombotxtToUser.ClientID %>");

strSelecteditem = combo._selectedItem;

if (strSelecteditem == null) {

var mdlPopup = $find("mdladdContactPopupBId");

document.getElementById(

"<%=txtName.ClientID %>").value = combo._filterText;

mdlPopup.show();

}

}

Can anyone suggest me any other method or solution to prompt user only when mail id or items not in combo is entered.

ComboBox

answered on 03 Oct 2016

1 answer

85 views

Reference a different attribute

I have a XML file for users to click a link to display a help pdf. The XML is using Node Text = Course and I can use Text to display the PDF in an iframe. The XML has attributes of PDFFile and Permissions, also.

A part of the xml file:

In the C# code behind, I am using Telerik.Web.UI.RadTreeNodeEventArgs e

string PDFName = e.Node.Text

to display the pdf file

I would like to use PDFName to display the PDF file and remove the link if the person is not an Administrator or Installer. I have tried selectedName.Attribute("PDFName"), but it is giving me an error. What attribute should I use?

Thanks,

Jeff

TreeView

answered on 03 Oct 2016

1 answer

105 views

Edit treelist view

Hi

Is it possible to edit treelist view only for a few row ??

After searching, i did not find a way to view my gantt row...

I would like to edit some value of row from one column and represented them by a different color.

Thanks

Salvatore

Gantt

answered on 03 Oct 2016

9 answers

222 views

RadPivotGrid no data after update

I have a problem where after I dragged Branch ID into the Row Area and update, the pivotgrid will load for some time and show empty result. Results will show if Branch ID is not dragged into row area.

I have tried the same scenario in Visual Studio 2008 SSAS and it successfully shows the result.

Thanks.

PivotGrid

answered on 03 Oct 2016

45 answers

1.5K+ views

RadAjaxPanel cauing full postback 1st time

I'm noticing that the RadAjaxPanel control is causing a full postback when one of its child controls is fired (like a checkbox with autopostback=true). This only happens the 1st time and all subsequent postbacks happen via AJAX.

Any idea on why this may be happening?

Also, when more than 1 RadAjaxPanels are on the same page, it seems that all the other update panels work fine on their 1st trigger, it's just the first request from any of them that seems to be a problem.

These are inside a formview in a user control, if that matters.

Ajax

answered on 02 Oct 2016

2 answers

76 views

RadMenu adaptive behavior: When RenderMode is Auto, can it use "Classic" for desktop instead of "Lightweight"?

Hi,

I am playing with Radmenu on multiple devices, including desktop and mobile devices. I realize i can set "RenderMode" to "Auto" and it will adapt to devices automatically.

However, one issue i noticed is that once it is set to "Auto", it renders desktop menu in "Lightweight" mode. According to my research, it is the default behavior: if there is lightweight mode available, use lightweight mode for desktop and using Mobile mode for mobile devices. I also realized the lightweight mode has different HTML layout than the Classic one. That cause some styling issue cross my web application. I would prefer to show "Classic" on desktop, and "Mobile" for mobile devices. Is there any setting/configuration that can help with that?

In addition, is there any specific CSS files for lightweight mode that I need to download and add to my web application (because this is my first time play with lightweight render mode)?

Thanks

Kan

Menu

answered on 30 Sep 2016

6 answers

251 views

RadWindow could not close on download button.

Hi,

I have open a RadWindow on a button click event and then in that window i have added a download button for downloading the file.
But as the download pop up the radwindow stop behaving. Right now i want that RadWindow should get close automatically when the download gets completed but currently it remains open. So please provide me solution for this.

Thanks

General Discussions