Hello I have two nested radlistbox with itemtemplates
the problem is when I select an item of sub Radlistbox how I can access the value of Parent item
Please Help Or if anybody has a better way please tell me
this my Asp.net code
<telerik:RadListBox ID="Chk_ProjectList" CssClass="Chk_Filters" runat="server" RenderMode="Classic" AutoPostBack="true" OnItemCheck="Chk_ProjectList_ItemCheck"
Width="100%" RepeatDirection="Horizontal" Font-Size="13px"
DataValueField="ProjectId" >
<%--OnItemCheck="Chk_ProjectList_ItemCheck" AutoPostBack="true" OnClientItemChecking="Chk_ProjectList_OnClientItemChecking"--%>
<ItemTemplate>
<table style="width: 100%; border: none;">
<tr style="width: 100%;" runat="server" id="tds">
<td style="width: 18%; display: inline;">
<%--<input class="rlbCheck" type="checkbox"/>--%>
<div class="PrjClassTitle">
<%# DataBinder.Eval(Container.DataItem, "ProjectName") %> ( <%# DataBinder.Eval(Container.DataItem, "Count") %> )
</div>
</td>
</tr>
<tr style="width: 100%;">
<td id="Td1" style="width: 18%; display: inline;" runat="server">
<div runat="server" id="ActionTypeStatus" class="GPart">
<%--style="display: none"--%>
<%--<div class="divFilterTitle">وضعیت واگن </div>--%>
<telerik:RadListBox ID="Chk_ActionTypeStatusList" runat="server" RenderMode="Lightweight" AutoPostBack="true"
Width="100%" RepeatDirection="Horizontal" RepeatColumns="1" Font-Size="13px"
DataValueField="ActionTypeId"><%--OnSelectedIndexChanged="Chk_ActionTypeStatusList_SelectedIndexChanged" OnClientSelectedIndexChanging="Chk_ActionTypeStatusList_SelectedIndexChanging" --%>
<ItemTemplate>
<table style="width: 100%;">
<tr style="width: 100%;">
<td style="width: 18%; display: inline;">
<%# DataBinder.Eval(Container.DataItem, "ActionTypeName") %> ( <%# DataBinder.Eval(Container.DataItem, "Count") %> )
</td>
</tr>
</table>
</ItemTemplate>
<EmptyMessageTemplate>
NO RECORDES
</EmptyMessageTemplate>
</telerik:RadListBox>
<%--<div class="GPartLn"></div>--%>
</div>
</td>
</tr>
</table>
</ItemTemplate>
<EmptyMessageTemplate>
NO RECORDES
</EmptyMessageTemplate>
</telerik:RadListBox>
For some reason, on both iOS Safari and Android Chrome, when I or a user scrolls vertically in a listbox, it is "selecting" the item under their finger when they lift it off the screen and have finished scrolling.
I would normally expect a user to be able to scroll vertically in the list and then "tap" an item to select it.
I've seen older threads claiming this was fixed in ~2013 builds, but I'm on a 2016 build and I'm still experiencing the issue.
Also on a side note, scrolling down in listboxes on Android Chrome also seems to occasionally trigger chrome's "pull-to-refresh" functionality, which I'm trying to avoid.
The following code works and updates the literal control perfectly. When I add the ajax manager, it doesn't update the control at all . Its still Showing Chart...
<
telerik:RadAjaxManager
ID
=
"RadAjaxManager1"
runat
=
"server"
>
<
AjaxSettings
>
<
telerik:AjaxSetting
AjaxControlID
=
"ddlFromDay"
>
<
UpdatedControls
>
<
telerik:AjaxUpdatedControl
ControlID
=
"litTargetSales"
LoadingPanelID
=
"RadAjaxLoadingPanel1"
></
telerik:AjaxUpdatedControl
>
</
UpdatedControls
>
</
telerik:AjaxSetting
>
</
AjaxSettings
>
</
telerik:RadAjaxManager
>
<
telerik:RadAjaxLoadingPanel
ID
=
"RadAjaxLoadingPanel1"
runat
=
"server"
>
</
telerik:RadAjaxLoadingPanel
>
<
telerik:RadFormDecorator
RenderMode
=
"Lightweight"
ID
=
"FormDecorator1"
runat
=
"server"
DecoratedControls
=
"Buttons"
></
telerik:RadFormDecorator
>
<
fieldset
>
<
telerik:RadPageLayout
ID
=
"rplTargetAcheived"
runat
=
"server"
GridType
=
"Fluid"
>
<
Rows
>
<
telerik:LayoutRow
>
<
Columns
>
<
telerik:LayoutColumn
Span
=
"6"
CssClass
=
"tdmakeright"
>
<
telerik:RadLabel
ID
=
"lblFromDay"
runat
=
"server"
Text
=
"From Day"
Skin
=
"MetroTouch"
RenderMode
=
"Lightweight"
></
telerik:RadLabel
>
<
telerik:RadComboBox
ID
=
"ddlFromDay"
runat
=
"server"
Filter
=
"StartsWith"
Skin
=
"MetroTouch"
RenderMode
=
"Lightweight"
Width
=
"59px"
AutoPostBack
=
"true"
OnSelectedIndexChanged
=
"ddlFromDay_SelectedIndexChanged"
></
telerik:RadComboBox
>
<
telerik:RadLabel
ID
=
"lblToDay"
runat
=
"server"
Text
=
"To Day"
Skin
=
"MetroTouch"
RenderMode
=
"Lightweight"
></
telerik:RadLabel
>
<
telerik:RadComboBox
ID
=
"ddlToDay"
runat
=
"server"
Filter
=
"StartsWith"
Skin
=
"MetroTouch"
RenderMode
=
"Lightweight"
Width
=
"59px"
AutoPostBack
=
"true"
OnSelectedIndexChanged
=
"ddlToDay_SelectedIndexChanged"
></
telerik:RadComboBox
>
</
telerik:LayoutColumn
>
<
telerik:LayoutColumn
Span
=
"6"
CssClass
=
"tdmakeleft"
>
<
telerik:RadLabel
ID
=
"lblof"
runat
=
"server"
Text
=
"of"
Skin
=
"MetroTouch"
RenderMode
=
"Lightweight"
></
telerik:RadLabel
>
<
telerik:RadComboBox
ID
=
"ddlMonth"
runat
=
"server"
Filter
=
"StartsWith"
Skin
=
"MetroTouch"
RenderMode
=
"Lightweight"
Width
=
"100px"
AutoPostBack
=
"true"
OnSelectedIndexChanged
=
"ddlMonth_SelectedIndexChanged"
></
telerik:RadComboBox
>
<
telerik:RadComboBox
ID
=
"ddlYear"
runat
=
"server"
Filter
=
"StartsWith"
Skin
=
"MetroTouch"
RenderMode
=
"Lightweight"
Width
=
"100px"
AutoPostBack
=
"true"
OnSelectedIndexChanged
=
"ddlYear_SelectedIndexChanged"
></
telerik:RadComboBox
>
</
telerik:LayoutColumn
>
</
Columns
>
</
telerik:LayoutRow
>
</
Rows
>
<
Rows
>
<
telerik:LayoutRow
>
<
Columns
>
<
telerik:LayoutColumn
Span
=
"12"
CssClass
=
"tdmakeright"
>
<
asp:Literal
ID
=
"litTargetSales"
runat
=
"server"
></
asp:Literal
>
</
telerik:LayoutColumn
>
</
Columns
>
</
telerik:LayoutRow
>
</
Rows
>
</
telerik:RadPageLayout
>
</
fieldset
>
Hi, I have a site running on an unsupported version of windows. I is using older RadControls (i.e. RadAjax.Net2.dll version 1.7.1.0) and functions well, but I need to move it to a supported version of windows server. Of course any older VS project or installation media or documentation is missing. I've moved the root directory to the new server and configured IIS as best I can. I've created a new web project in VS2015The RadControls are not functioning.
Can anyone point me to documentation/resources to troubleshoot the issue.
Thanks
I have a RadAsyncUpload button on my form. When it displays the right border of the Select button is cut off. What am I doing wrong? You can see the table borders so I know I have plenty of room.
<td>
<telerik:RadAsyncUpload RenderMode="Lightweight" ID="productImportFile" runat="server" Skin="WebBlue" MaxFileInputsCount="1" Width="221px">
<FileFilters>
<telerik:FileFilter Description="Text(txt)" Extensions="txt" />
</FileFilters>
</telerik:RadAsyncUpload>
</td>
Hello,
I was wondering if it was possible to group on the same field twice. For instance:
<
DataGroups
>
<
telerik:ListViewDataGroup
GroupField
=
"GroupNumber"
DataGroupPlaceholderID
=
"GroupPlaceHolder1"
SortOrder
=
"Ascending"
>
<
DataGroupTemplate
>
<
div
class
=
"row-group-heading"
><%#(Container as RadListViewDataGroupItem).DataGroupKey %>
<
asp:PlaceHolder
runat
=
"server"
ID
=
"GroupPlaceHolder2"
></
asp:PlaceHolder
>
</
DataGroupTemplate
>
</
telerik:ListViewDataGroup
>
<
telerik:ListViewDataGroup
GroupField
=
"GroupNumber"
DataGroupPlaceholderID
=
"GroupPlaceHolder2"
SortOrder
=
"Ascending"
>
<
DataGroupTemplate
>
<
div
class
=
"row-group-heading"
><%#(Container as RadListViewDataGroupItem).DataGroupKey %></
div
>
<
asp:PlaceHolder
runat
=
"server"
ID
=
"ItemPlaceHolder"
></
asp:PlaceHolder
>
</
DataGroupTemplate
>
</
telerik:ListViewDataGroup
>
</
DataGroups
>
If not is there a work around?
I have a class derived from GridTextColumnEditor. It overrides the function AddControlsToContainer. I want the added controls (textboxes) to do a postback. When I have a textbox on my page and set AutoPostBack to true, the resulting html looks like this:
<
input
name
=
"ctl00$_mCPH$AssetClassSettings1$p1c4r6"
id
=
"ctl00__mCPH_AssetClassSettings1_p1c4r6"
style
=
"width: 30px; text-align: right;"
onkeypress
=
"if (WebForm_TextBoxKeyHandler(event) == false) return false;"
onfocus
=
"FormatNumberAsDecimal(this)"
onblur
=
"FormatDecimalAsNumber(this)"
onchange
=
"javascript:setTimeout('__doPostBack(\'ctl00$_mCPH$AssetClassSettings1$p1c4r6\',\'\')', 0)"
type
=
"text"
value
=
"0"
precision
=
"0"
originalamount
=
"0"
nomatch
=
"0"
group
=
"1"
maxamount
=
"100"
minamount
=
"0"
negativecolor
=
"Red"
>
But when added via the GridTextColumn Editor, the html is:
<
input
name
=
"ctl00$_mCPH$BG1$BudgetGrid$ctl01$ctl08$ctl01"
style
=
"width:60px;text-align:Right;"
onkeypress
=
"if (WebForm_TextBoxKeyHandler(event) == false) return false;"
onfocus
=
"FormatNumberAsDecimal(this)"
onblur
=
"FormatDecimalAsNumber(this)"
onchange
=
"javascript:setTimeout('RadGridNamespace.AsyncRequest(\'ctl00$_mCPH$BG1$BudgetGrid$ctl01$ctl08$ctl01\',\'\', 'ctl00__mCPH_BG1_BudgetGrid', event)', 0)"
type
=
"text"
value
=
"0"
precision
=
"2"
originalamount
=
"0"
nomatch
=
"0"
group
=
"1"
maxamount
=
"99999"
minamount
=
"-100000000"
negativecolor
=
"Red"
>
This "RadGridNamespace.AsyncRequest" is not a post back and I don't know what it is or why it would be added rather than the doPostBack. How do I make this work?
I'm going to admit that I am a rank beginner at Bootstrap. About all I have experience with is that class="col-md-##" setup.
My question is this: If I've set the Skin of a Telerik control to Bootstrap, does that eliminate the need to put it within a div that has Bootstrap attributes?
In other words I have a batch of RadTextBoxes in a row, each in their own col-md-## div, and all those within the main class="col-md-12" div. Are the div attributes necessary? (The box labels are overlapping each other, depending on the size of the screen. Not apparently responsive.)
Please feel free to point to any relevant documentation. So far I haven't found anything that clearly explains this.
Hi, I have a page with 3 nested radgrids. The problem is that the page takes 10 minutes (!!!) to load even if I set HierarchyLoadMode="ServerOnDemand" in every levels. It looks like grid loads every sub-details on page load, also because if I'll set HierarchyLoadMode="Client" the time to load is pretty the same.
What I'm expecting is that on pageload radgrid loads only the first level and when I click on a row to expand it the page reloads with only that row expanded (and calculated) and so on...
Can you help me?
<%@ Page Title="Situazione" Language="VB" AutoEventWireup="false" CodeFile="MostraSituazioneTarget.aspx.vb" Inherits="MostraSituazioneTarget" MasterPageFile="~/Site.master" %>
<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>
<
asp:Content
ID
=
"Content1"
ContentPlaceHolderID
=
"head"
runat
=
"server"
>
<
h2
>Situazione target</
h2
>
</
asp:Content
>
<
asp:Content
ID
=
"Content2"
ContentPlaceHolderID
=
"MainContent"
runat
=
"server"
>
<
telerik:RadScriptBlock
runat
=
"server"
>
<
script
type
=
"text/javascript"
>
window.onresize = ResizeGrid;
Sys.Application.add_load(ResizeGrid);
function ResizeGrid() {
var radGrid2 = $find('<%= radGridPrenotazioni.ClientID %>'); //outer RadGrid
if ($(window).height() > 550 & !detectmob()) {
radGrid2.get_element().style.height = $(window).height() - 220 + "px";
radGrid2.repaint();
}
}
function detectmob() {
if (navigator.userAgent.match(/Android/i)
|| navigator.userAgent.match(/webOS/i)
|| navigator.userAgent.match(/iPhone/i)
|| navigator.userAgent.match(/iPad/i)
|| navigator.userAgent.match(/iPod/i)
|| navigator.userAgent.match(/BlackBerry/i)
|| navigator.userAgent.match(/Windows Phone/i)
) {
return true;
}
else {
return false;
}
}
</
script
>
</
telerik:RadScriptBlock
>
<
telerik:RadWindowManager
ID
=
"RadWindowManager1"
runat
=
"server"
Skin
=
"Bootstrap"
>
</
telerik:RadWindowManager
>
<
telerik:RadGrid
runat
=
"server"
ID
=
"radGridPrenotazioni"
Culture
=
"it-IT"
EnableViewState
=
"false"
DataSourceID
=
"SqlDataSource1"
GroupPanelPosition
=
"Top"
CellSpacing
=
"-1"
AllowSorting
=
"True"
AutoGenerateColumns
=
"False"
ShowGroupPanel
=
"false"
>
<
ClientSettings
AllowColumnsReorder
=
"True"
ReorderColumnsOnClient
=
"True"
AllowDragToGroup
=
"True"
Scrolling-UseStaticHeaders
=
"true"
Scrolling-AllowScroll
=
"true"
></
ClientSettings
>
<
MasterTableView
DataSourceID
=
"SqlDataSource1"
ShowGroupFooter
=
"false"
GroupsDefaultExpanded
=
"false"
HierarchyDefaultExpanded
=
"false"
EnableHierarchyExpandAll
=
"false"
EnableGroupsExpandAll
=
"true"
HierarchyLoadMode
=
"ServerOnDemand"
>
<
Columns
>
<
telerik:GridBoundColumn
DataField
=
"Salesperson"
HeaderText
=
"Salesperson"
Visible
=
"false"
SortExpression
=
"Salesperson"
UniqueName
=
"Salesperson"
FilterControlAltText
=
"Filter Salesperson column"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Name"
HeaderText
=
"Name"
SortExpression
=
"Name"
UniqueName
=
"Name"
FilterControlAltText
=
"Filter Name column"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"QtaPZ_Delta"
HeaderText
=
"QtaPZ_Delta"
HeaderStyle-Width
=
"200"
SortExpression
=
"QtaPZ_Delta"
UniqueName
=
"QtaPZ_Delta"
FilterControlAltText
=
"Filter QtaPZ_Delta column"
DataType
=
"System.Double"
ReadOnly
=
"True"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Qta_Delta"
HeaderText
=
"Qta_Delta"
SortExpression
=
"Qta_Delta"
HeaderStyle-Width
=
"200"
UniqueName
=
"Qta_Delta"
FilterControlAltText
=
"Filter Qta_Delta column"
DataType
=
"System.Double"
ReadOnly
=
"True"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Imponibile_Delta"
HeaderText
=
"Imponibile_Delta"
HeaderStyle-Width
=
"200"
SortExpression
=
"Imponibile_Delta"
UniqueName
=
"Imponibile_Delta"
DataType
=
"System.Double"
FilterControlAltText
=
"Filter Imponibile_Delta column"
ReadOnly
=
"True"
></
telerik:GridBoundColumn
>
</
Columns
>
<
NestedViewTemplate
>
<
asp:Label
ID
=
"labelSalesperson"
runat
=
"server"
Visible
=
"false"
Text='<%# Eval("Salesperson") %>' />
<
telerik:RadGrid
runat
=
"server"
ID
=
"radGridProducer"
Culture
=
"it-IT"
GroupPanelPosition
=
"Top"
DataSourceID
=
"SqlDataSource1"
EnableViewState
=
"false"
>
<
ClientSettings
AllowColumnsReorder
=
"True"
ReorderColumnsOnClient
=
"True"
AllowDragToGroup
=
"True"
Scrolling-UseStaticHeaders
=
"true"
Scrolling-AllowScroll
=
"true"
></
ClientSettings
>
<
MasterTableView
DataKeyNames
=
"Salesperson,Producer"
DataSourceID
=
"SqlDataSource1"
AutoGenerateColumns
=
"False"
HierarchyLoadMode
=
"ServerOnDemand"
>
<
NestedViewTemplate
>
<
asp:Label
runat
=
"server"
ID
=
"labelProducer"
Visible
=
"false"
Text='<%# Eval("Producer") %>' />
<
telerik:RadGrid
runat
=
"server"
ID
=
"radGridCommodityCtg"
CellSpacing
=
"-1"
Culture
=
"it-IT"
DataSourceID
=
"SqlDataSource1"
GridLines
=
"Both"
GroupPanelPosition
=
"Top"
EnableViewState
=
"false"
>
<
MasterTableView
DataKeyNames
=
"Salesperson,Producer,CommodityCtg"
DataSourceID
=
"SqlDataSource1"
AutoGenerateColumns
=
"False"
>
<
Columns
>
<
telerik:GridBoundColumn
DataField
=
"Salesperson"
Visible
=
"false"
ReadOnly
=
"True"
HeaderText
=
"Salesperson"
SortExpression
=
"Salesperson"
UniqueName
=
"Salesperson"
FilterControlAltText
=
"Filter Salesperson column"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Producer"
Visible
=
"false"
ReadOnly
=
"True"
HeaderText
=
"Producer"
SortExpression
=
"Producer"
UniqueName
=
"Producer"
FilterControlAltText
=
"Filter Producer column"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"CommodityCtg"
ReadOnly
=
"True"
HeaderText
=
"CommodityCtg"
SortExpression
=
"CommodityCtg"
UniqueName
=
"CommodityCtg"
FilterControlAltText
=
"Filter CommodityCtg column"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"DefaultTargetQta"
HeaderText
=
"DefaultTargetQta"
SortExpression
=
"DefaultTargetQta"
UniqueName
=
"DefaultTargetQta"
DataType
=
"System.Double"
FilterControlAltText
=
"Filter DefaultTargetQta column"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"DefaultTargetImponibile"
HeaderText
=
"DefaultTargetImponibile"
SortExpression
=
"DefaultTargetImponibile"
UniqueName
=
"DefaultTargetImponibile"
DataType
=
"System.Double"
FilterControlAltText
=
"Filter DefaultTargetImponibile column"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"QtaPZ_Delta"
HeaderText
=
"QtaPZ_Delta"
HeaderStyle-Width
=
"200"
SortExpression
=
"QtaPZ_Delta"
UniqueName
=
"QtaPZ_Delta"
FilterControlAltText
=
"Filter QtaPZ_Delta column"
DataType
=
"System.Double"
ReadOnly
=
"True"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Qta_Delta"
HeaderText
=
"Qta_Delta"
SortExpression
=
"Qta_Delta"
HeaderStyle-Width
=
"200"
UniqueName
=
"Qta_Delta"
FilterControlAltText
=
"Filter Qta_Delta column"
DataType
=
"System.Double"
ReadOnly
=
"True"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Imponibile_Delta"
HeaderText
=
"Imponibile_Delta"
HeaderStyle-Width
=
"200"
SortExpression
=
"Imponibile_Delta"
UniqueName
=
"Imponibile_Delta"
DataType
=
"System.Double"
FilterControlAltText
=
"Filter Imponibile_Delta column"
ReadOnly
=
"True"
></
telerik:GridBoundColumn
>
</
Columns
>
</
MasterTableView
>
</
telerik:RadGrid
>
<
asp:SqlDataSource
runat
=
"server"
ID
=
"SqlDataSource1"
ConnectionString='<%$ ConnectionStrings:dalessioConnectionString %>'
SelectCommand="SELECT STRT_VenditePerAgenteAnnoPrec.Salesperson, STRT_VenditePerAgenteAnnoPrec.Name, (STRT_VenditePerAgenteAnnoPrec.QtaPZ / 100)
* (100 + CASE WHEN STRT_SalespersonProducerTarget.DefaultTargetQta IS NOT NULL
THEN STRT_SalespersonProducerTarget.DefaultTargetQta ELSE STRT_SalespersonProducerCtgTarget.DefaultTargetQta END) - STRT_VenditePerAgenteAnnoCor.QtaPZ AS QtaPZ_Delta,
(STRT_VenditePerAgenteAnnoPrec.Qta / 100) * (100 + CASE WHEN STRT_SalespersonProducerTarget.DefaultTargetQta IS NOT NULL
THEN STRT_SalespersonProducerTarget.DefaultTargetQta ELSE STRT_SalespersonProducerCtgTarget.DefaultTargetQta END) - STRT_VenditePerAgenteAnnoCor.Qta AS Qta_Delta,
(STRT_VenditePerAgenteAnnoPrec.Qta / 100) * (100 + CASE WHEN STRT_SalespersonProducerTarget.DefaultTargetImponibile IS NOT NULL
THEN STRT_SalespersonProducerTarget.DefaultTargetImponibile ELSE STRT_SalespersonProducerCtgTarget.DefaultTargetImponibile END) - STRT_VenditePerAgenteAnnoCor.Imponibile AS Imponibile_Delta,
STRT_VenditePerAgenteAnnoCor.Producer, STRT_VenditePerAgenteAnnoPrec.Producer AS Expr1, STRT_SalespersonProducerTarget.DefaultTargetQta, STRT_SalespersonProducerTarget.DefaultTargetImponibile,
STRT_VenditePerAgenteAnnoCor.CommodityCtg, STRT_VenditePerAgenteAnnoPrec.CommodityCtg AS Expr2, STRT_VenditePerAgenteAnnoCor.Salesperson AS Expr3
FROM STRT_VenditePerAgenteAnnoCor LEFT OUTER JOIN
STRT_SalespersonProducerCtgTarget ON STRT_VenditePerAgenteAnnoCor.Producer = STRT_SalespersonProducerCtgTarget.Producer AND
STRT_VenditePerAgenteAnnoCor.CommodityCtg = STRT_SalespersonProducerCtgTarget.CommodityCtg AND
STRT_VenditePerAgenteAnnoCor.Salesperson = STRT_SalespersonProducerCtgTarget.Salesperson RIGHT OUTER JOIN
STRT_VenditePerAgenteAnnoPrec ON STRT_VenditePerAgenteAnnoCor.Salesperson = STRT_VenditePerAgenteAnnoPrec.Salesperson AND
STRT_VenditePerAgenteAnnoCor.CommodityCtg = STRT_VenditePerAgenteAnnoPrec.CommodityCtg AND STRT_VenditePerAgenteAnnoCor.Producer = STRT_VenditePerAgenteAnnoPrec.Producer AND
STRT_SalespersonProducerCtgTarget.Salesperson = STRT_VenditePerAgenteAnnoPrec.Salesperson AND
STRT_SalespersonProducerCtgTarget.CommodityCtg = STRT_VenditePerAgenteAnnoPrec.CommodityCtg AND
STRT_SalespersonProducerCtgTarget.Producer = STRT_VenditePerAgenteAnnoPrec.Producer LEFT OUTER JOIN
STRT_SalespersonProducerTarget ON STRT_VenditePerAgenteAnnoCor.Producer = STRT_SalespersonProducerTarget.Producer AND
STRT_VenditePerAgenteAnnoCor.Salesperson = STRT_SalespersonProducerTarget.Salesperson AND STRT_VenditePerAgenteAnnoPrec.Salesperson = STRT_SalespersonProducerTarget.Salesperson AND
STRT_VenditePerAgenteAnnoPrec.Producer = STRT_SalespersonProducerTarget.Producer
WHERE ((STRT_VenditePerAgenteAnnoCor.[Producer] = @Producer OR STRT_VenditePerAgenteAnnoPrec.[Producer] = @Producer) AND (STRT_VenditePerAgenteAnnoPrec.[Salesperson] = @Salesperson OR STRT_VenditePerAgenteAnnoCor.[Salesperson] = @Salesperson))">
<
SelectParameters
>
<
asp:ControlParameter
ControlID
=
"labelSalesperson"
PropertyName
=
"Text"
Name
=
"Salesperson"
Type
=
"String"
></
asp:ControlParameter
>
<
asp:ControlParameter
ControlID
=
"labelProducer"
PropertyName
=
"Text"
Name
=
"Producer"
Type
=
"String"
></
asp:ControlParameter
>
</
SelectParameters
>
</
asp:SqlDataSource
>
</
NestedViewTemplate
>
<
Columns
>
<
telerik:GridBoundColumn
DataField
=
"Producer"
ReadOnly
=
"True"
HeaderText
=
"Producer"
SortExpression
=
"Producer"
UniqueName
=
"Producer"
FilterControlAltText
=
"Filter Producer column"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"DefaultTargetQta"
HeaderText
=
"DefaultTargetQta"
HeaderStyle-Width
=
"200"
SortExpression
=
"DefaultTargetQta"
UniqueName
=
"DefaultTargetQta"
DataType
=
"System.Double"
FilterControlAltText
=
"Filter DefaultTargetQta column"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"DefaultTargetImponibile"
HeaderText
=
"DefaultTargetImponibile"
HeaderStyle-Width
=
"200"
SortExpression
=
"DefaultTargetImponibile"
UniqueName
=
"DefaultTargetImponibile"
DataType
=
"System.Double"
FilterControlAltText
=
"Filter DefaultTargetImponibile column"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"QtaPZ_Delta"
HeaderText
=
"QtaPZ_Delta"
HeaderStyle-Width
=
"200"
SortExpression
=
"QtaPZ_Delta"
UniqueName
=
"QtaPZ_Delta"
DataType
=
"System.Double"
FilterControlAltText
=
"Filter QtaPZ_Delta column"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Qta_Delta"
HeaderText
=
"Qta_Delta"
HeaderStyle-Width
=
"200"
SortExpression
=
"Qta_Delta"
UniqueName
=
"Qta_Delta"
DataType
=
"System.Double"
FilterControlAltText
=
"Filter Qta_Delta column"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Imponibile_Delta"
HeaderText
=
"Imponibile_Delta"
HeaderStyle-Width
=
"200"
SortExpression
=
"Imponibile_Delta"
UniqueName
=
"Imponibile_Delta"
DataType
=
"System.Double"
FilterControlAltText
=
"Filter Imponibile_Delta column"
></
telerik:GridBoundColumn
>
</
Columns
>
</
MasterTableView
>
</
telerik:RadGrid
>
<
asp:SqlDataSource
runat
=
"server"
ID
=
"SqlDataSource1"
ConnectionString='<%$ ConnectionStrings:dalessioConnectionString %>'
SelectCommand="
SELECT STRT_VenditePerAgenteAnnoPrec.Salesperson, STRT_VenditePerAgenteAnnoPrec.Name, SUM((STRT_VenditePerAgenteAnnoPrec.QtaPZ / 100)
* (100 + CASE WHEN STRT_SalespersonProducerTarget.DefaultTargetQta IS NOT NULL
THEN STRT_SalespersonProducerTarget.DefaultTargetQta ELSE STRT_SalespersonProducerCtgTarget.DefaultTargetQta END) - STRT_VenditePerAgenteAnnoCor.QtaPZ) AS QtaPZ_Delta,
SUM((STRT_VenditePerAgenteAnnoPrec.Qta / 100) * (100 + CASE WHEN STRT_SalespersonProducerTarget.DefaultTargetQta IS NOT NULL
THEN STRT_SalespersonProducerTarget.DefaultTargetQta ELSE STRT_SalespersonProducerCtgTarget.DefaultTargetQta END) - STRT_VenditePerAgenteAnnoCor.Qta) AS Qta_Delta,
SUM((STRT_VenditePerAgenteAnnoPrec.Qta / 100) * (100 + CASE WHEN STRT_SalespersonProducerTarget.DefaultTargetImponibile IS NOT NULL
THEN STRT_SalespersonProducerTarget.DefaultTargetImponibile ELSE STRT_SalespersonProducerCtgTarget.DefaultTargetImponibile END) - STRT_VenditePerAgenteAnnoCor.Imponibile) AS Imponibile_Delta,
STRT_VenditePerAgenteAnnoCor.Producer, STRT_VenditePerAgenteAnnoPrec.Producer AS Expr1, STRT_SalespersonProducerTarget.DefaultTargetQta,
STRT_SalespersonProducerTarget.DefaultTargetImponibile
FROM STRT_VenditePerAgenteAnnoCor LEFT OUTER JOIN
STRT_SalespersonProducerCtgTarget ON STRT_VenditePerAgenteAnnoCor.Producer = STRT_SalespersonProducerCtgTarget.Producer AND
STRT_VenditePerAgenteAnnoCor.CommodityCtg = STRT_SalespersonProducerCtgTarget.CommodityCtg AND
STRT_VenditePerAgenteAnnoCor.Salesperson = STRT_SalespersonProducerCtgTarget.Salesperson RIGHT OUTER JOIN
STRT_VenditePerAgenteAnnoPrec ON STRT_VenditePerAgenteAnnoCor.Salesperson = STRT_VenditePerAgenteAnnoPrec.Salesperson AND
STRT_VenditePerAgenteAnnoCor.CommodityCtg = STRT_VenditePerAgenteAnnoPrec.CommodityCtg AND STRT_VenditePerAgenteAnnoCor.Producer = STRT_VenditePerAgenteAnnoPrec.Producer AND
STRT_SalespersonProducerCtgTarget.Salesperson = STRT_VenditePerAgenteAnnoPrec.Salesperson AND
STRT_SalespersonProducerCtgTarget.CommodityCtg = STRT_VenditePerAgenteAnnoPrec.CommodityCtg AND
STRT_SalespersonProducerCtgTarget.Producer = STRT_VenditePerAgenteAnnoPrec.Producer LEFT OUTER JOIN
STRT_SalespersonProducerTarget ON STRT_VenditePerAgenteAnnoCor.Producer = STRT_SalespersonProducerTarget.Producer AND
STRT_VenditePerAgenteAnnoCor.Salesperson = STRT_SalespersonProducerTarget.Salesperson AND STRT_VenditePerAgenteAnnoPrec.Salesperson = STRT_SalespersonProducerTarget.Salesperson AND
STRT_VenditePerAgenteAnnoPrec.Producer = STRT_SalespersonProducerTarget.Producer
WHERE (STRT_SalespersonProducerTarget.[Salesperson] = @Salesperson)
GROUP BY STRT_VenditePerAgenteAnnoPrec.Salesperson, STRT_VenditePerAgenteAnnoPrec.Name, STRT_VenditePerAgenteAnnoCor.Producer, STRT_VenditePerAgenteAnnoPrec.Producer,
STRT_SalespersonProducerTarget.DefaultTargetQta, STRT_SalespersonProducerTarget.DefaultTargetImponibile">
<
SelectParameters
>
<
asp:ControlParameter
ControlID
=
"labelSalesperson"
PropertyName
=
"Text"
Name
=
"Salesperson"
Type
=
"String"
></
asp:ControlParameter
>
</
SelectParameters
>
</
asp:SqlDataSource
>
</
NestedViewTemplate
>
</
MasterTableView
>
</
telerik:RadGrid
>
<
asp:SqlDataSource
runat
=
"server"
ID
=
"SqlDataSource1"
ConnectionString='<%$ ConnectionStrings:dalessioConnectionString %>'
SelectCommand="SELECT STRT_VenditePerAgenteAnnoPrec.Salesperson, STRT_VenditePerAgenteAnnoPrec.Name, SUM((STRT_VenditePerAgenteAnnoPrec.QtaPZ / 100)
* (100 + CASE WHEN STRT_SalespersonProducerTarget.DefaultTargetQta IS NOT NULL
THEN STRT_SalespersonProducerTarget.DefaultTargetQta ELSE STRT_SalespersonProducerCtgTarget.DefaultTargetQta END) - STRT_VenditePerAgenteAnnoCor.QtaPZ) AS QtaPZ_Delta,
SUM((STRT_VenditePerAgenteAnnoPrec.Qta / 100) * (100 + CASE WHEN STRT_SalespersonProducerTarget.DefaultTargetQta IS NOT NULL
THEN STRT_SalespersonProducerTarget.DefaultTargetQta ELSE STRT_SalespersonProducerCtgTarget.DefaultTargetQta END) - STRT_VenditePerAgenteAnnoCor.Qta) AS Qta_Delta,
SUM((STRT_VenditePerAgenteAnnoPrec.Qta / 100) * (100 + CASE WHEN STRT_SalespersonProducerTarget.DefaultTargetImponibile IS NOT NULL
THEN STRT_SalespersonProducerTarget.DefaultTargetImponibile ELSE STRT_SalespersonProducerCtgTarget.DefaultTargetImponibile END) - STRT_VenditePerAgenteAnnoCor.Imponibile)
AS Imponibile_Delta
FROM STRT_VenditePerAgenteAnnoPrec FULL OUTER JOIN
STRT_SalespersonProducerCtgTarget ON STRT_VenditePerAgenteAnnoPrec.Salesperson = STRT_SalespersonProducerCtgTarget.Salesperson AND
STRT_VenditePerAgenteAnnoPrec.CommodityCtg = STRT_SalespersonProducerCtgTarget.CommodityCtg AND
STRT_VenditePerAgenteAnnoPrec.Producer = STRT_SalespersonProducerCtgTarget.Producer FULL OUTER JOIN
STRT_VenditePerAgenteAnnoCor ON STRT_SalespersonProducerCtgTarget.Producer = STRT_VenditePerAgenteAnnoCor.Producer AND
STRT_SalespersonProducerCtgTarget.CommodityCtg = STRT_VenditePerAgenteAnnoCor.CommodityCtg AND
STRT_SalespersonProducerCtgTarget.Salesperson = STRT_VenditePerAgenteAnnoCor.Salesperson AND STRT_VenditePerAgenteAnnoPrec.Salesperson = STRT_VenditePerAgenteAnnoCor.Salesperson AND
STRT_VenditePerAgenteAnnoPrec.CommodityCtg = STRT_VenditePerAgenteAnnoCor.CommodityCtg AND STRT_VenditePerAgenteAnnoPrec.Producer = STRT_VenditePerAgenteAnnoCor.Producer FULL OUTER JOIN
STRT_SalespersonProducerTarget ON STRT_VenditePerAgenteAnnoCor.Producer = STRT_SalespersonProducerTarget.Producer AND
STRT_VenditePerAgenteAnnoCor.Salesperson = STRT_SalespersonProducerTarget.Salesperson AND STRT_VenditePerAgenteAnnoPrec.Salesperson = STRT_SalespersonProducerTarget.Salesperson AND
STRT_VenditePerAgenteAnnoPrec.Producer = STRT_SalespersonProducerTarget.Producer
GROUP BY STRT_VenditePerAgenteAnnoPrec.Salesperson, STRT_VenditePerAgenteAnnoPrec.Name"></
asp:SqlDataSource
>
</
asp:Content
>
Hi!!
I am currently developing an organization chart application with RadOrchart, but the organization charts is very large (more than 2000 persons), it is not works fine, not display the organization chart in front end and when I want export to PDF the browser unexpectedly closes, it is possible generate organization charts such a large with RadOrchart or exist a limit number of people to it works well??
Regards.