or
10 answers
162 views
We have a pivotgrid that isn't working correctly. The data comes from a stored procedure that de-normalizes a bunch of data, so that users can do ad-hoc querying on the results. The table can run into several hundred thousand rows.
This used to work correctly, but recently (perhaps with the q2 2014 update?) we've noticed issues. Drag a column into the row columns group, wheel spins, eventually the original table returns with no column breakdown. Sometimes (not consistently) we can get it to work by right-clicking, selecting 'Move to COLUMN field', generate, then right-click and move to row field.
We were using Ajax on the grid, tried removing that with no change. We've tried deferring the layout update, no difference. It seems the columns that cause the issue are usually text columns, but there is no error thrown and nothing reported on screen, just no column breakdown.
The frustrating thing is this used to work, and neither code or data has changed. Here's the code used to generate the pivot. The data source is an objectdatasource, using a query running against SQL Server.
<telerik:RadPivotGrid ID="pivotData" runat="server" AggregatesLevel="-1" AggregatesPosition="Columns"
DataSourceID="dsExpenditures"
ShowColumnHeaderZone="False" ShowDataHeaderZone="False" ShowRowHeaderZone="False" EnableConfigurationPanel="true"
Skin="Metro">
<Fields>
<telerik:PivotGridAggregateField Caption="Total Spend" DataField="TotalSpend" UniqueName="TotalSpend"
DataFormatString="{0:n2}">
</telerik:PivotGridAggregateField>
</Fields>
<ConfigurationPanelSettings LayoutType="OneByFour" Position="Left" DefaultDeferedLayoutUpdate="true">
</ConfigurationPanelSettings>
</telerik:RadPivotGrid>
This used to work correctly, but recently (perhaps with the q2 2014 update?) we've noticed issues. Drag a column into the row columns group, wheel spins, eventually the original table returns with no column breakdown. Sometimes (not consistently) we can get it to work by right-clicking, selecting 'Move to COLUMN field', generate, then right-click and move to row field.
We were using Ajax on the grid, tried removing that with no change. We've tried deferring the layout update, no difference. It seems the columns that cause the issue are usually text columns, but there is no error thrown and nothing reported on screen, just no column breakdown.
The frustrating thing is this used to work, and neither code or data has changed. Here's the code used to generate the pivot. The data source is an objectdatasource, using a query running against SQL Server.
<telerik:RadPivotGrid ID="pivotData" runat="server" AggregatesLevel="-1" AggregatesPosition="Columns"
DataSourceID="dsExpenditures"
ShowColumnHeaderZone="False" ShowDataHeaderZone="False" ShowRowHeaderZone="False" EnableConfigurationPanel="true"
Skin="Metro">
<Fields>
<telerik:PivotGridAggregateField Caption="Total Spend" DataField="TotalSpend" UniqueName="TotalSpend"
DataFormatString="{0:n2}">
</telerik:PivotGridAggregateField>
</Fields>
<ConfigurationPanelSettings LayoutType="OneByFour" Position="Left" DefaultDeferedLayoutUpdate="true">
</ConfigurationPanelSettings>
</telerik:RadPivotGrid>
Maria Ilieva
Telerik team
answered
on
03 Oct 2014
1 answer
92 views
Hello,
i want to implement the OnDataBound event of a RadGrid in the client side but the sender is always returning null. Also i tried $find("<%GridId.ClientID%>") but also not working .
i can't find the reason of this problem and how can i resolve it. Any help please??
i want to implement the OnDataBound event of a RadGrid in the client side but the sender is always returning null. Also i tried $find("<%GridId.ClientID%>") but also not working .
i can't find the reason of this problem and how can i resolve it. Any help please??
Konstantin Dikov
Telerik team
answered
on
03 Oct 2014
0 answers
98 views
I am trying to follow the ajax tutorial at wschools.com. However when I copy and paste this code it does not work:
<!DOCTYPE html>
<html>
<head>
<script>
function loadXMLDoc()
{
var xmlhttp;
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.readyState==4 && xmlhttp.status==200)
{
document.getElementById("myDiv").innerHTML=xmlhttp.responseText;
}
}
xmlhttp.open("GET","ajax_info.txt",true);
xmlhttp.send();
}
</script>
</head>
<body>
<div id="myDiv"><h2>Let AJAX change this text</h2></div>
<button type="button" onclick="loadXMLDoc()">Change Content</button>
</body>
</html>
<!DOCTYPE html>
<html>
<head>
<script>
function loadXMLDoc()
{
var xmlhttp;
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.readyState==4 && xmlhttp.status==200)
{
document.getElementById("myDiv").innerHTML=xmlhttp.responseText;
}
}
xmlhttp.open("GET","ajax_info.txt",true);
xmlhttp.send();
}
</script>
</head>
<body>
<div id="myDiv"><h2>Let AJAX change this text</h2></div>
<button type="button" onclick="loadXMLDoc()">Change Content</button>
</body>
</html>
1 answer
45 views
Hi,
I am using radgrid with multiple headers. The headers are added in run time like as below
Dim header As GridItem() = rdgrid1.MasterTableView.GetItems(GridItemType.Header)
' Get the current THead element
Dim head As GridTHead = CType(header(0).Parent.Controls(0).Parent, GridTHead)
Dim additionalHeaderItem As GridHeaderItem
head.Controls.Add(additionalHeaderItem)
The changes are displayed. But, while export the grid, its only exporting only one header with data. The newly added header item is not exported. Kinly any one help to resolve this issue
Thanks in Advance,
By,
G.Senthilraja
I am using radgrid with multiple headers. The headers are added in run time like as below
Dim header As GridItem() = rdgrid1.MasterTableView.GetItems(GridItemType.Header)
' Get the current THead element
Dim head As GridTHead = CType(header(0).Parent.Controls(0).Parent, GridTHead)
Dim additionalHeaderItem As GridHeaderItem
head.Controls.Add(additionalHeaderItem)
The changes are displayed. But, while export the grid, its only exporting only one header with data. The newly added header item is not exported. Kinly any one help to resolve this issue
Thanks in Advance,
By,
G.Senthilraja
Kostadin
Telerik team
answered
on
03 Oct 2014
2 answers
61 views
I'm having mostly success using the navigator, but my selection hint always looks white/blank. The area seems to change size if I change the DataFormatString, which would seem to indicate the text is there ( I have not looked at source or browser debugger to verify), but I can't find any information about changing this text color.
Any insight or help would be appreciated.
Thanks,
-Rick
Any insight or help would be appreciated.
Thanks,
-Rick
Danail Vasilev
Telerik team
answered
on
03 Oct 2014
3 answers
135 views
When I use the Paste Plain text pop-up (associated with the non IE browsers), Although the Paste Plain text popup will appear directly over the RadEditor, the browser will jump UP to the top of the page and you will need to scroll back down to where the RADeditor is loaded to continue editing. This only happens the first time when pasting into the Radeditor and only from the non IE browsers.
Its not apparent on pages that are not tall, or where the RadEditor is at the top of the page. But in instances where the RadEditor appears low on the page it's quite annoying. Is there anything that can be done to prevent this jump?
Its not apparent on pages that are not tall, or where the RadEditor is at the top of the page. But in instances where the RadEditor appears low on the page it's quite annoying. Is there anything that can be done to prevent this jump?
Ianko
Telerik team
answered
on
03 Oct 2014
2 answers
94 views
Hello,
I was trying to copy this scenario: http://demos.telerik.com/aspnet-ajax/htmlchart/examples/functionality/datanavigation/defaultcs.aspx
in my project. I copied RadHtmlChart block of code with datasource and file as well.
I found that all Chart turns white without nothing on it and i Get JS error:
"Uncaught TypeError: Cannot read property 'length' of undefined Telerik.Web.UI.WebResource.axd?_TSM_HiddenField_=ctl00_rsm_TSM&compress=1&_TSM_CombinedScripts_=%3b…:16929"
Then i did comment on Navigator Series code. and after that top chart was showed proper.
After that i turned back to 2014.1.403.40 build where everything is ok.
Can you help me by telling what cause that error?
I was trying to copy this scenario: http://demos.telerik.com/aspnet-ajax/htmlchart/examples/functionality/datanavigation/defaultcs.aspx
in my project. I copied RadHtmlChart block of code with datasource and file as well.
I found that all Chart turns white without nothing on it and i Get JS error:
"Uncaught TypeError: Cannot read property 'length' of undefined Telerik.Web.UI.WebResource.axd?_TSM_HiddenField_=ctl00_rsm_TSM&compress=1&_TSM_CombinedScripts_=%3b…:16929"
Then i did comment on Navigator Series code. and after that top chart was showed proper.
After that i turned back to 2014.1.403.40 build where everything is ok.
Can you help me by telling what cause that error?
Danail Vasilev
Telerik team
answered
on
03 Oct 2014
1 answer
180 views
Hi,
I am creating a chart with two ColumnSeries with X-Axis containing Date and Y-Axis containing Item count. Now I want to create a stacked chart for the two series. Below is the program i have got. When I ran this, I am getting attached Chart which has X-Axis items not overlapping. For Series2, X-Axis items are again added. Even though, I am checking for the duplicates, it is adding the x-axis item.
I cannot use Date as X-Axis type because, it only supports Databound objects. Is there a way to achieve my desired behavior without X-Axis values overlapping?
Satish
private void UpdateOperationsChart()
{
SqlDataClient prodClient = new SqlDataClient(DataSource.Prod);
prodClient.Init();
DataTable table200 = prodClient.GetProvisioningOperations(OperationType.SelectedText,200);
DataTable table500 = prodClient.GetProvisioningOperations(OperationType.SelectedText,500);
ProvisioningChart.PlotArea.XAxis.TitleAppearance.Text = "Day";
ProvisioningChart.PlotArea.YAxis.TitleAppearance.Text = "Request Duration In Mins";
AxisY axisY = new AxisY();
axisY.Name = "Operation Count";
ProvisioningChart.PlotArea.AdditionalYAxes.Add(axisY);
ProvisioningChart.PlotArea.XAxis.Type = Telerik.Web.UI.HtmlChart.AxisType.Category;
ProvisioningChart.PlotArea.XAxis.AxisCrossingPoints.Add(0);
ProvisioningChart.PlotArea.XAxis.AxisCrossingPoints.Add(100);
LineSeries durationAvgSeries = new LineSeries();
durationAvgSeries.Appearance.FillStyle.BackgroundColor = System.Drawing.Color.Blue;
ColumnSeries request200Series = new ColumnSeries();
ColumnSeries request500Series = new ColumnSeries();
//request200Series.AxisName = "200";
//request500Series.AxisName = "500";
request200Series.Appearance.FillStyle.BackgroundColor = System.Drawing.Color.Green;
request500Series.Appearance.FillStyle.BackgroundColor = System.Drawing.Color.Red;
foreach (DataRow row in table200.Rows)
{
//durationAvgSeries.SeriesItems.Add(Decimal.Parse(row["AvgDurationInMin"].ToString()));
request200Series.SeriesItems.Add(Decimal.Parse(row["OperationCount"].ToString()));
AxisItem xAxisItem = new AxisItem(Convert.ToDateTime(row["Day"].ToString()).Month + "/" + Convert.ToDateTime(row["Day"].ToString()).Day);
if (!ProvisioningChart.PlotArea.XAxis.Items.Contains(xAxisItem))
ProvisioningChart.PlotArea.XAxis.Items.Add(xAxisItem);
}
foreach (DataRow row in table500.Rows)
{
//durationAvgSeries.SeriesItems.Add(Decimal.Parse(row["AvgDurationInMin"].ToString()));
request500Series.SeriesItems.Add(Decimal.Parse(row["OperationCount"].ToString()));
AxisItem xAxisItem = new AxisItem(Convert.ToDateTime(row["Day"].ToString()).Month + "/" + Convert.ToDateTime(row["Day"].ToString()).Day);
if (!ProvisioningChart.PlotArea.XAxis.Items.Contains(xAxisItem))
ProvisioningChart.PlotArea.XAxis.Items.Add(xAxisItem);
}
ProvisioningChart.PlotArea.Series.Add(request200Series);
ProvisioningChart.PlotArea.Series.Add(request500Series);
//ProvisioningChart.PlotArea.Series.Add(durationAvgSeries);
request200Series.Stacked = true;
request500Series.Name = "500";
request200Series.Name = "200";
durationAvgSeries.Name = "AvgDurationInMin";
prodClient.Close();
}
I am creating a chart with two ColumnSeries with X-Axis containing Date and Y-Axis containing Item count. Now I want to create a stacked chart for the two series. Below is the program i have got. When I ran this, I am getting attached Chart which has X-Axis items not overlapping. For Series2, X-Axis items are again added. Even though, I am checking for the duplicates, it is adding the x-axis item.
I cannot use Date as X-Axis type because, it only supports Databound objects. Is there a way to achieve my desired behavior without X-Axis values overlapping?
Satish
private void UpdateOperationsChart()
{
SqlDataClient prodClient = new SqlDataClient(DataSource.Prod);
prodClient.Init();
DataTable table200 = prodClient.GetProvisioningOperations(OperationType.SelectedText,200);
DataTable table500 = prodClient.GetProvisioningOperations(OperationType.SelectedText,500);
ProvisioningChart.PlotArea.XAxis.TitleAppearance.Text = "Day";
ProvisioningChart.PlotArea.YAxis.TitleAppearance.Text = "Request Duration In Mins";
AxisY axisY = new AxisY();
axisY.Name = "Operation Count";
ProvisioningChart.PlotArea.AdditionalYAxes.Add(axisY);
ProvisioningChart.PlotArea.XAxis.Type = Telerik.Web.UI.HtmlChart.AxisType.Category;
ProvisioningChart.PlotArea.XAxis.AxisCrossingPoints.Add(0);
ProvisioningChart.PlotArea.XAxis.AxisCrossingPoints.Add(100);
LineSeries durationAvgSeries = new LineSeries();
durationAvgSeries.Appearance.FillStyle.BackgroundColor = System.Drawing.Color.Blue;
ColumnSeries request200Series = new ColumnSeries();
ColumnSeries request500Series = new ColumnSeries();
//request200Series.AxisName = "200";
//request500Series.AxisName = "500";
request200Series.Appearance.FillStyle.BackgroundColor = System.Drawing.Color.Green;
request500Series.Appearance.FillStyle.BackgroundColor = System.Drawing.Color.Red;
foreach (DataRow row in table200.Rows)
{
//durationAvgSeries.SeriesItems.Add(Decimal.Parse(row["AvgDurationInMin"].ToString()));
request200Series.SeriesItems.Add(Decimal.Parse(row["OperationCount"].ToString()));
AxisItem xAxisItem = new AxisItem(Convert.ToDateTime(row["Day"].ToString()).Month + "/" + Convert.ToDateTime(row["Day"].ToString()).Day);
if (!ProvisioningChart.PlotArea.XAxis.Items.Contains(xAxisItem))
ProvisioningChart.PlotArea.XAxis.Items.Add(xAxisItem);
}
foreach (DataRow row in table500.Rows)
{
//durationAvgSeries.SeriesItems.Add(Decimal.Parse(row["AvgDurationInMin"].ToString()));
request500Series.SeriesItems.Add(Decimal.Parse(row["OperationCount"].ToString()));
AxisItem xAxisItem = new AxisItem(Convert.ToDateTime(row["Day"].ToString()).Month + "/" + Convert.ToDateTime(row["Day"].ToString()).Day);
if (!ProvisioningChart.PlotArea.XAxis.Items.Contains(xAxisItem))
ProvisioningChart.PlotArea.XAxis.Items.Add(xAxisItem);
}
ProvisioningChart.PlotArea.Series.Add(request200Series);
ProvisioningChart.PlotArea.Series.Add(request500Series);
//ProvisioningChart.PlotArea.Series.Add(durationAvgSeries);
request200Series.Stacked = true;
request500Series.Name = "500";
request200Series.Name = "200";
durationAvgSeries.Name = "AvgDurationInMin";
prodClient.Close();
}
Danail Vasilev
Telerik team
answered
on
03 Oct 2014
1 answer
83 views
Is there any easy way to add some additional controls on the pager without using a template and (thereby) redefine the complete pager?
Today I have a DropDown where the user can select to what depth the TreeList should be expanded. It would be very nice if I in some way could have this dropDown located on the Pager instead of outside of the TreeList control, but I don't want to redefine the complete Pager with all it's current controls, just add one extra on the existing line. I've attached a screen shot indication what I want to do.
What is the simplest way of doing this?
Today I have a DropDown where the user can select to what depth the TreeList should be expanded. It would be very nice if I in some way could have this dropDown located on the Pager instead of outside of the TreeList control, but I don't want to redefine the complete Pager with all it's current controls, just add one extra on the existing line. I've attached a screen shot indication what I want to do.
What is the simplest way of doing this?
Eyup
Telerik team
answered
on
03 Oct 2014
4 answers
315 views
Hi I have a RadCombobox control, and a requiredFieldValidator that validates it for empty text.
The thing is that when I tried to key in any text, it gives me the validation error (instead of the other way round). So when I typed in "testing" it prompts the error. When I removed it, it is still there.
The thing is that when I tried to key in any text, it gives me the validation error (instead of the other way round). So when I typed in "testing" it prompts the error. When I removed it, it is still there.
The error will not disappear until I tried to select one of the item inside the dropdownlist.Anyone had any idea?
Below is my aspx code:
<telerik:RadComboBox ID="radProcessLn" runat="server" AllowCustomText="true" EnableScreenBoundaryDetection="False" EmptyMessage="Insert/select" />
<asp:RequiredFieldValidator ID="rfvProcessLn" ControlToValidate="radProcessLn" ErrorMessage="Please enter Process Ln / Operation" InitialValue="" ValidationGroup="Submit" CssClass="mandatory" runat="server"Display="Dynamic" />Update: Tested it out on Google Chrome, IE8, and IE7 and the validation is working just fine. But it's not in IE9.
