Hello!
I have horisontal scrolling bar, in aspx file it looks like:
<telerik:RadMenu ID="ActionListMenu" SkinID="Menu" OnItemDataBound="OnActionButtonDataBound"
Width="100%" Flow="Horizontal" runat="server" DefaultGroupSettings-Flow="Horizontal" DefaultGroupSettings-RepeatColumns="1" CssClass="ActionsBar">
</telerik:RadMenu>
and in website it's:
<div class="rmScrollWrap rmRootGroup rmHorizontal" style="overflow-x: hidden; overflow-y: hidden; width: 100%; overflow: visible;">
<ul class="rmRootScrollGroup" style="position: relative; width: 519px; display: block; left: -35px;">
<li class="rmItem " ... />
...
<li class="rmItem " ... />
</ul>
<a class="rmLeftArrow" style="z-index: 2000; top: 0px; left: -1px;" href="#" jQuery191013909904974899967="13">
<a class="rmRightArrow" style="z-index: 2000; top: 0px; right: -1px;" href="#" jQuery191013909904974899967="11">
</div>
Now I'm trying to make it scroll farther (more than one "rmItem").
To do so I tried to add events to "rmLeftArrow" and "rmRightArrow" that would change "rmRootScrollGroup" "left" css property, but after all it comming back to the place it shuld be without my stript.
I think that after clicking on arrow Telerik's script sets expected value of "rmRootScrollGroup" "left" css property to some variable, and after moving it by any way (mouse scrolling, clicking/mouseovering arrows) it will start from the point it shuld be.
Example:
After clicking on the right arrow, position of rmRootScrollGroup shuld change from 0px to -25px.
I add another -200px (by attatching click event on arrow, something like .style.left = (.style.left - 200) + 'px' ))
so now rmRootScrollGroup has property left: -225px. And it really appears on -225px.
The problem is, that after mouseovering on arrow it will return to -25px :(
Is there any way to make it moving further?
I try to use FrozenColumn for Grid after Read Demo. But when I apply FrozenColumn & UseStaticHeader, Column will always display only with match width of grid (Other column will lost) and When Scroll, only data will scroll while header still the same (that doesn't match with data column). Freeze column doesn't work too.
I have attached picture of My Grid (I using Simple Databinding) , "Initial" is when data loaded and "Scrolled" is when I scrolled Horizontal.
Below is my code
<
telerik:RadGrid
ID
=
"RadGridBudgetDataEntry"
runat
=
"server"
AutoGenerateColumns
=
"False"
CellSpacing
=
"-1"
GridLines
=
"Both"
AllowSorting
=
"True"
AllowPaging
=
"True"
PageSize
=
"20"
Width
=
"800px"
Height
=
"500px"
OnItemDataBound
=
"RadGridBudgetDataEntry_ItemDataBound"
>
<
ClientSettings
>
<
Scrolling
AllowScroll
=
"True"
SaveScrollPosition
=
"true"
UseStaticHeaders
=
"true"
FrozenColumnsCount
=
"1"
>
</
Scrolling
>
</
ClientSettings
>
<
MasterTableView
TableLayout
=
"Fixed"
>
<
Columns
>
<
telerik:GridTemplateColumn
DataField
=
"AccountCode"
FilterControlAltText
=
"Filter TemplateColumn column"
HeaderText
=
"Code"
ReadOnly
=
"True"
UniqueName
=
"AccountCode"
HeaderStyle-Width
=
"200px"
>
<
ItemTemplate
>
<
telerik:RadLabel
ID
=
"RadLabelAccountCode2"
runat
=
"server"
Text='<%# Eval("AccountCode") %>'>
</
telerik:RadLabel
>
</
ItemTemplate
>
<
HeaderStyle
HorizontalAlign
=
"Center"
/>
<
ItemStyle
HorizontalAlign
=
"Left"
/>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
DataField
=
"AccountName"
FilterControlAltText
=
"Filter TemplateColumn1 column"
HeaderText
=
"Full Description"
UniqueName
=
"AccountName"
HeaderStyle-Width
=
"200px"
>
<
ItemTemplate
>
<
telerik:RadLabel
ID
=
"RadLabelAccountName"
runat
=
"server"
Text='<%# Eval("AccountName") %>'>
</
telerik:RadLabel
>
</
ItemTemplate
>
<
HeaderStyle
HorizontalAlign
=
"Center"
/>
<
ItemStyle
HorizontalAlign
=
"Left"
/>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
DataField
=
"Jan_Amt"
FilterControlAltText
=
"Filter TemplateColumn1 column"
HeaderText
=
"Jan"
UniqueName
=
"Jan_Amt"
HeaderStyle-Width
=
"200px"
>
<
ItemTemplate
>
<
telerik:RadLabel
ID
=
"RadLabelJan_Amt"
runat
=
"server"
Text='<%# Eval("Jan_Amt") %>'>
</
telerik:RadLabel
>
</
ItemTemplate
>
<
HeaderStyle
HorizontalAlign
=
"Center"
/>
<
ItemStyle
HorizontalAlign
=
"Left"
/>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
DataField
=
"Feb_Amt"
FilterControlAltText
=
"Filter TemplateColumn1 column"
HeaderText
=
"Feb"
UniqueName
=
"Feb_Amt"
HeaderStyle-Width
=
"200px"
>
<
ItemTemplate
>
<
telerik:RadLabel
ID
=
"RadLabelFeb_Amt"
runat
=
"server"
Text='<%# Eval("Feb_Amt") %>'>
</
telerik:RadLabel
>
</
ItemTemplate
>
<
HeaderStyle
HorizontalAlign
=
"Center"
/>
<
ItemStyle
HorizontalAlign
=
"Left"
/>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
DataField
=
"Mar_Amt"
FilterControlAltText
=
"Filter TemplateColumn1 column"
HeaderText
=
"Mar"
UniqueName
=
"Mar_Amt"
HeaderStyle-Width
=
"200px"
>
<
ItemTemplate
>
<
telerik:RadLabel
ID
=
"RadLabelMar_Amt"
runat
=
"server"
Text='<%# Eval("Mar_Amt") %>'>
</
telerik:RadLabel
>
</
ItemTemplate
>
<
HeaderStyle
HorizontalAlign
=
"Center"
/>
<
ItemStyle
HorizontalAlign
=
"Left"
/>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
DataField
=
"Apr_Amt"
FilterControlAltText
=
"Filter TemplateColumn1 column"
HeaderText
=
"Apr"
UniqueName
=
"Apr_Amt"
HeaderStyle-Width
=
"200px"
>
<
ItemTemplate
>
<
telerik:RadLabel
ID
=
"RadLabelApr_Amt"
runat
=
"server"
Text='<%# Eval("Apr_Amt") %>'>
</
telerik:RadLabel
>
</
ItemTemplate
>
<
HeaderStyle
HorizontalAlign
=
"Center"
/>
<
ItemStyle
HorizontalAlign
=
"Left"
/>
</
telerik:GridTemplateColumn
>
</
Columns
>
</
MasterTableView
>
<
PagerStyle
PageSizeControlType
=
"RadDropDownList"
Mode
=
"NextPrevAndNumeric"
></
PagerStyle
>
</
telerik:RadGrid
>
I've been trying to get the Filter Template on the grid to work with a RadComboBox, but have not been successful. I'm binding to a dataset which is a little different than the example at Filter Template Example. The dropdown seems to load correctly the first time, but then when I make a selection it fails. I'm guessing it's in the client code because it never gets back to the .
I'm getting the error:
Selection out of range
Parameter name: value
Below is my code:
<
telerik:RadGrid
ID
=
"rgAudits"
runat
=
"server"
OnPreRender
=
"rgAudits_PreRender"
AllowPaging
=
"True"
AllowSorting
=
"True"
AutoGenerateColumns
=
"False"
CellSpacing
=
"0"
ClientSettings-AllowColumnsReorder
=
"false"
ClientSettings-Resizing-AllowColumnResize
=
"false"
ClientSettings-Scrolling-UseStaticHeaders
=
"true"
EnableLinqExpressions
=
"False"
ExportSettings-ExportOnlyData
=
"false"
ExportSettings-IgnorePaging
=
"true"
ExportSettings-OpenInNewWindow
=
"true"
ExportSettings-HideStructureColumns
=
"true"
ExportSettings-FileName
=
"Audit"
GridLines
=
"None"
GroupingSettings-CaseSensitive
=
"false"
MasterTableView-AllowMultiColumnSorting
=
"false"
MasterTableView-AllowNaturalSort
=
"false"
AllowFilteringByColumn
=
"true"
MasterTableView-CommandItemDisplay
=
"Top"
MasterTableView-CommandItemSettings-ShowAddNewRecordButton
=
"false"
MasterTableView-CommandItemSettings-ShowRefreshButton
=
"false"
MasterTableView-CommandItemSettings-ShowExportToCsvButton
=
"false"
MasterTableView-CommandItemSettings-ShowExportToExcelButton
=
"true"
ExportSettings-Excel-Format
=
"Xlsx"
MasterTableView-CommandItemSettings-ShowExportToPdfButton
=
"true"
ExportSettings-Pdf-AllowCopy
=
"true"
ExportSettings-Pdf-AllowPrinting
=
"true"
ExportSettings-Pdf-AllowModify
=
"true"
MasterTableView-CommandItemSettings-ShowExportToWordButton
=
"true"
ExportSettings-Word-Format
=
"Docx"
MasterTableView-PagerStyle-PagerTextFormat
=
"{4} Page {0} of {1}, rows {2} to {3} of {5}"
MasterTableView-PagerStyle-Position
=
"TopAndBottom"
MasterTableView-PagerStyle-PageButtonCount
=
"10"
MasterTableView-PagerStyle-EnableAllOptionInPagerComboBox
=
"false"
PagerStyle-PageSizes
=
"10,25,50,100"
PageSize
=
"25"
PagerStyle-AlwaysVisible
=
"true"
MasterTableView-TableLayout
=
"Fixed"
>
<
GroupingSettings
CaseSensitive
=
"false"
/>
<
MasterTableView
>
<
NoRecordsTemplate
>
<
div
>
There are no records to display select a system from the drop down list.
</
div
>
</
NoRecordsTemplate
>
<
CommandItemSettings
ShowExportToPdfButton
=
"true"
ShowExportToExcelButton
=
"true"
ShowAddNewRecordButton
=
"false"
ShowRefreshButton
=
"false"
/>
<
SortExpressions
>
<
telerik:GridSortExpression
FieldName
=
"CREATEDON"
SortOrder
=
"Descending"
/>
</
SortExpressions
>
<
Columns
>
<
telerik:GridBoundColumn
UniqueName
=
"AUDITID"
DataField
=
"AuditId"
HeaderText
=
"Audit ID"
AutoPostBackOnFilter
=
"true"
CurrentFilterFunction
=
"EqualTo"
ShowFilterIcon
=
"false"
FilterControlWidth
=
"75px"
ItemStyle-HorizontalAlign
=
"Left"
DataType
=
"System.Int32"
SortExpression
=
"AUDITID"
>
<
HeaderStyle
Width
=
"110px"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
UniqueName
=
"FULLNAME"
DataField
=
"FullName"
HeaderText
=
"Created By"
AutoPostBackOnFilter
=
"true"
CurrentFilterFunction
=
"Contains"
ShowFilterIcon
=
"false"
DataType
=
"System.String"
SortExpression
=
"FULLNAME"
ItemStyle-HorizontalAlign
=
"Left"
>
<
HeaderStyle
Width
=
"160px"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridDateTimeColumn
UniqueName
=
"CREATEDON"
DataField
=
"CreatedOn"
HeaderText
=
"Created On"
AutoPostBackOnFilter
=
"true"
PickerType
=
"DatePicker"
DataFormatString
=
"{0:dd MMM yyyy hh:mm:ss}"
HtmlEncode
=
"false"
CurrentFilterFunction
=
"GreaterThanOrEqualTo"
ShowFilterIcon
=
"false"
ItemStyle-HorizontalAlign
=
"Left"
>
<
HeaderStyle
Width
=
"170px"
/>
</
telerik:GridDateTimeColumn
>
<
telerik:GridBoundColumn
UniqueName
=
"AUDITTYPEDESCRIPTION"
DataField
=
"AuditTypeDescription"
HeaderText
=
"Type"
AutoPostBackOnFilter
=
"true"
ShowFilterIcon
=
"false"
DataType
=
"System.String"
ItemStyle-HorizontalAlign
=
"Left"
CurrentFilterFunction
=
"Contains"
SortExpression
=
"AUDITTYPEDESCRIPTION"
>
<
HeaderStyle
Width
=
"130px"
/>
<
FilterTemplate
>
<
telerik:RadComboBox
RenderMode
=
"Lightweight"
ID
=
"rcbAuditTypes"
Skin
=
"Default"
DropDownAutoWidth
=
"Enabled"
Width
=
"128px"
AppendDataBoundItems
=
"true"
SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("AUDITTYPEDESCRIPTION").CurrentFilterValue %>'
runat="server" OnClientSelectedIndexChanged="AuditTypeIndexChanged">
<
Items
>
<
telerik:RadComboBoxItem
Text
=
"All"
/>
</
Items
>
</
telerik:RadComboBox
>
<
telerik:RadScriptBlock
ID
=
"rsbAuditType"
runat
=
"server"
>
<
script
type
=
"text/javascript"
>
function AuditTypeIndexChanged(sender, args) {
var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");
tableView.filter("AUDITTYPEDESCRIPTION", args.get_item().get_value(), "EqualTo");
}
</
script
>
</
telerik:RadScriptBlock
>
</
FilterTemplate
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
UniqueName
=
"AUDITDESCRIPTION"
DataField
=
"AuditDescription"
HeaderText
=
"Description"
AutoPostBackOnFilter
=
"true"
ShowFilterIcon
=
"false"
DataType
=
"System.String"
ItemStyle-HorizontalAlign
=
"Left"
CurrentFilterFunction
=
"Contains"
AllowSorting
=
"false"
/>
</
Columns
>
</
MasterTableView
>
</
telerik:RadGrid
>
private
void
refreshCombos()
{
AdminServiceClient adminProxy =
new
AdminServiceClient();
DataSet ds = adminProxy.GetUniqueAuditTypeCode(rgAudits.MasterTableView.FilterExpression.ToString());
RadComboBox rcb =
new
RadComboBox();
foreach
(GridFilteringItem item
in
rgAudits.MasterTableView.GetItems(GridItemType.FilteringItem))
{
rcb = (RadComboBox)item.FindControl(
"rcbAuditTypes"
);
}
rcb.DataTextField =
"AuditDescription"
;
rcb.DataValueField =
"AuditTypeCode"
;
rcb.DataSource = ds;
rcb.DataBind();
//rgAudits.MasterTableView.Rebind();
}
Note, in the example you have the rebind that I've commented out above. When I do this, my ComboBox comes out empty. If I leave it out, then I get the values in the Combo Box.
I'm having a secondary problem with the ComboBox itself. Sometimes, the text in the is huge, other times it's the right size. I have no idea what's causing this.
Thanks
Rodney
RadCombox version is 2017 R2 (2017.05.03).
When user chooses second item: "empty", the SelectedIndex=1 when AllowCustomText=False,
but SelectedIndex=-1 if the value is empty when AllowCustomText=True.
I think it's a bug for empty value in AllowCustomText mode.
<
telerik:RadComboBox
ID
=
"Type"
runat
=
"server"
AllowCustomText
=
"true"
RenderMode
=
"Lightweight"
CollapseAnimation-Duration
=
"0"
ExpandAnimation-Duration
=
"0"
>
<
Items
>
<
telerik:RadComboBoxItem
Text
=
"first"
Value
=
"1"
/>
<
telerik:RadComboBoxItem
Text
=
"empty"
Value
=
""
/>
<
telerik:RadComboBoxItem
Text
=
"third"
Value
=
"2"
/>
</
Items
>
</
telerik:RadComboBox
>
I have a pivot grid bound to a sql data source. When I attempt to export, the resulting excel file is gibberish (see screenshot). My version is 2017.1.118. What am I missing?
<telerik:RadPivotGrid ID="rpgResults" runat="server" DataSourceID="sdsSummary" Width="100%"
EnableTheming="false" EnableEmbeddedSkins="true" Skin="Default" RenderMode="Lightweight"
AllowFiltering="False" AggregatesPosition="Columns" ShowFilterHeaderZone="False" ShowDataHeaderZone="False" ShowColumnHeaderZone="False" ShowRowHeaderZone="False"
OnCellDataBound="RadPivotGrid1_CellDataBound">
<ClientSettings>
<Scrolling AllowVerticalScroll="True" ScrollHeight="600px" />
</ClientSettings>
<Fields>
<telerik:PivotGridRowField DataField="Year" />
<telerik:PivotGridRowField DataField="Qtr" />
<telerik:PivotGridRowField DataField="Month" SortOrder="None" />
<telerik:PivotGridColumnField DataField="InvoiceType" />
<telerik:PivotGridAggregateField DataField="Amount" Aggregate="Sum" DataFormatString="{0:C}" />
<telerik:PivotGridAggregateField DataField="Invoices" Aggregate="Count" DataFormatString="{0:N0}" />
</Fields>
</telerik:RadPivotGrid>
button click code for exporting...
rpgResults.ExportSettings.Excel.Format = PivotGridExcelFormat.Biff
rpgResults.ExportSettings.FileName = "Processed_Invoice_Summary"
rpgResults.ExportSettings.IgnorePaging = True
rpgResults.ExportSettings.OpenInNewWindow = False
rpgResults.ExportToExcel()
Hi,
I have two issues with Kendo exporting PDF.
I am following the example from:
https://demos.telerik.com/kendo-ui/pdf-export/index
First one:
Here are two images attached showing the difference between WebPage text and PDF text. The text is vertical in my webpage but was changed to horizontal after being exported to PDF.
Second One:
I added a div element on my page filled with a chart. I draw this chart using Google Chart Library.
However when I exported PDF my chart is lost.
Could you please take a look?
Thanks.
Hello!
I'm trying to implement a way to automatically resize the diagram to fit the canvas (i.e. automatic zoom) after it is loaded. But I could not find a built-in functionality. Is this possible?
Best Regards,