Hi Sahaja,

here are the answers

I am setting the DataSource at runtime

i.e

var cmd =new MySqlCommand("Select * from test"), _systemState.Connection);
var cb = new MySqlCommandBuilder(da);
da.Fill(payerActivityRptDataSet.results);

No Column Style has been aded

only style which is added is

this.resultsGrid.CalcManager = this.ultraCalcManager;
this.resultsGrid.DataMember = "results";
this.resultsGrid.DataSource = this.payerActivityRptDataSetBindingSource;
appearance16.BackColor = System.Drawing.Color.White;
appearance16.BackColor2 = System.Drawing.Color.FromArgb(((int)(((byte)(168)))), ((int)(((byte)(167)))), ((int)(((byte)(191)))));
appearance16.BackGradientStyle = Infragistics.Win.GradientStyle.ForwardDiagonal;
this.resultsGrid.DisplayLayout.Appearance = appearance16;

no layout file has been used

I am still not able figure it out why the group is showing but column is not added and doesn't show and although it shows the additional row column no the extereme left but again with blank values where as it has values

Hi Sahaja,

thanks for getting back but still its not able to do

I had tried all possible ways but still having problem..

let me update here the code behind

how I am binding to Dataset

payerActivityRptDataSet.results.Clear();
var cmd =
new MySqlCommand("CALL get_payeractivity_rpt (@curStartDate, @curEndDate, @prevStartDate, @prevEndDate)", _systemState.Connection);
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@curStartDate", startDateTimeEditor.DateTime.Date);
cmd.Parameters.AddWithValue("@curEndDate", endDateTimeEditor.DateTime.Date.AddDays(1));
cmd.Parameters.AddWithValue("@prevStartDate", startDateTimeEditor.DateTime.Date.AddYears(-1));
cmd.Parameters.AddWithValue("@prevEndDate", endDateTimeEditor.DateTime.Date.AddDays(1).AddYears(-1));
var da = new MySqlDataAdapter(cmd);
var cb = new MySqlCommandBuilder(da);
da.Fill(payerActivityRptDataSet.results);

Here is the Designer.cs

Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn59 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("Units", -1, null, 956897496, 1, 0);

Infragistics.Win.UltraWinGrid.UltraGridGroup ultraGridGroup15 = new Infragistics.Win.UltraWinGrid.UltraGridGroup("Units", 956897496);

Adding into Band

ultraGridColumn59.Header.Caption = "Units";
ultraGridColumn59.Width = 75;

ultraGridBand1.Columns.AddRange(new object[]
{
ultraGridColumn1,
ultraGridColumn2,
ultraGridColumn3,
ultraGridColumn4,
ultraGridColumn5,
ultraGridColumn6,
ultraGridColumn7,
ultraGridColumn8,
ultraGridColumn9,
ultraGridColumn10,
ultraGridColumn11,
ultraGridColumn12,
ultraGridColumn13,
ultraGridColumn14,
ultraGridColumn15,
ultraGridColumn16,
ultraGridColumn17,
ultraGridColumn18,
ultraGridColumn19,
ultraGridColumn20,
ultraGridColumn21,
ultraGridColumn22,
ultraGridColumn23,
ultraGridColumn24,
ultraGridColumn25,
ultraGridColumn26,
ultraGridColumn27,
ultraGridColumn57,
ultraGridColumn58, ultraGridColumn59
});

Adding into Group

ultraGridGroup15.Header.VisiblePosition = 14;
ultraGridGroup15.Key = "Units";

ultraGridBand1.Groups.AddRange(new Infragistics.Win.UltraWinGrid.UltraGridGroup[]
{
ultraGridGroup1,
ultraGridGroup2,
ultraGridGroup3,
ultraGridGroup4,
ultraGridGroup5,
ultraGridGroup6,
ultraGridGroup7,
ultraGridGroup8,
ultraGridGroup9,
ultraGridGroup10,
ultraGridGroup11,
ultraGridGroup12,
ultraGridGroup13,
ultraGridGroup14, ultraGridGroup15
});

now doing this it shows the Group but when I get the data its now showing the Units Column