We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on : November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

GridGrouping GROUP BY

Thread ID:

Created:

Updated:

Platform:

Replies:

29126 May 17,2005 05:26 PM UTC May 25,2005 10:49 AM UTC WinForms 7
loading
Tags: Grouping
Luis Javier Mompart
Asked On May 17, 2005 05:26 PM UTC

hi there, iam trying to group a 1st normal form xml table, but without showing groups. i need to group under a repeating field, sum by another units field, we were trying summarizing, and we did but not seems very handy to deal with the group caption, is there any way ?

Administrator [Syncfusion]
Replied On May 18, 2005 12:39 AM UTC

I am not sure I totally understand what you want. Here is a sample that displays a grid with the records ordered as in a group with a summary row for each group, but no group captions or +/- cells showing. http://www.syncfusion.com/Support/user/uploads/GGC_DataSetMerge_540f86c7.zip

Luis Javier Mompart
Replied On May 18, 2005 09:09 AM UTC

>I am not sure I totally understand what you want. > >Here is a sample that displays a grid with the records ordered as in a group with a summary row for each group, but no group captions or +/- cells showing. > >http://www.syncfusion.com/Support/user/uploads/GGC_DataSetMerge_540f86c7.zip > > img1_4942.zip thanks for your reply, the file sent don''t suites our needs, so i''ll send you a bmp. the point is that: We need ''Referencia'' field replacement functionality and appearance exactly the same as ''descripción'', but we dont know how to make caption header ( the GREY one ) behaves like the White one. e.g. where is ''Referencia: 002727 - 2 items'' there has to be ''002727'' standard white good old grid cell style (with editing) dont know wheter if its possible or not, we try GroupCaptionRowHeaderCell, store object, setvalue method, but we failed.

Administrator [Syncfusion]
Replied On May 19, 2005 12:20 AM UTC

Try adding a QueryCellStyleInfo event handler and setting the properties of teh caption cells there. private void gridGroupingControl1_QueryCellStyleInfo(object sender, GridTableCellStyleInfoEventArgs e) { if(e.TableCellIdentity.TableCellType == GridTableCellType.GroupCaptionCell) { e.Style.CellType = "Static"; e.Style.BackColor = Color.White; } }

Luis Javier Mompart
Replied On May 19, 2005 03:11 PM UTC

>Try adding a QueryCellStyleInfo event handler and setting the properties of teh caption cells there. > >private void gridGroupingControl1_QueryCellStyleInfo(object sender, GridTableCellStyleInfoEventArgs e) >{ > if(e.TableCellIdentity.TableCellType == GridTableCellType.GroupCaptionCell) > { > e.Style.CellType = "Static"; > e.Style.BackColor = Color.White; > } >} > great, but need to edit groupcaptioncell, and get/set its value from ''Referencias'' column ( i see that TextBox inherits from Static, maybe i can state it behaves like a standard column ?¿) thanks in advance

Administrator [Syncfusion]
Replied On May 20, 2005 11:20 AM UTC

The problem with trying to edit these cells is that the grid is not set up to ''save'' edited cahnegs for caption cells. The content of these cells are dynamically provided on demand when they are needed. So you would have to come up with some ''datastore" to hold these edited values and provide them in QueryCellStyleInfo. Here is a forum thread that discusses this. It starts out discussing makeing summary rows editable, but later moves into making captions editable. http://www.syncfusion.com/Support/Forums/message.aspx?MessageID=18703

Luis Javier Mompart
Replied On May 23, 2005 05:25 PM UTC

>The problem with trying to edit these cells is that the grid is not set up to ''save'' edited cahnegs for caption cells. The content of these cells are dynamically provided on demand when they are needed. So you would have to come up with some ''datastore" to hold these edited values and provide them in QueryCellStyleInfo. > >Here is a forum thread that discusses this. It starts out discussing makeing summary rows editable, but later moves into making captions editable. > >http://www.syncfusion.com/Support/Forums/message.aspx?MessageID=18703 thanks for all !!! ill take a look. (we are currently check extrasection (RowFactory) to workaround, plus QueryCellStyleInfo).

Luis Javier Mompart
Replied On May 25, 2005 10:49 AM UTC

> > >>The problem with trying to edit these cells is that the grid is not set up to ''save'' edited cahnegs for caption cells. The content of these cells are dynamically provided on demand when they are needed. So you would have to come up with some ''datastore" to hold these edited values and provide them in QueryCellStyleInfo. >> >>Here is a forum thread that discusses this. It starts out discussing makeing summary rows editable, but later moves into making captions editable. >> >>http://www.syncfusion.com/Support/Forums/message.aspx?MessageID=18703 > > >thanks for all !!! ill take a look. > >(we are currently check extrasection (RowFactory) to workaround, plus QueryCellStyleInfo). > > I have an aditional question we''ve created RecordDetailsSection with CreateRecordDetails method. ¿how can we hide those details inside a group with code, but still available (for calcs in custom section) ?

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;