This is a migrated thread and some comments may be shown as answers.

FrozenColumnsCount fails when using GridColumnGroup

9 Answers 229 Views

Grid

This is a migrated thread and some comments may be shown as answers.

9 Answers, 1 is accepted

answered on 25 Sep 2012, 12:58 PM

I tried that and it still doesn't work.

Here is a copy of my code below. I have tried changing the frozen column count from 1 to 5 and no differences. It appears that frozen columns doesn't work when adding multiline column headers (grouped column headers).

protected void Page_Load(object sender, EventArgs e)

{

decimal BookingManagerID = Convert.ToDecimal(Session["BookingManagerID"]);

RadGrid rgProjectView = new RadGrid();

rgProjectView.ItemDataBound += new GridItemEventHandler(rgProjectView_ItemDataBound);

rgProjectView.Skin = "";

rgProjectView.BorderStyle = BorderStyle.Solid;

rgProjectView.BorderWidth = Unit.Pixel(1);

rgProjectView.Width = Unit.Percentage(100);

rgProjectView.Height = Unit.Percentage(100);

rgProjectView.GridLines = GridLines.Both;

rgProjectView.AutoGenerateColumns = false;

rgProjectView.ClientSettings.Scrolling.AllowScroll = true;

rgProjectView.ClientSettings.Scrolling.FrozenColumnsCount = 2;

rgProjectView.ClientSettings.Scrolling.SaveScrollPosition = true;

rgProjectView.ClientSettings.Scrolling.UseStaticHeaders = true;

rgProjectView.ClientSettings.ClientEvents.OnGridCreated = "GridCreated";

rgProjectView.DataSource = BuildTreeTable(BookingManagerID);

rgProjectView.HeaderStyle.Width = Unit.Pixel(75);

GridBoundColumn boundColumn = new GridBoundColumn();

boundColumn.DataField = boundColumn.UniqueName = "DisplayColumn1";

boundColumn.HeaderText = "Project / Resources";

boundColumn.HeaderStyle.Font.Name = "Arial";

boundColumn.HeaderStyle.Font.Size = FontUnit.Point(8);

boundColumn.HeaderStyle.BackColor = System.Drawing.Color.FromArgb(242, 242, 242);

boundColumn.HeaderStyle.Width = Unit.Pixel(500);

rgProjectView.Columns.Add(boundColumn);

DateTime startDate = Classes.Dates.GetStartDate();

DateTime endDate = Classes.Dates.GetEndDate(startDate.AddYears(2));

DateTime nextStartDate = startDate;

string monthYear = string.Format("{0}{1}", nextStartDate.AddDays(2).Year, nextStartDate.AddDays(2).Month.ToString().PadLeft(2, '0'));

do

{

monthYear = string.Format("{0}{1}", nextStartDate.AddDays(2).Year, nextStartDate.AddDays(2).Month.ToString().PadLeft(2, '0'));

GridColumnGroup gcg = new GridColumnGroup();

gcg.Name = monthYear;

gcg.HeaderText = String.Format("{0}-{1}", nextStartDate.AddDays(2).ToString("MMMM"), nextStartDate.AddDays(2).Year);

gcg.HeaderStyle.HorizontalAlign = HorizontalAlign.Center;

gcg.HeaderStyle.Font.Name = "Arial";

gcg.HeaderStyle.Font.Size = FontUnit.Point(8);

gcg.HeaderStyle.BackColor = System.Drawing.Color.FromArgb(242, 242, 242);

rgProjectView.MasterTableView.ColumnGroups.Add(gcg);

nextStartDate = nextStartDate.AddMonths(1);

}

while (nextStartDate <= endDate);

nextStartDate = startDate;

for (int i = 0; i <= 104; i++)

{

boundColumn = new GridBoundColumn();

monthYear = string.Format("{0}{1}", nextStartDate.AddDays(2).Year, nextStartDate.AddDays(2).Month.ToString().PadLeft(2, '0'));

boundColumn.ColumnGroupName = monthYear;

boundColumn.HeaderStyle.Font.Name = "Arial";

boundColumn.HeaderStyle.Font.Size = FontUnit.Point(8);

boundColumn.HeaderStyle.BackColor = System.Drawing.Color.FromArgb(242, 242, 242);

boundColumn.ItemStyle.Font.Name = "Arial";

boundColumn.ItemStyle.Font.Size = FontUnit.Point(8);

boundColumn.ItemStyle.BackColor = System.Drawing.Color.FromArgb(242, 242, 242);

boundColumn.DataField = boundColumn.UniqueName = String.Format("{0}-{1}", nextStartDate.ToShortDateString(), nextStartDate.AddDays(6).ToShortDateString());

boundColumn.HeaderText = String.Format("{0}<br />{1}", nextStartDate.ToShortDateString(), nextStartDate.AddDays(6).ToShortDateString());

boundColumn.ItemStyle.HorizontalAlign = HorizontalAlign.Center;

boundColumn.HeaderStyle.HorizontalAlign = HorizontalAlign.Center;

boundColumn.DataFormatString = "{0:N2}";

rgProjectView.Columns.Add(boundColumn);

nextStartDate = nextStartDate.AddDays(7);

}

boundColumn = new GridBoundColumn();

boundColumn.DataField = boundColumn.UniqueName = "PARENT_ID";

boundColumn.Display = false;

rgProjectView.Columns.Add(boundColumn);

boundColumn = new GridBoundColumn();

boundColumn.DataField = boundColumn.UniqueName = "RESOURCE_ID";

boundColumn.Display = false;

rgProjectView.Columns.Add(boundColumn);

boundColumn = new GridBoundColumn();

boundColumn.DataField = boundColumn.UniqueName = "RESOURCE_LAST_NAME";

boundColumn.Display = false;

rgProjectView.Columns.Add(boundColumn);

boundColumn = new GridBoundColumn();

boundColumn.DataField = boundColumn.UniqueName = "RESOURCE_FIRST_NAME";

boundColumn.Display = false;

rgProjectView.Columns.Add(boundColumn);

rgProjectView.ClientSettings.Scrolling.FrozenColumnsCount = 2;

phGrid.Controls.Add(rgProjectView);

}

answered on 22 Nov 2012, 12:05 AM

Hi Pavlina,

When we are showing tens of columns in the RadGrid and we group the column headers using the multi column header feature of RadGrid, we can't use the Frozen Columns feature and we have to choose between using the frozen columns or the multi header columns. There must be a way to use both, otherwise the multi header column feature would only be used in cases where you have few columns. And if you have only few columns it doesn't make sense to group them.

Do you know whether Telerik is planning to remove the limitation regarding using frozen columns with multi column headers? Is it in your roadmap for the Q3 2012 SP1 or maybe Q4 2012? It can be accepted that you can't freeze grouped columns but you can have a first column which doesn't belong to any group and you may want to freeze it to make the grid more readable when scrolling horizontally...

Best,

Quattro