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.
Unfortunately, activation email could not send to your email. Please try again.

GridGroupingControl: how to cover columns of a single from the parent table

Thread ID:

Created:

Updated:

Platform:

Replies:

49981 Oct 3,2006 02:25 AM Oct 12,2006 12:17 AM Windows Forms 9
loading
Tags: GridControl
UBS
Asked On October 3, 2006 02:25 AM

Using GridGroupingControl: i want the result as in the attached doc.

Thanks
Vivek

test45.zip

Administrator [Syncfusion]
Replied On October 3, 2006 04:55 AM

Hi Vivek,

Please refer to the attached sample which demonstrates the way to add the summary row descriptor in the grid. Kindly try it and let us know if you need any further assistance.

Sample : http://www.syncfusion.com/Support/user/uploads/GGCSummary_344681fa.zip

Best Regards,
Haneef

UBS
Replied On October 4, 2006 06:46 AM

Hi,
Thanks for solution, one more problem, Summary Row Title is not coming properly. which property have to set.
also can refer attachment to see problem.

>Hi Vivek,

Please refer to the attached sample which demonstrates the way to add the summary row descriptor in the grid. Kindly try it and let us know if you need any further assistance.

Sample : http://www.syncfusion.com/Support/user/uploads/GGCSummary_344681fa.zip

Best'>http://www.syncfusion.com/Support/user/uploads/GGCSummary_344681fa.zip''>http://www.syncfusion.com/Support/user/uploads/GGCSummary_344681fa.zip

Best Regards,
Haneef

summary0.zip

Administrator [Syncfusion]
Replied On October 4, 2006 09:00 AM

Hi Vivek,

You can handle the QueryCoveredRange event and set the covered range for the summary cell. Below is a code snippet

//Form load event..
this.grid.TableModel.QueryCoveredRange +=new GridQueryCoveredRangeEventHandler(TableModel_QueryCoveredRange);

private void TableModel_QueryCoveredRange(object sender, GridQueryCoveredRangeEventArgs e)
{
GridTableModel model = sender as GridTableModel;
Element el = model.Table.DisplayElements[e.RowIndex];

if( el.Kind == DisplayElementKind.Summary )
{
GridSummaryRow row = el as GridSummaryRow;
int index = row.SummaryRowDescriptor.SummaryColumns[0].ColInRecord;
GridTableCellStyleInfo info = model[e.RowIndex,e.ColIndex] as GridTableCellStyleInfo;

if( info.TableCellIdentity.TableCellType == GridTableCellType.SummaryTitleCell)
{
e.Range = GridRangeInfo.Cells(e.RowIndex,e.ColIndex ,e.RowIndex,e.ColIndex + index - 1);
e.Handled = true;
}
}
}

Sample : http://www.syncfusion.com/Support/user/uploads/GGCSummary_e60b68e7.zip

Best Regards,
Haneef

UBS
Replied On October 10, 2006 12:05 AM

there is 3 queries:

query 1: Negative values are coming for "TotalOutright" column, i don''t want values like {97,731} but -93,731.
i m doing like this: pls see below code
GridColumnDescriptor col = new GridColumnDescriptor();

col.Name = name;
col.HeaderText = displayText;
col.MappingName = mappingName;

col.Appearance.AnyRecordFieldCell.CellType = "Currency";
col.Appearance.AnyRecordFieldCell.HorizontalAlignment = GridHorizontalAlignment.Right;
col.Appearance.AnyRecordFieldCell.CurrencyEdit.CurrencySymbol = "";
col.Appearance.AnyRecordFieldCell.CurrencyEdit.CurrencyDecimalDigits = 0;
col.Appearance.AnyRecordFieldCell.CurrencyEdit.NegativeSign = "-";
col.Appearance.AnyRecordFieldCell.CurrencyEdit.CurrencyGroupSeparator = ",";

query 2: "TotalCollaterate" column cell values should be "blue" not black.
i am doing like this, pls see the below code, and i don''t want to use event "gridGroupingControl1_QueryCellStyleInfo"

GridColumnDescriptor col = new GridColumnDescriptor();

col.Name = name;
col.HeaderText = displayText;
col.MappingName = mappingName;

col.Appearance.AnyRecordFieldCell.CellType = "Currency";
col.Appearance.AnyRecordFieldCell.HorizontalAlignment = GridHorizontalAlignment.Right;
col.Appearance.AnyRecordFieldCell.CurrencyEdit.CurrencySymbol = "";
col.Appearance.AnyRecordFieldCell.CurrencyEdit.CurrencyDecimalDigits = 0;
col.Appearance.AnyRecordFieldCell.CurrencyEdit.NegativeSign = "-";
col.Appearance.AnyRecordFieldCell.CurrencyEdit.CurrencyGroupSeparator = ",";
col.Appearance.AnyRecordFieldCell.Control.ForeColor = Color.Blue;

query 3: In "RecDate" column, i made column type "datetime", but if there is null data coming for any row, it is showing 01-01-0001, i don''t want that if data is null nothing will come as well as i don''t want dropdown sign.
i am doing like this: pls see below code and i don''t want to use event "gridGroupingControl1_QueryCellStyleInfo"

GridColumnDescriptor col = new GridColumnDescriptor();

col.Name = name;
col.HeaderText = displayText;
col.MappingName = mappingName;

col.Appearance.AnyRecordFieldCell.Format = "dd-MM-yyyy";
col.Appearance.AnyRecordFieldCell.CellValueType = typeof (DateTime);
col.Appearance.AnyRecordFieldCell.HorizontalAlignment = GridHorizontalAlignment.Right;

untitled24.zip

Administrator [Syncfusion]
Replied On October 10, 2006 04:45 AM

Hi,

Query 1: NegativePattern

Use CurrencyEdit.CurrencyNegativePattern property specifies the pattern to use when the value is negative.
col.Appearance.AnyRecordFieldCell.CurrencyEdit.CurrencyNegativePattern = 1;

Query 2: ForeColor of the CurrencyEdit.

Use CurrencyEdit.NegativeColor property specifies the ForeColor to use when the value is negative.
col.Appearance.AnyRecordFieldCell.CurrencyEdit.NegativeColor = Color.Blue;

Use CurrencyEdit.PositiveColor property specifies the ForeColor to use when the value is positive.
col.Appearance.AnyRecordFieldCell.CurrencyEdit.PositiveColor = Color.Blue;

Query 3:

Try these code snippet to resolve this.

GridColumnDescriptor col = new GridColumnDescriptor();

col.Name = name;
col.HeaderText = displayText;
col.MappingName = mappingName;

col.Appearance.AnyRecordFieldCell.Format = "dd-MM-yyyy";
col.Appearance.AnyRecordFieldCell.CellType = "TextBox";
col.Appearance.AnyRecordFieldCell.CellValueType = typeof (DateTime);
col.Appearance.AnyRecordFieldCell.HorizontalAlignment = GridHorizontalAlignment.Right;

Best Regards,
Haneef

UBS
Replied On October 10, 2006 07:56 AM

Hi Haneef,

Thanks.. little more help..
i need linklable column for query 3. but only those record where value is not null

Query 3:

Try these code snippet to resolve this.

GridColumnDescriptor col = new GridColumnDescriptor();

col.Name = name;
col.HeaderText = displayText;
col.MappingName = mappingName;

col.Appearance.AnyRecordFieldCell.Format = "dd-MM-yyyy";
col.Appearance.AnyRecordFieldCell.CellType = "TextBox";
col.Appearance.AnyRecordFieldCell.CellValueType = typeof (DateTime);
col.Appearance.AnyRecordFieldCell.HorizontalAlignment = GridHorizontalAlignment.Right;

>Using GridGroupingControl: i want the result as in the attached doc.

Thanks
Vivek

test45.zip

Administrator [Syncfusion]
Replied On October 10, 2006 09:28 AM

Hi,

Please refer to the below attached sample for LinkLabel cell.
http://www.syncfusion.com/Support/user/uploads/GGCLink_45c6b655.zip

Thanks,
Haneef

UBS
Replied On October 11, 2006 07:25 AM

For "LinkLableCell" if data is coming null then it is populating 01/01/0001, it should not happen, pls suggest any solution without using event gridGroupingControl1_QueryCellStyleInfo
Thanks


>Using GridGroupingControl: i want the result as in the attached doc.

Thanks
Vivek

test45.zip

untitled25.zip

UBS
Replied On October 12, 2006 12:17 AM

Hello any body there


>For "LinkLableCell" if data is coming null then it is populating 01/01/0001, it should not happen, pls suggest any solution without using event gridGroupingControl1_QueryCellStyleInfo
Thanks


>Using GridGroupingControl: i want the result as in the attached doc.

Thanks
Vivek

test45.zip

untitled25.zip

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.

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.

;