We don't always know how much real-time data a business application can handle, or how many rows will be returned by a particular query. The Details section of FlexReport ensures that we render one row per record in the dataset easily. Adding dynamic columns at runtime is another issue, though; we may not always know how many columns are in a database, and we might have a report with a variable layout, for instance. Here's a quick tutorial on how to add dynamic columns at runtime.



In this example, we're showing side-by-side comparisons of debit and credit for a country at a particular work site (Site1, Site2, etc.) Since we could add new sites at any time, we want to make sure the report can display all the appropriate columns.

1. Define field position and size dynamically.

First, calculate the width of new columns. I subtracted the caption field's width from the full report's width to find the available table width (GrosspageWidth). Since I've already dynamically generated the total number of sites (sitenumber), I can easily find the new width of each of the columns:

//Calculating the available Width to decide column's Width
double GrosspageWidth = c1FlexReport1.Layout.Width - tbNameCaption.Width - tbNumberCaption.Width - c1FlexReport1.Layout.MarginLeft - c1FlexReport1.Layout.MarginRight;
double fieldWidth = GrosspageWidth / (sitenumber * 2);

2. Loop through the values to create new columns.

Now that we have the column width, we can create a loop to generate one column per site:

for (int i = 1; i <= sitenumber; i++)
//Dynamic Columns
tbDebit = new Field();
tbDebit.Name = "Site" + (i).ToString() + "Debit";
tbDebit.Text = "Site" + i.ToString() + "Debit";
tbDebit.Left = tbNumberCaption.Width + tbNameCaption.Width + (fieldWidth * (i - 1) * 2);
tbDebit.Top = 0;
tbDebit.Width = fieldWidth;
tbDebit.Height = 0.3f * 1440;
tbDebit.Calculated = true;
tbDebit.Align = FieldAlignEnum.CenterMiddle;
tbDebit.Border = new C1.Win.C1Document.Border(15f, Color.Black, C1.Win.C1Document.DashStyle.Solid);
tbDebit.Font.Size = 12f;

tbCredit = new Field();
tbCredit.Name = "Site" + (i).ToString() + "Debit";
tbCredit.Text = "Site" + (i).ToString() + "Credit";
tbCredit.Left = tbNumberCaption.Width + tbNameCaption.Width + (fieldWidth * (i - 1) * 2) + fieldWidth;
tbCredit.Top = 0;
tbCredit.Width = fieldWidth;
tbCredit.Height = 0.3f * 1440;
tbCredit.Calculated = true;
tbCredit.Align = FieldAlignEnum.CenterMiddle;
tbCredit.Border = new C1.Win.C1Document.Border(15f, Color.Black, C1.Win.C1Document.DashStyle.Solid);
tbCredit.Font.Size = 12f;

That's all!

Working Sample