Questions on UI for ASP.NET AJAX Forum

1 answer

193 views

grid not grouping data - says grouping field not found in the source table

Hi

I am using quite an old version of radgrid (q3 2009). The grid is not grouping my data. I have tried to group the data programmatically and declaratively and i get the same error. I am trying to group the data by a field called Reg which definitely exists in the underlying data as it displays fine in the grid if i remove any attempt to group the data

Here is the code

Dim expression As GridGroupByExpression = New GridGroupByExpression

Dim gridGroupByField As GridGroupByField = New GridGroupByField

'SelectFields values (appear in header)

gridGroupByField = New GridGroupByField

gridGroupByField.FieldName = "Reg"

gridGroupByField.HeaderText = "Reg"

expression.SelectFields.Add(gridGroupByField)

expression.GroupByFields.Add(gridGroupByField)

gridJourneys.MasterTableView.GroupByExpressions.Add(expression)

Here is the aspx

<GroupByExpressions>

<telerik:GridGroupByExpression>

<SelectFields>

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

</SelectFields>

<GroupByFields>

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

</GroupByFields>

</telerik:GridGroupByExpression>

</GroupByExpressions>

Here is the error

Field Reg not found in the source table. Please check the expression syntax.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: Telerik.Web.UI.GridGroupByException: Field Reg not found in the source table. Please check the expression syntax.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[GridGroupByException: Field Reg not found in the source table. Please check the expression syntax.]

Telerik.Web.UI.GridDataSetHelper.CreateGroupByTable(DataTable SourceTable, GridTableView view) +376

Telerik.Web.UI.GridEnumerableFromDataView.PerformTransformation() +2699

Telerik.Web.UI.GridEnumerableFromDataView.TransformEnumerable() +21

Telerik.Web.UI.GridTableView.GetEnumerator(Boolean useDataSource, GridEnumerableBase resolvedDataSource, ArrayList dataKeysArray) +105

Telerik.Web.UI.GridTableView.CreateControlHierarchy(Boolean useDataSource) +169

Telerik.Web.UI.GridTableView.CreateChildControls(IEnumerable dataSource, Boolean useDataSource) +499

System.Web.UI.WebControls.CompositeDataBoundControl.PerformDataBinding(IEnumerable data) +57

System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data) +114

System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +31

System.Web.UI.WebControls.DataBoundControl.PerformSelect() +142

Telerik.Web.UI.GridTableView.PerformSelect() +4

System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +73

Telerik.Web.UI.GridTableView.DataBind() +238

Telerik.Web.UI.RadGrid.DataBind() +80

Telerik.Web.UI.RadGrid.AutoDataBind(GridRebindReason rebindReason) +2122

Telerik.Web.UI.RadGrid.OnLoad(EventArgs e) +121

System.Web.UI.Control.LoadRecursive() +50

System.Web.UI.Control.LoadRecursive() +141

System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627

This column displays the reg data just fine

<telerik:GridBoundColumn DataField="Reg" HeaderText="Reg">

I get this error no matter what field in my underlying data I try and group by

thsnks for your help

Grid

answered on 12 Nov 2012

1 answer

66 views

Enhanced footers when you expand a detail table

Hello
I am using a fairly old version of rad controls for asp.net ajax (Q3 2008).
I have a master detail grid. In the footer I am showing some basic aggregate details (which I am actually having to calculate manually as the built in aggregates aren't working properly but thats another story) and I am displaying them in the footer by adding literal controls to get a multiline display:

Protected Sub gridJourneys_ItemDataBound(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridItemEventArgs) Handles gridJourneys.ItemDataBound

If e.Item.OwnerTableView.Name = "Journeys" Then

If TypeOf e.Item Is GridDataItem Then

Dim dataItem As GridDataItem = CType(e.Item, GridDataItem)

Dim x As TimeSpan = TimeSpan.Parse(dataItem("IdlingTime").Text)

idlingTime = (idlingTime + x)

Dim y As Double = Double.Parse(dataItem("DistanceTravelled").Text)

distanceTravelled = (distanceTravelled + y)

Dim z As TimeSpan = TimeSpan.Parse(dataItem("TimeTaken").Text)

timeTaken = (timeTaken + z)

ElseIf TypeOf e.Item Is GridFooterItem Then

Dim footerItem As GridFooterItem = CType(e.Item, GridFooterItem)

footerItem("DistanceTravelled").Text = distanceTravelled.ToString("F2")

'footerItem("TimeTaken").Text = timeTaken.ToString

footerItem("TimeTaken").Controls.Add(New LiteralControl("Total: " & timeTaken.ToString & "<br/>"))

footerItem("TimeTaken").Controls.Add(New LiteralControl("Idling: " & idlingTime.ToString))

End If

The footer displays fine when the grid first loads but if I expand a row in the table to show the details table then the footer information for TimeTaken column (which was created using literal controls) is lost. The DistanceTravelled column is fine

thanks

Grid

answered on 12 Nov 2012

4 answers

187 views

How To Test Whether Upload/Download Was Successful

Hi,

I am using the FileExplorer and I have EnableAsyncUpload set to true. I have also applied these modifications so that the Open menu option will always force a download.

With the Telerik AsynchUpload control, I can use the OnClientValidationFailed to verify the status of an upload. I need to be able to do this when clicking the Upload toolbar button within FileExplorer. But I don’t want to validate a “failed” upload; I want to validate a “successful” upload.

And I’m not sure that either test can be preformed when forcing a download, since I am actually invoking my browser’s “Save As” feature, as opposed to a Telerik download feature.

Any suggestions?
Thanks,
Steven

FileExplorer

answered on 12 Nov 2012

5 answers

200 views

Search in Two Column

Hello

I use an Object DataSource to load in my RadAutoCompleteBox.

My table has 3 columns : ID , TEXT1 , TEXT2

I would like the user can search on the TEXT1 and also the TEXT2 ,

i search in the City table, we have Zip code and City name , and if we can search on the third column
it'll be great.

Have you an solution ?

Thanks
Olivier,

<SFWeb:WebBusinessBindingSource runat="server" ID="WbAffaires" BusinessObjectName="oAffairesBo"></SFWeb:WebBusinessBindingSource>

<telerik:RadAutoCompleteBox runat="server" ID="RadAutoCompleteBox1" Width="340" DataSourceID="WbAffaires" Filter="StartsWith" CssClass="RadAutoCompleteBox_Default"
DropDownWidth="300px" DataTextField="CityColumn" DataValueField="ZipCodeColumn" InputType="Token" Delimiter="," EmptyMessage="Ville, CP ou département.">
</telerik:RadAutoCompleteBox>

AutoCompleteBox

answered on 12 Nov 2012

1 answer

66 views

Shifting the point on a point chart

I have a point chart along with a bar chart.

I have configured the points to be a rectangle. ( more of a line )

The point starts at the center and goes right. I need to shift the line over so it is centered on the bar.

See attached image.

Andy

Chart (Obsolete)

answered on 12 Nov 2012

1 answer

42 views

Active button in IE8

Here is yet another issue with IE and the form decorator 2012 Q3 release, if a button has been clicked then it screws up the style. The button's border disappears (except for the right-border).

It works correctly in compatibility view, however.

It seems to affect any page where the button does not redirect/refresh.

FormDecorator

answered on 12 Nov 2012

2 answers

52 views

Drop down styling question

I've read and tried to emulate the tutorials but for the life of me it doesn't seem to be working... I'd be very grateful if someone could point me in the right direction.

I'd like to style the drop down content of my comboboxes, mainly to give me a larger target when using touch in a browser, i.e: larger font and cell size if that needs to be set independantly. Can someone give me a Reader's Digest version of the necessary CSS selectors?
I'm using the default skin btw.

Much obliged for any assistance.

Paul

EDIT:

Solved it by adding " !important " to my CSS

ComboBox

answered on 12 Nov 2012

4 answers

45 views

Formdecorator fails on GridDateTimeColumn Filtercolumn with IE8

I have this column in a grid:
<telerik:GridDateTimeColumn DataField="empfangen" HeaderText="Empfangen" SortExpression="empfangen" UniqueName="empfangen" DataType="System.DateTime" ShowFilterIcon="False" ReadOnly="True" AllowFiltering="True" />
and i must disable the filtering calendar -> AllowFiltering="False" with Formdecorator turned on and using IE8.
(no problem with IE7 or 9 or FF)
Error is Javascript error on line 276 of RadFormDecorator.js -> 'r.height=n+"px";'

Versioninfo: Telerik.Web.UI, v.2012.3.1016.40 (Dev) [Download] (UI Language mostly German)

does any other out there have this problem? is it possible to turn of filter for IE8 only?

regards Marcel

FormDecorator

answered on 12 Nov 2012

3 answers

65 views

Nesting WebContol forms

I have a radgrid with a webusercontrol as the form.. in that form, there is another radgrid with yet another webusercontrol as the form... when i go into edit mode in that one, I want to make the (update/cancel) buttons disappear from the first one... How can I do this?

https://www.evernote.com/shard/s9/sh/da95d18c-b3ac-4e2b-89b4-17f9e91951d6/fa7c7ca22fdc41ec37bda2d9816211d5/res/bcfe8a11-1275-4510-9756-dbf32ee22dcf/skitch.png

Grid

answered on 12 Nov 2012

2 answers

80 views

Problems when using RadGrid in <asp:UpdatePannel>

Hello everyone!
I have a problem. When I use RadGrid in UpdatePannel, It performance some unexpect exception.
e.g, When the grid runs "SortCommand", the "SortOrder" can not be change (e.NewSortOrder=Ascending{1}). I click the sort button in header again and again it still keep ascending order.

<asp:UpdatePanel ID="upnlLeaveHistory" runat="server" UpdateMode="Conditional">

<ContentTemplate>

………………

<telerik:RadGrid ID="rgLeaveHistory" runat="server">

<MasterTableView>

<Columns>

<telerik:GridTemplateColumn DataField="Remarks">

<HeaderTemplate>