I am using WPF - Telerik reporting.in this i have taken Table in detail section having 7 columns. but when i am binding that table by Data Table,ii's showing nothing in detail section. it's running without any error.so i have tried with static data to table row. but that also doesn't make any effect.i am getting only Header & Footer section in Report. not getting dynamic Table data,not even static data also.
please Help me.
Thanx in advance.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
#region "Private Variable"
private readonly ILog log = LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
private decimal _subTotal=0;
private decimal _grandTotal=0;
#endregion
#region "Public Variable"
#endregion
#region "Constructor"
public AnnualBudgetReport()
{
}
#endregion
#region "Private Methods"
#region "Header Section"
/// <summary>
/// This method is used to retrieve Header section panel.
/// </summary>
/// <returns>This method returns header panel.</returns>
private Panel GetHeaderPanel()
{
Panel headerPanel = new Panel();
try
{
headerPanel.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(3.9378803194267675E-05D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.080000005662441254D, Telerik.Reporting.Drawing.UnitType.Inch));
headerPanel.Name = "headerPanel";
headerPanel.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(7.1999998092651367D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.5D, Telerik.Reporting.Drawing.UnitType.Inch));
headerPanel.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))));
headerPanel.Items.AddRange(new Telerik.Reporting.ReportItemBase[]
{
GetMainHeader("Budget - Annual report"),
GetSubHeaderPanel("For 52 weeks, starting Monday","8/5/2011",":: Today's date","8/1/2011")
});
return headerPanel;
}
catch (Exception ex)
{
if (log.IsErrorEnabled)
log.Error("[" + System.DateTime.Now.ToString() + "] AnnualBudgetReport::GetHeaderPanel ", ex);
throw;
}
}
/// <summary>
/// This method is used to retrieve Main header text.
/// </summary>
/// <param name="MainHeaderText">This parameter is the main header title of report.</param>
/// <returns> This method returns header title textbox.</returns>
private TextBox GetMainHeader(string MainHeaderText)
{
TextBox txtHeaderTitle = new TextBox();
try
{
// txtHeaderTitle
//
txtHeaderTitle.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(2.4999606609344482D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(3.9339065551757812E-05D, Telerik.Reporting.Drawing.UnitType.Inch));
txtHeaderTitle.Name = "txtHeaderTitle";
txtHeaderTitle.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(2D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000004768371582D, Telerik.Reporting.Drawing.UnitType.Inch));
txtHeaderTitle.Style.Font.Bold = true;
txtHeaderTitle.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(12D, Telerik.Reporting.Drawing.UnitType.Point);
txtHeaderTitle.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
txtHeaderTitle.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
txtHeaderTitle.Value = MainHeaderText;
//
return txtHeaderTitle;
}
catch (Exception ex)
{
if (log.IsErrorEnabled)
log.Error("[" + System.DateTime.Now.ToString() + "] AnnualBudgetReport::GetMainHeader ", ex);
throw;
}
}
/// <summary>
/// Thiis method is sed to retrieve sub header panel.
/// </summary>
/// <param name="subHeaderTitle">This parameter is the sub header title.</param>
/// <param name="todayDate">This parameter is the Today date for report.</param>
/// <param name="todayDateText">This parameter is the today date text.</param>
/// <param name="budgetStartDate">This parameter is the budget start date.</param>
/// <returns>This method returns sub header panel.</returns>
private Panel GetSubHeaderPanel(string subHeaderTitle, string todayDate, string todayDateText, string budgetStartDate)
{
Panel subHeaderPanel = new Panel();
TextBox txtReportTitleDetail = new TextBox();
TextBox txtTodayDate = new TextBox();
TextBox txtTodayDateText = new TextBox();
TextBox txtBudgetStartDate = new TextBox();
try
{
// subHeaderPanel
//
subHeaderPanel.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(1.2999999523162842D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.2199999988079071D, Telerik.Reporting.Drawing.UnitType.Inch));
subHeaderPanel.Name = "pnlsubHeader";
subHeaderPanel.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(4.5999999046325684D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.25D, Telerik.Reporting.Drawing.UnitType.Inch));
subHeaderPanel.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
subHeaderPanel.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
//
// txtReportTitleDetail
//
txtReportTitleDetail.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch));
txtReportTitleDetail.Name = "txtReportTitleDetail";
txtReportTitleDetail.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(2D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000004768371582D, Telerik.Reporting.Drawing.UnitType.Inch));
txtReportTitleDetail.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(10D, Telerik.Reporting.Drawing.UnitType.Point);
txtReportTitleDetail.Value = subHeaderTitle;//"For 52 weeks, starting Monday";
//
// txtTodayDate
//
txtTodayDate.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(3.6000001430511475D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch));
txtTodayDate.Name = "txtTodayDate";
txtTodayDate.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.7999998927116394D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000004768371582D, Telerik.Reporting.Drawing.UnitType.Inch));
txtTodayDate.Value = todayDate;// "8/5/2011";
//
// txtTodayDateText
//
txtTodayDateText.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(2.6000001430511475D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch));
txtTodayDateText.Name = "txtTodayDateText";
txtTodayDateText.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000004768371582D, Telerik.Reporting.Drawing.UnitType.Inch));
txtTodayDateText.Value = todayDateText;// ":: Today's date";
//
// txtBudgetStartDate
//
txtBudgetStartDate.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(2.0000002384185791D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch));
txtBudgetStartDate.Name = "txtBudgetStartDate";
txtBudgetStartDate.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.60000008344650269D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000004768371582D, Telerik.Reporting.Drawing.UnitType.Inch));
txtBudgetStartDate.Value = budgetStartDate;// "8/1/2011";
//
subHeaderPanel.Items.AddRange(new Telerik.Reporting.ReportItemBase[]
{
txtReportTitleDetail,
txtTodayDate,
txtTodayDateText,
txtBudgetStartDate
});
return subHeaderPanel;
}
catch (Exception ex)
{
if (log.IsErrorEnabled)
log.Error("[" + System.DateTime.Now.ToString() + "] AnnualBudgetReport::GetSubHeaderPanel ", ex);
throw;
}
}
/// <summary>
/// This method is used to retrieve Report header section.
/// </summary>
/// <returns>This method returns report header aection.</returns>
private PageHeaderSection GetReportHeaderSection()
{
PageHeaderSection reportHeaderSection = new PageHeaderSection();
try
{
// AnnualBudgetReportHeader
reportHeaderSection.Height = new Telerik.Reporting.Drawing.Unit(0.019999999552965164D, Telerik.Reporting.Drawing.UnitType.Inch);
reportHeaderSection.Name = "AnnualBudgetReportHeader";
reportHeaderSection.Style.BackgroundColor = System.Drawing.Color.White;
//
return reportHeaderSection;
}
catch (Exception ex)
{
if (log.IsErrorEnabled)
log.Error("[" + System.DateTime.Now.ToString() + "] AnnualBudgetReport::GetReportHeaderSection ", ex);
throw;
}
finally
{
//if (reportHeaderSection != null)
// reportHeaderSection = null;
}
}
#endregion
#region "Detail Section"
/// <summary>
/// This method is used to retrieve report detail section's income detail.
/// </summary>
/// <param name="Description"></param>
/// <param name="Frequency"></param>
/// <param name="StartDate"></param>
/// <param name="EndDate"></param>
/// <param name="Income"></param>
/// <param name="Outgoing"></param>
/// <param name="AnnualAmount"></param>
/// <param name="SubTotal"></param>
/// <returns>This method returns Report detail income section.</returns>
//private Panel GetDetailIncomeSection()
//{
// #region "Declaration"
// Panel incomePanel = new Panel();
// Table incomeTable = new Table();
// TableGroup tableGroupFirst = new TableGroup();
// TableGroup tableGroupSecond = new TableGroup();
// TableGroup tableGroupThird = new TableGroup();
// TableGroup tableGroupFourth = new TableGroup();
// TableGroup tableGroupFifth = new TableGroup();
// TableGroup tableGroupSixth = new TableGroup();
// TableGroup tableGroupSeventh = new TableGroup();
// TableGroup tableGroupEightth = new TableGroup();
// //int initialCount = 0;
// //int columnHeaderCount = 7;
// //const double rowHeight = 0.2;
// //double width = 7.26D;
// //int rowCount = 0;
// TextBox txtIncomeText = new TextBox();
// TextBox txtIncomeDescriptionColumn = new TextBox();
// TextBox txtIncomeFrequencyColumn = new TextBox();
// TextBox txtIncomeStartDateColumn = new TextBox();
// TextBox txtIncomeEndDateColumn = new TextBox();
// TextBox txtIncomeIncomingColumn = new TextBox();
// TextBox txtIncomeOutgoingColumn = new TextBox();
// TextBox txtIncomeAnnualAmountColumn = new TextBox();
// TextBox txtIncomeDescription = new TextBox();
// TextBox txtIncomeFrequency = new TextBox();
// TextBox txtIncomeStartDate = new TextBox();
// TextBox txtIncomeEndDate = new TextBox();
// TextBox txtIncomeIncoming = new TextBox();
// TextBox txtIncomeOutgoing = new TextBox();
// TextBox txtIncomeAnnualAmount = new TextBox();
// TextBox txtIncomeSubTotal = new TextBox();
// TextBox txtIncomeSubTotalText = new TextBox();
// #endregion
// try
// {
// //if (RowNum == 0)
// {
// //incomePanel
// incomePanel.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(3.9378803194267675E-05D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.880000114440918D, Telerik.Reporting.Drawing.UnitType.Inch));
// incomePanel.Name = "incomePanel";
// incomePanel.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(7.1999998092651367D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(1.3000000715255737D, Telerik.Reporting.Drawing.UnitType.Inch));
// // txtIncomeText
// txtIncomeText.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.019999999552965164D, Telerik.Reporting.Drawing.UnitType.Inch));
// txtIncomeText.Name = "txtIncomeText";
// txtIncomeText.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.0898698568344116D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19996054470539093D, Telerik.Reporting.Drawing.UnitType.Inch));
// txtIncomeText.Style.Font.Bold = true;
// txtIncomeText.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(12D, Telerik.Reporting.Drawing.UnitType.Point);
// txtIncomeText.Style.Font.Strikeout = false;
// txtIncomeText.Style.Font.Underline = true;
// txtIncomeText.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Left;
// txtIncomeText.Value = "Income";
// //incomePanel.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(LocY, Telerik.Reporting.Drawing.UnitType.Inch));
// //incomePanel.Name = "pnlIncomeDetail";
// //incomePanel.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(7.2604331970214844D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(1.5999208688735962D, Telerik.Reporting.Drawing.UnitType.Inch));
// //incomePanel.Style.BackgroundColor = System.Drawing.Color.White;
// //incomePanel.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.None;
// #region "Columns"
// // txtIncomeDescriptionColumn
// txtIncomeDescriptionColumn.Name = "txtIncomeDescriptionColumn";
// txtIncomeDescriptionColumn.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.3020833730697632D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
// txtIncomeDescriptionColumn.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))));
// txtIncomeDescriptionColumn.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
// txtIncomeDescriptionColumn.Style.BorderStyle.Left = Telerik.Reporting.Drawing.BorderType.Solid;
// txtIncomeDescriptionColumn.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
// txtIncomeDescriptionColumn.Style.Font.Bold = true;
// txtIncomeDescriptionColumn.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
// txtIncomeDescriptionColumn.Value = "Description";
// // txtIncomeStartDateColumn
// txtIncomeFrequencyColumn.Name = "txtIncomeFrequencyColumn";
// txtIncomeFrequencyColumn.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.92708373069763184D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
// txtIncomeFrequencyColumn.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))));
// txtIncomeFrequencyColumn.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
// txtIncomeFrequencyColumn.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
// txtIncomeFrequencyColumn.Style.Font.Bold = true;
// txtIncomeFrequencyColumn.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
// txtIncomeFrequencyColumn.Value = "Frequency";
// // txtIncomeEndDateColumn
// txtIncomeEndDateColumn.Name = "txtIncomeEndDateColumn";
// txtIncomeEndDateColumn.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.80208361148834229D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
// txtIncomeEndDateColumn.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))));
// txtIncomeEndDateColumn.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
// txtIncomeEndDateColumn.Style.BorderStyle.Right = Telerik.Reporting.Drawing.BorderType.None;
// txtIncomeEndDateColumn.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
// txtIncomeEndDateColumn.Style.Font.Bold = true;
// txtIncomeEndDateColumn.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
// txtIncomeEndDateColumn.StyleName = "";
// txtIncomeEndDateColumn.Value = "End Date";
// // txtIncomeIncomingColumn
// txtIncomeIncomingColumn.Anchoring = Telerik.Reporting.AnchoringStyles.Left;
// txtIncomeIncomingColumn.Name = "txtIncomeIncomingColumn";
// txtIncomeIncomingColumn.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
// txtIncomeIncomingColumn.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))));
// txtIncomeIncomingColumn.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
// txtIncomeIncomingColumn.Style.BorderStyle.Right = Telerik.Reporting.Drawing.BorderType.None;
// txtIncomeIncomingColumn.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
// txtIncomeIncomingColumn.Style.Font.Bold = true;
// txtIncomeIncomingColumn.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
// txtIncomeIncomingColumn.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Top;
// txtIncomeIncomingColumn.StyleName = "";
// txtIncomeIncomingColumn.Value = "Income";
// // txtIncomeOutgoingColumn
// txtIncomeOutgoingColumn.Anchoring = Telerik.Reporting.AnchoringStyles.Left;
// txtIncomeOutgoingColumn.Name = "txtIncomeOutgoingColumn";
// txtIncomeOutgoingColumn.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
// txtIncomeOutgoingColumn.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))));
// txtIncomeOutgoingColumn.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
// txtIncomeOutgoingColumn.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
// txtIncomeOutgoingColumn.Style.Font.Bold = true;
// txtIncomeOutgoingColumn.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
// txtIncomeOutgoingColumn.StyleName = "";
// txtIncomeOutgoingColumn.Value = "Outgoing";
// // txtIncomeAnnualAmountColumn
// txtIncomeAnnualAmountColumn.Name = "txtIncomeAnnualAmountColumn";
// txtIncomeAnnualAmountColumn.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.3125003576278687D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
// txtIncomeAnnualAmountColumn.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))));
// txtIncomeAnnualAmountColumn.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
// txtIncomeAnnualAmountColumn.Style.BorderStyle.Right = Telerik.Reporting.Drawing.BorderType.Solid;
// txtIncomeAnnualAmountColumn.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
// txtIncomeAnnualAmountColumn.Style.Font.Bold = true;
// txtIncomeAnnualAmountColumn.StyleName = "";
// txtIncomeAnnualAmountColumn.Value = "Annual Amount";
// }
// // incomeTable
// //
// incomeTable.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(1.3020836114883423D, Telerik.Reporting.Drawing.UnitType.Inch)));
// incomeTable.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(0.92708367109298706D, Telerik.Reporting.Drawing.UnitType.Inch)));
// incomeTable.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(0.84374964237213135D, Telerik.Reporting.Drawing.UnitType.Inch)));
// incomeTable.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(0.80208379030227661D, Telerik.Reporting.Drawing.UnitType.Inch)));
// incomeTable.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(1.0000001192092896D, Telerik.Reporting.Drawing.UnitType.Inch)));
// incomeTable.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(1.0000001192092896D, Telerik.Reporting.Drawing.UnitType.Inch)));
// incomeTable.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(1.3125002384185791D, Telerik.Reporting.Drawing.UnitType.Inch)));
// incomeTable.Body.Rows.Add(new Telerik.Reporting.TableBodyRow(new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch)));
// incomeTable.Body.SetCellContent(0, 0, txtIncomeDescription);
// incomeTable.Body.SetCellContent(0, 1, txtIncomeFrequency);
// incomeTable.Body.SetCellContent(0, 2, txtIncomeStartDate);
// incomeTable.Body.SetCellContent(0, 3, txtIncomeEndDate);
// incomeTable.Body.SetCellContent(0, 4, txtIncomeIncoming);
// incomeTable.Body.SetCellContent(0, 5, txtIncomeOutgoing);
// incomeTable.Body.SetCellContent(0, 6, txtIncomeAnnualAmount);
// tableGroupFirst.ReportItem = txtIncomeDescriptionColumn;
// tableGroupSecond.ReportItem = txtIncomeFrequencyColumn;
// tableGroupThird.ReportItem = txtIncomeStartDateColumn;
// //tableGroupFourth.Name = "Group1";
// tableGroupFourth.ReportItem = txtIncomeEndDateColumn;
// //tableGroupFifth.Name = "Group2";
// tableGroupFifth.ReportItem = txtIncomeIncomingColumn;
// //tableGroupSixth.Name = "Group3";
// tableGroupSixth.ReportItem = txtIncomeOutgoingColumn;
// //tableGroupSeventh.Name = "Group4";
// tableGroupSeventh.ReportItem = txtIncomeAnnualAmountColumn;
// incomeTable.ColumnGroups.Add(tableGroupFirst);
// incomeTable.ColumnGroups.Add(tableGroupSecond);
// incomeTable.ColumnGroups.Add(tableGroupThird);
// incomeTable.ColumnGroups.Add(tableGroupFourth);
// incomeTable.ColumnGroups.Add(tableGroupFifth);
// incomeTable.ColumnGroups.Add(tableGroupSixth);
// incomeTable.ColumnGroups.Add(tableGroupSeventh);
// DataTable dt = new DataTable();
// dt.Columns.Add("Description", typeof(string));
// dt.Columns.Add("Frequency", typeof(string));
// dt.Columns.Add("StartDate", typeof(string));
// dt.Columns.Add("EndDate", typeof(string));
// dt.Columns.Add("Income", typeof(string));
// dt.Columns.Add("Outgoing", typeof(string));
// dt.Columns.Add("AnnualAmount", typeof(string));
// dt.Columns.Add("Last", typeof(string));
// for (int i = 0; i < 5; i++)
// {
// dt.Rows.Add(i.ToString(), i.ToString(), i.ToString(), i.ToString(), i.ToString(), i.ToString(), i.ToString(),"Last");
// }
// DataSet ds = new DataSet();
// ds.Tables.Add(dt);
// // incomeTable.DataSource = ds;
// //incomeTable.DataSource = getDataSource("income");
// incomeTable.Items.AddRange(new Telerik.Reporting.ReportItemBase[]
// {
// txtIncomeDescription,
// txtIncomeFrequency,
// txtIncomeStartDate,
// txtIncomeEndDate,
// txtIncomeIncoming,
// txtIncomeOutgoing,
// txtIncomeAnnualAmount,
// txtIncomeDescriptionColumn,
// txtIncomeFrequencyColumn,
// txtIncomeStartDateColumn,
// txtIncomeEndDateColumn,
// txtIncomeIncomingColumn,
// txtIncomeOutgoingColumn,
// txtIncomeAnnualAmountColumn
// });
// incomeTable.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(3.929932790924795E-05D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.2800000011920929D, Telerik.Reporting.Drawing.UnitType.Inch));
// incomeTable.Name = "incomeTable";
// tableGroupEightth.Groupings.AddRange(new Telerik.Reporting.Data.Grouping[]
// {
// new Telerik.Reporting.Data.Grouping("")
// });
// tableGroupEightth.Name = "DetailGroup";
// incomeTable.RowGroups.Add(tableGroupEightth);
// incomeTable.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(7.187502384185791D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.40000000596046448D, Telerik.Reporting.Drawing.UnitType.Inch));
// #region "Rows"
// // txtIncomeDescription
// txtIncomeDescription.Name = "txtIncomeDescription";
// txtIncomeDescription.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.3020833730697632D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
// txtIncomeDescription.Value = "A";//"= Fields.Description";
// // txtIncomeFrequency
// txtIncomeFrequency.Name = "txtIncomeFrequency";
// txtIncomeFrequency.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.92708373069763184D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
// txtIncomeFrequency.Value = "A";//"= Fields.Frequency";
// // txtIncomeStartDate
// txtIncomeStartDate.Name = "txtIncomeStartDate";
// txtIncomeStartDate.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.80208361148834229D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
// txtIncomeStartDate.Value = "A";//"= Fields.StartDate";
// // txtIncomeEndDate
// txtIncomeEndDate.Name = "txtIncomeEndDate";
// txtIncomeEndDate.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.80208361148834229D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
// txtIncomeEndDate.Value = "A";//"= Fields.EndDate";
// // txtIncomeIncoming
// txtIncomeIncoming.Name = "txtIncomeIncoming";
// txtIncomeIncoming.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
// txtIncomeIncoming.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
// txtIncomeIncoming.Value = "A";//"= Fields.Income";//"=\'$\' + Fields.Income";
// // txtIncomeOutgoing
// txtIncomeOutgoing.Name = "txtIncomeOutgoing";
// txtIncomeOutgoing.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
// txtIncomeOutgoing.Value = "A";//"= Fields.Outgoing";
// // txtIncomeAnnualAmount
// txtIncomeAnnualAmount.Name = "txtIncomeAnnualAmount";
// txtIncomeAnnualAmount.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.3125003576278687D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
// txtIncomeAnnualAmount.Value = "A";//"= Fields.AnnualAmount";
// #endregion
// #region "SubTotal"
// //if (IsLast)
// {
// // txtIncomeSubTotal
// txtIncomeSubTotal.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(5.880000114440918D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.89999991655349731D, Telerik.Reporting.Drawing.UnitType.Inch));
// txtIncomeSubTotal.Name = "txtIncomeSubTotal";
// txtIncomeSubTotal.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.2800010442733765D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch));
// txtIncomeSubTotal.Style.Font.Bold = true;
// txtIncomeSubTotal.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(12D, Telerik.Reporting.Drawing.UnitType.Point);
// txtIncomeSubTotal.Value = "";//"=\'$\' + Fields.SubTotal";
// // txtIncomeSubTotalText
// txtIncomeSubTotalText.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(4.6399998664855957D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.89999991655349731D, Telerik.Reporting.Drawing.UnitType.Inch));
// txtIncomeSubTotalText.Name = "txtIncomeSubTOtalText";
// txtIncomeSubTotalText.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.0000003576278687D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch));
// txtIncomeSubTotalText.Style.Font.Bold = true;
// txtIncomeSubTotalText.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(12D, Telerik.Reporting.Drawing.UnitType.Point);
// txtIncomeSubTotalText.Value = "Sub Total :";
// }
// #endregion
// #region "Add Controls In panel"
// incomePanel.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
// txtIncomeText,
// incomeTable,
// txtIncomeSubTotalText,
// txtIncomeSubTotal,
// });
// #endregion
// #endregion
// return incomePanel;
// }
// catch (Exception ex)
// {
// if (log.IsErrorEnabled)
// log.Error("[" + System.DateTime.Now.ToString() + "] AnnualBudgetReport::GetDetailIncomeSection ", ex);
// throw;
// }
//}
//private Telerik.Reporting.PageHeaderSection pageHeaderSection1;
private Telerik.Reporting.DetailSection detail;
private Telerik.Reporting.PageFooterSection pageFooterSection1;
private Telerik.Reporting.Panel headerPanel;
private Telerik.Reporting.TextBox txtReportTitle;
private Telerik.Reporting.Panel pnlsubHeader;
private Telerik.Reporting.TextBox txtReportTitleDetail;
private Telerik.Reporting.TextBox txtTodayDate;
private Telerik.Reporting.TextBox txtTodayDateText;
private Telerik.Reporting.TextBox txtBudgetStartDate;
private Telerik.Reporting.Panel incomePanel;
private Telerik.Reporting.TextBox txtIncomeText;
private Telerik.Reporting.Table incomeTable;
private Telerik.Reporting.TextBox txtIncomeDescription;
private Telerik.Reporting.TextBox txtIncomeFrequency;
private Telerik.Reporting.TextBox txtIncomeStartDate;
private Telerik.Reporting.TextBox txtIncomeDescriptionColumn;
private Telerik.Reporting.TextBox txtIncomeFrequencyColumn;
private Telerik.Reporting.TextBox txtIncomeStartDateColumn;
private Telerik.Reporting.TextBox txtIncomeEndDate;
private Telerik.Reporting.TextBox txtIncomeIncoming;
private Telerik.Reporting.TextBox txtIncomeOutgoing;
private Telerik.Reporting.TextBox txtIncomeAnnualAmount;
private Telerik.Reporting.TextBox txtIncomeEndDateColumn;
private Telerik.Reporting.TextBox txtIncomeIncomingColumn;
private Telerik.Reporting.TextBox txtIncomeOutgoingColumn;
private Telerik.Reporting.TextBox txtIncomeAnnualAmountColumn;
private Telerik.Reporting.TextBox textBox2;
private Telerik.Reporting.TextBox textBox1;
private Telerik.Reporting.SqlDataSource sqlDataSource1;
private Panel GetDetailIncomeSection()
{
Panel incomePanel = new Panel();
Telerik.Reporting.TableGroup tableGroup1 = new Telerik.Reporting.TableGroup();
Telerik.Reporting.TableGroup tableGroup2 = new Telerik.Reporting.TableGroup();
Telerik.Reporting.TableGroup tableGroup3 = new Telerik.Reporting.TableGroup();
Telerik.Reporting.TableGroup tableGroup4 = new Telerik.Reporting.TableGroup();
Telerik.Reporting.TableGroup tableGroup5 = new Telerik.Reporting.TableGroup();
Telerik.Reporting.TableGroup tableGroup6 = new Telerik.Reporting.TableGroup();
Telerik.Reporting.TableGroup tableGroup7 = new Telerik.Reporting.TableGroup();
Telerik.Reporting.TableGroup tableGroup8 = new Telerik.Reporting.TableGroup();
this.txtIncomeDescriptionColumn = new Telerik.Reporting.TextBox();
this.txtIncomeFrequencyColumn = new Telerik.Reporting.TextBox();
this.txtIncomeStartDateColumn = new Telerik.Reporting.TextBox();
this.txtIncomeEndDateColumn = new Telerik.Reporting.TextBox();
this.txtIncomeIncomingColumn = new Telerik.Reporting.TextBox();
this.txtIncomeOutgoingColumn = new Telerik.Reporting.TextBox();
this.txtIncomeAnnualAmountColumn = new Telerik.Reporting.TextBox();
this.headerPanel = new Telerik.Reporting.Panel();
this.txtReportTitle = new Telerik.Reporting.TextBox();
this.pnlsubHeader = new Telerik.Reporting.Panel();
this.txtReportTitleDetail = new Telerik.Reporting.TextBox();
this.txtTodayDate = new Telerik.Reporting.TextBox();
this.txtTodayDateText = new Telerik.Reporting.TextBox();
this.txtBudgetStartDate = new Telerik.Reporting.TextBox();
this.incomePanel = new Telerik.Reporting.Panel();
this.txtIncomeText = new Telerik.Reporting.TextBox();
this.incomeTable = new Telerik.Reporting.Table();
this.txtIncomeDescription = new Telerik.Reporting.TextBox();
this.txtIncomeFrequency = new Telerik.Reporting.TextBox();
this.txtIncomeStartDate = new Telerik.Reporting.TextBox();
this.txtIncomeEndDate = new Telerik.Reporting.TextBox();
this.txtIncomeIncoming = new Telerik.Reporting.TextBox();
this.txtIncomeOutgoing = new Telerik.Reporting.TextBox();
this.txtIncomeAnnualAmount = new Telerik.Reporting.TextBox();
this.textBox2 = new Telerik.Reporting.TextBox();
this.textBox1 = new Telerik.Reporting.TextBox();
this.sqlDataSource1 = new Telerik.Reporting.SqlDataSource();
//
// txtIncomeDescriptionColumn
//
this.txtIncomeDescriptionColumn.Name = "txtIncomeDescriptionColumn";
this.txtIncomeDescriptionColumn.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.2999999523162842D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
this.txtIncomeDescriptionColumn.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))));
this.txtIncomeDescriptionColumn.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
this.txtIncomeDescriptionColumn.Style.BorderStyle.Left = Telerik.Reporting.Drawing.BorderType.Solid;
this.txtIncomeDescriptionColumn.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
this.txtIncomeDescriptionColumn.Style.Font.Bold = true;
this.txtIncomeDescriptionColumn.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
this.txtIncomeDescriptionColumn.Value = "Description";
//
// txtIncomeFrequencyColumn
//
this.txtIncomeFrequencyColumn.Name = "txtIncomeFrequencyColumn";
this.txtIncomeFrequencyColumn.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.92708373069763184D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
this.txtIncomeFrequencyColumn.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))));
this.txtIncomeFrequencyColumn.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
this.txtIncomeFrequencyColumn.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
this.txtIncomeFrequencyColumn.Style.Font.Bold = true;
this.txtIncomeFrequencyColumn.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
this.txtIncomeFrequencyColumn.Value = "Frequency";
//
// txtIncomeStartDateColumn
//
this.txtIncomeStartDateColumn.Name = "txtIncomeStartDateColumn";
this.txtIncomeStartDateColumn.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.84374964237213135D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
this.txtIncomeStartDateColumn.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))));
this.txtIncomeStartDateColumn.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
this.txtIncomeStartDateColumn.Style.BorderStyle.Right = Telerik.Reporting.Drawing.BorderType.None;
this.txtIncomeStartDateColumn.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
this.txtIncomeStartDateColumn.Style.Font.Bold = true;
this.txtIncomeStartDateColumn.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
this.txtIncomeStartDateColumn.Value = "Start Date";
//
// txtIncomeEndDateColumn
//
this.txtIncomeEndDateColumn.Name = "txtIncomeEndDateColumn";
this.txtIncomeEndDateColumn.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.80208361148834229D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
this.txtIncomeEndDateColumn.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))));
this.txtIncomeEndDateColumn.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
this.txtIncomeEndDateColumn.Style.BorderStyle.Right = Telerik.Reporting.Drawing.BorderType.None;
this.txtIncomeEndDateColumn.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
this.txtIncomeEndDateColumn.Style.Font.Bold = true;
this.txtIncomeEndDateColumn.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
this.txtIncomeEndDateColumn.StyleName = "";
this.txtIncomeEndDateColumn.Value = "End Date";
//
// txtIncomeIncomingColumn
//
this.txtIncomeIncomingColumn.Anchoring = Telerik.Reporting.AnchoringStyles.Left;
this.txtIncomeIncomingColumn.Name = "txtIncomeIncomingColumn";
this.txtIncomeIncomingColumn.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
this.txtIncomeIncomingColumn.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))));
this.txtIncomeIncomingColumn.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
this.txtIncomeIncomingColumn.Style.BorderStyle.Right = Telerik.Reporting.Drawing.BorderType.None;
this.txtIncomeIncomingColumn.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
this.txtIncomeIncomingColumn.Style.Font.Bold = true;
this.txtIncomeIncomingColumn.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
this.txtIncomeIncomingColumn.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Top;
this.txtIncomeIncomingColumn.StyleName = "";
this.txtIncomeIncomingColumn.Value = "Income";
//
// txtIncomeOutgoingColumn
//
this.txtIncomeOutgoingColumn.Anchoring = Telerik.Reporting.AnchoringStyles.Left;
this.txtIncomeOutgoingColumn.Name = "txtIncomeOutgoingColumn";
this.txtIncomeOutgoingColumn.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
this.txtIncomeOutgoingColumn.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))));
this.txtIncomeOutgoingColumn.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
this.txtIncomeOutgoingColumn.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
this.txtIncomeOutgoingColumn.Style.Font.Bold = true;
this.txtIncomeOutgoingColumn.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
this.txtIncomeOutgoingColumn.StyleName = "";
this.txtIncomeOutgoingColumn.Value = "Outgoing";
//
// txtIncomeAnnualAmountColumn
//
this.txtIncomeAnnualAmountColumn.Name = "txtIncomeAnnualAmountColumn";
this.txtIncomeAnnualAmountColumn.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.3125003576278687D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
this.txtIncomeAnnualAmountColumn.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))));
this.txtIncomeAnnualAmountColumn.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
this.txtIncomeAnnualAmountColumn.Style.BorderStyle.Right = Telerik.Reporting.Drawing.BorderType.Solid;
this.txtIncomeAnnualAmountColumn.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
this.txtIncomeAnnualAmountColumn.Style.Font.Bold = true;
this.txtIncomeAnnualAmountColumn.StyleName = "";
this.txtIncomeAnnualAmountColumn.Value = "Annual Amount";
// incomePanel
//
this.incomePanel.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.txtIncomeText,
this.incomeTable,
this.textBox2,
this.textBox1});
this.incomePanel.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(3.9378803194267675E-05D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.880000114440918D, Telerik.Reporting.Drawing.UnitType.Inch));
this.incomePanel.Name = "incomePanel";
this.incomePanel.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(7.1999998092651367D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(1.3000000715255737D, Telerik.Reporting.Drawing.UnitType.Inch));
//
// txtIncomeText
//
this.txtIncomeText.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.019999999552965164D, Telerik.Reporting.Drawing.UnitType.Inch));
this.txtIncomeText.Name = "txtIncomeText";
this.txtIncomeText.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.0898698568344116D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19996054470539093D, Telerik.Reporting.Drawing.UnitType.Inch));
this.txtIncomeText.Style.Font.Bold = true;
this.txtIncomeText.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(12D, Telerik.Reporting.Drawing.UnitType.Point);
this.txtIncomeText.Style.Font.Strikeout = false;
this.txtIncomeText.Style.Font.Underline = true;
this.txtIncomeText.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
this.txtIncomeText.Value = "Income";
//
// incomeTable
//
this.incomeTable.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(1.3020836114883423D, Telerik.Reporting.Drawing.UnitType.Inch)));
this.incomeTable.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(0.92708367109298706D, Telerik.Reporting.Drawing.UnitType.Inch)));
this.incomeTable.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(0.84374964237213135D, Telerik.Reporting.Drawing.UnitType.Inch)));
this.incomeTable.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(0.80208379030227661D, Telerik.Reporting.Drawing.UnitType.Inch)));
this.incomeTable.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(1.0000001192092896D, Telerik.Reporting.Drawing.UnitType.Inch)));
this.incomeTable.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(1.0000001192092896D, Telerik.Reporting.Drawing.UnitType.Inch)));
this.incomeTable.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(1.3125002384185791D, Telerik.Reporting.Drawing.UnitType.Inch)));
this.incomeTable.Body.Rows.Add(new Telerik.Reporting.TableBodyRow(new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch)));
this.incomeTable.Body.SetCellContent(0, 0, this.txtIncomeDescription);
this.incomeTable.Body.SetCellContent(0, 1, this.txtIncomeFrequency);
this.incomeTable.Body.SetCellContent(0, 2, this.txtIncomeStartDate);
this.incomeTable.Body.SetCellContent(0, 3, this.txtIncomeEndDate);
this.incomeTable.Body.SetCellContent(0, 4, this.txtIncomeIncoming);
this.incomeTable.Body.SetCellContent(0, 5, this.txtIncomeOutgoing);
this.incomeTable.Body.SetCellContent(0, 6, this.txtIncomeAnnualAmount);
tableGroup1.ReportItem = this.txtIncomeDescriptionColumn;
tableGroup2.ReportItem = this.txtIncomeFrequencyColumn;
tableGroup3.ReportItem = this.txtIncomeStartDateColumn;
tableGroup4.Name = "Group1";
tableGroup4.ReportItem = this.txtIncomeEndDateColumn;
tableGroup5.Name = "Group2";
tableGroup5.ReportItem = this.txtIncomeIncomingColumn;
tableGroup6.Name = "Group3";
tableGroup6.ReportItem = this.txtIncomeOutgoingColumn;
tableGroup7.Name = "Group4";
tableGroup7.ReportItem = this.txtIncomeAnnualAmountColumn;
this.incomeTable.ColumnGroups.Add(tableGroup1);
this.incomeTable.ColumnGroups.Add(tableGroup2);
this.incomeTable.ColumnGroups.Add(tableGroup3);
this.incomeTable.ColumnGroups.Add(tableGroup4);
this.incomeTable.ColumnGroups.Add(tableGroup5);
this.incomeTable.ColumnGroups.Add(tableGroup6);
this.incomeTable.ColumnGroups.Add(tableGroup7);
this.incomeTable.DataSource = this.sqlDataSource1;
this.incomeTable.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.txtIncomeDescription,
this.txtIncomeFrequency,
this.txtIncomeStartDate,
this.txtIncomeEndDate,
this.txtIncomeIncoming,
this.txtIncomeOutgoing,
this.txtIncomeAnnualAmount,
this.txtIncomeDescriptionColumn,
this.txtIncomeFrequencyColumn,
this.txtIncomeStartDateColumn,
this.txtIncomeEndDateColumn,
this.txtIncomeIncomingColumn,
this.txtIncomeOutgoingColumn,
this.txtIncomeAnnualAmountColumn});
this.incomeTable.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(3.929932790924795E-05D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.2800000011920929D, Telerik.Reporting.Drawing.UnitType.Inch));
this.incomeTable.Name = "incomeTable";
tableGroup8.Groupings.AddRange(new Telerik.Reporting.Data.Grouping[] {
new Telerik.Reporting.Data.Grouping("")});
tableGroup8.Name = "DetailGroup";
this.incomeTable.RowGroups.Add(tableGroup8);
this.incomeTable.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(7.187502384185791D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.40000000596046448D, Telerik.Reporting.Drawing.UnitType.Inch));
//
// txtIncomeDescription
//
this.txtIncomeDescription.Name = "txtIncomeDescription";
this.txtIncomeDescription.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.3020833730697632D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
//this.txtIncomeDescription.Value = "A";
this.txtIncomeDescription.Value = "= Fields.KEYWORD_ID";
//
// txtIncomeFrequency
//
this.txtIncomeFrequency.Name = "txtIncomeFrequency";
this.txtIncomeFrequency.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.92708373069763184D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
//this.txtIncomeFrequency.Value = "B";
this.txtIncomeFrequency.Value = "= Fields.KEYWORD";
//
// txtIncomeStartDate
//
this.txtIncomeStartDate.Name = "txtIncomeStartDate";
this.txtIncomeStartDate.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.84374970197677612D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
// this.txtIncomeStartDate.Value = "C";
this.txtIncomeStartDate.Value = "= Fields.ADGROUP_ID";
//
// txtIncomeEndDate
//
this.txtIncomeEndDate.Name = "txtIncomeEndDate";
this.txtIncomeEndDate.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.80208361148834229D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
this.txtIncomeEndDate.Style.BackgroundColor = System.Drawing.Color.Empty;
this.txtIncomeEndDate.StyleName = "";
//this.txtIncomeEndDate.Value = "D";
this.txtIncomeEndDate.Value = "= Fields.SYNC_STATE";
//
// txtIncomeIncoming
//
this.txtIncomeIncoming.Anchoring = Telerik.Reporting.AnchoringStyles.Left;
this.txtIncomeIncoming.Name = "txtIncomeIncoming";
this.txtIncomeIncoming.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
this.txtIncomeIncoming.Style.BackgroundColor = System.Drawing.Color.Empty;
this.txtIncomeIncoming.StyleName = "";
//this.txtIncomeIncoming.Value = "E";
this.txtIncomeIncoming.Value = "= Fields.VALIDATION_STATE";
//
// txtIncomeOutgoing
//
this.txtIncomeOutgoing.Anchoring = Telerik.Reporting.AnchoringStyles.Left;
this.txtIncomeOutgoing.Name = "txtIncomeOutgoing";
this.txtIncomeOutgoing.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
this.txtIncomeOutgoing.StyleName = "";
//this.txtIncomeOutgoing.Value = "F";
this.txtIncomeOutgoing.Value = "= Fields.LAST_UPDATED";
//
// txtIncomeAnnualAmount
//
this.txtIncomeAnnualAmount.Name = "txtIncomeAnnualAmount";
this.txtIncomeAnnualAmount.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.3125003576278687D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
this.txtIncomeAnnualAmount.StyleName = "";
//this.txtIncomeAnnualAmount.Value = "G";
this.txtIncomeAnnualAmount.Value = "= Fields.KWD_ENGINE_ID";
// textBox2
//
this.textBox2.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(4.6399998664855957D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.89999991655349731D, Telerik.Reporting.Drawing.UnitType.Inch));
this.textBox2.Name = "textBox2";
this.textBox2.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.0000003576278687D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch));
this.textBox2.Style.Font.Bold = true;
this.textBox2.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(12D, Telerik.Reporting.Drawing.UnitType.Point);
this.textBox2.Value = "Sub Total :";
//
// textBox1
//
this.textBox1.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(5.880000114440918D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.89999991655349731D, Telerik.Reporting.Drawing.UnitType.Inch));
this.textBox1.Name = "textBox1";
this.textBox1.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.2800010442733765D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch));
this.textBox1.Style.Font.Bold = true;
this.textBox1.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(12D, Telerik.Reporting.Drawing.UnitType.Point);
this.textBox1.Value = "$123456789";
//
// entityDataSource1
//
//
// sqlDataSource1
//
this.sqlDataSource1.ConnectionString = "SHMMSampleReport.Properties.Settings.SpringZipnew";
this.sqlDataSource1.Name = "sqlDataSource1";
this.sqlDataSource1.SelectCommand = "SELECT KEYWORD_ID, KEYWORD, ADGROUP_ID, SYNC_STATE, VALIDATION_STATE, LAST" +
"_UPDATED, KWD_ENGINE_ID\r\nFROM KEYWORD";
//
return incomePanel;
}
/// <summary>
/// This method is used to retrieve report detail section's outgoing detail.
/// </summary>
/// <param name="Description"></param>
/// <param name="Frequency"></param>
/// <param name="StartDate"></param>
/// <param name="EndDate"></param>
/// <param name="Income"></param>
/// <param name="Outgoing"></param>
/// <param name="AnnualAmount"></param>
/// <param name="SubTotal"></param>
/// <param name="GrandTotal"></param>
/// <returns>This method returns Report detail outgoing section.</returns>
private Panel GetDetailOutgoingSection()
{
#region "Declaration"
Panel outgoingPanel = new Panel();
Table telerikTable = new Table();
int initialCount = 0;
int columnHeaderCount = 7;
const double rowHeight = 0.2;
double width = 7.26D;
List<TextBox> headerTableBoxCollection = new List<TextBox>();
List<TextBox> bodyTableCollection = new List<TextBox>();
TextBox txtOutgoingText = new TextBox();
TextBox txtOutgoingDescriptionColumn = new TextBox();
TextBox txtOutgoingFrequencyColumn = new TextBox();
TextBox txtOutgoingStartDateColumn = new TextBox();
TextBox txtOutgoingEndDateColumn = new TextBox();
TextBox txtOutgoingIncomingColumn = new TextBox();
TextBox txtOutcomeOutgoingColumn = new TextBox();
TextBox txtOutgoingAnnualAmountColumn = new TextBox();
TextBox txtOutgoingAnnualAmount = new TextBox();
TextBox txtOutcomeOutgoing = new TextBox();
TextBox txtOutgoingIncoming = new TextBox();
TextBox txtOutgoingEndDate = new TextBox();
TextBox txtOutgoingStartDate = new TextBox();
TextBox txtOutgoingFrequency = new TextBox();
TextBox txtOutgoingDescription = new TextBox();
TextBox txtOutgoingSubTotalText = new TextBox();
TextBox txtOutgoingSubtotal = new TextBox();
TextBox txtGrandTotal = new TextBox();
TextBox txtGrandTotalText = new TextBox();
TextBox txtHorizontalLine = new TextBox();
#endregion
try
{
#region "Commented Area"
// if (RowNum == 0)
{
//outgoingPanel
outgoingPanel.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(2.3999998569488525D, Telerik.Reporting.Drawing.UnitType.Inch));
outgoingPanel.Name = "pnlOutgoing";
outgoingPanel.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(7.2604331970214844D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(1.3999999761581421D, Telerik.Reporting.Drawing.UnitType.Inch));
outgoingPanel.Style.BackgroundColor = System.Drawing.Color.White;
outgoingPanel.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.None;
// txtOutgoingText
txtOutgoingText.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.029999999329447746D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingText.Name = "txtOutgoingText";
txtOutgoingText.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.2794309854507446D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19996054470539093D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingText.Style.Font.Bold = true;
txtOutgoingText.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(12D, Telerik.Reporting.Drawing.UnitType.Point);
txtOutgoingText.Style.Font.Strikeout = false;
txtOutgoingText.Style.Font.Underline = true;
txtOutgoingText.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Left;
txtOutgoingText.Value = "Outgoing";
#region "Columns"
// txtOutgoingDescriptionColumn
txtOutgoingDescriptionColumn.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.25D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingDescriptionColumn.Name = "txtOutgoingDescriptionColumn";
txtOutgoingDescriptionColumn.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.3999212980270386D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000012218952179D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingDescriptionColumn.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))));
txtOutgoingDescriptionColumn.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
txtOutgoingDescriptionColumn.Style.BorderStyle.Left = Telerik.Reporting.Drawing.BorderType.Solid;
txtOutgoingDescriptionColumn.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
txtOutgoingDescriptionColumn.Style.Font.Bold = true;
txtOutgoingDescriptionColumn.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Left;
txtOutgoingDescriptionColumn.Value = "Description";
// txtOutgoingFrequencyColumn
txtOutgoingFrequencyColumn.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(1.4000000953674316D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.25D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingFrequencyColumn.Name = "txtOutgoingFrequencyColumn";
txtOutgoingFrequencyColumn.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.80000019073486328D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999980926513672D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingFrequencyColumn.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))));
txtOutgoingFrequencyColumn.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
txtOutgoingFrequencyColumn.Style.BorderStyle.Right = Telerik.Reporting.Drawing.BorderType.None;
txtOutgoingFrequencyColumn.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
txtOutgoingFrequencyColumn.Style.Font.Bold = true;
txtOutgoingFrequencyColumn.Value = "Frequency";
// txtOutgoingStartDateColumn
txtOutgoingStartDateColumn.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(2.2000000476837158D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.25D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingStartDateColumn.Name = "txtOutgoingStartDateColumn";
txtOutgoingStartDateColumn.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.800000011920929D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingStartDateColumn.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))));
txtOutgoingStartDateColumn.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
txtOutgoingStartDateColumn.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
txtOutgoingStartDateColumn.Style.Font.Bold = true;
txtOutgoingStartDateColumn.Value = "Start Date";
// txtOutgoingEndDateColumn
txtOutgoingEndDateColumn.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(3D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.25D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingEndDateColumn.Name = "txtOutgoingEndDateColumn";
txtOutgoingEndDateColumn.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.800000011920929D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingEndDateColumn.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))));
txtOutgoingEndDateColumn.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
txtOutgoingEndDateColumn.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
txtOutgoingEndDateColumn.Style.Font.Bold = true;
txtOutgoingEndDateColumn.Value = "End Date";
// txtOutgoingIncomingColumn
txtOutgoingIncomingColumn.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(3.8005897998809814D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.25D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingIncomingColumn.Name = "txtOutgoingIncomingColumn";
txtOutgoingIncomingColumn.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingIncomingColumn.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))));
txtOutgoingIncomingColumn.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
txtOutgoingIncomingColumn.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Double;
txtOutgoingIncomingColumn.Style.Font.Bold = true;
txtOutgoingIncomingColumn.Value = "Income";
// txtOutcomeOutgoingColumn
txtOutcomeOutgoingColumn.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(4.8006687164306641D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.25D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutcomeOutgoingColumn.Name = "txtOutcomeOutgoingColumn";
txtOutcomeOutgoingColumn.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.99968528747558594D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000012218952179D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutcomeOutgoingColumn.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))));
txtOutcomeOutgoingColumn.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
txtOutcomeOutgoingColumn.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
txtOutcomeOutgoingColumn.Style.Font.Bold = true;
txtOutcomeOutgoingColumn.Value = "Outgoing";
// txtOutgoingAnnualAmountColumn
txtOutgoingAnnualAmountColumn.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(5.8004326820373535D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.25D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingAnnualAmountColumn.Name = "txtOutgoingAnnualAmountColumn";
txtOutgoingAnnualAmountColumn.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.4600000381469727D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingAnnualAmountColumn.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))));
txtOutgoingAnnualAmountColumn.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
txtOutgoingAnnualAmountColumn.Style.BorderStyle.Right = Telerik.Reporting.Drawing.BorderType.Solid;
txtOutgoingAnnualAmountColumn.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
txtOutgoingAnnualAmountColumn.Style.Font.Bold = true;
txtOutgoingAnnualAmountColumn.Value = "Annual Amount";
#endregion
}
#region "Rows"
// txtOutgoingAnnualAmount
txtOutgoingAnnualAmount.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(5.7917060852050781D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.45007863640785217D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingAnnualAmount.Name = "txtOutgoingAnnualAmount";
txtOutgoingAnnualAmount.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.4527168273925781D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000012218952179D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingAnnualAmount.Value = "$100";
// txtOutcomeOutgoing
txtOutcomeOutgoing.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(4.8021225929260254D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.45007863640785217D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutcomeOutgoing.Name = "txtOutcomeOutgoing";
txtOutcomeOutgoing.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.98871421813964844D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutcomeOutgoing.Value = "$200";
// txtOutgoingIncoming
txtOutgoingIncoming.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(3.7917060852050781D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.45007863640785217D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingIncoming.Name = "txtOutgoingIncoming";
txtOutgoingIncoming.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.0006290674209595D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000012218952179D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingIncoming.Value = "$200";
// txtOutgoingEndDate
txtOutgoingEndDate.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(3.0000393390655518D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.45007863640785217D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingEndDate.Name = "txtOutgoingEndDate";
txtOutgoingEndDate.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.79158782958984375D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000012218952179D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingEndDate.Value = "01/01/2011";
// txtOutgoingStartDate
txtOutgoingStartDate.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(2.1979560852050781D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.45007863640785217D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingStartDate.Name = "txtOutgoingStartDate";
txtOutgoingStartDate.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.7999998927116394D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000012218952179D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingStartDate.Value ="01/01/2010";
// txtOutgoingFrequency
txtOutgoingFrequency.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(1.3958727121353149D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.45007863640785217D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingFrequency.Name = "txtOutgoingFrequency";
txtOutgoingFrequency.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.7999998927116394D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000012218952179D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingFrequency.Value = "Monthly";
// txtOutgoingDescription
txtOutgoingDescription.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(3.9418537198798731E-05D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.45007863640785217D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingDescription.Name = "txtOutgoingDescription";
txtOutgoingDescription.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.3926376104354858D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingDescription.Value = "ABC";
#endregion
// if (IsLast)
{
#region "SubTotal and GrandTotal"
// txtOutgoingSubTotalText
txtOutgoingSubTotalText.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(4.5999999046325684D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.75D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingSubTotalText.Name = "txtOutgoingSubTotalText";
txtOutgoingSubTotalText.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.0000003576278687D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingSubTotalText.Style.Font.Bold = true;
txtOutgoingSubTotalText.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(12D, Telerik.Reporting.Drawing.UnitType.Point);
txtOutgoingSubTotalText.Value = "Sub Total :";
// txtOutgoingSubtotal
txtOutgoingSubtotal.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(5.7899999618530273D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.75D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingSubtotal.Name = "txtOutgoingSubtotal";
txtOutgoingSubtotal.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.4439502954483032D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingSubtotal.Style.Font.Bold = true;
txtOutgoingSubtotal.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(12D, Telerik.Reporting.Drawing.UnitType.Point);
txtOutgoingSubtotal.Value = "$1000";
;
// txtGrandTotal
txtGrandTotal.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(5.7899994850158691D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(1.1000789403915405D, Telerik.Reporting.Drawing.UnitType.Inch));
txtGrandTotal.Name = "txtGrandTotal";
txtGrandTotal.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.4439502954483032D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch));
txtGrandTotal.Style.Font.Bold = true;
txtGrandTotal.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(12D, Telerik.Reporting.Drawing.UnitType.Point);
txtGrandTotal.Value = "$500";
// txtGrandTotalText
txtGrandTotalText.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(4.4000000953674316D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(1.1000789403915405D, Telerik.Reporting.Drawing.UnitType.Inch));
txtGrandTotalText.Name = "txtGrandTotalText";
txtGrandTotalText.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.2004156112670898D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch));
txtGrandTotalText.Style.Font.Bold = true;
txtGrandTotalText.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(12D, Telerik.Reporting.Drawing.UnitType.Point);
txtGrandTotalText.Value = "Grand Total :";
// txtHorizontalLine
txtHorizontalLine.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(4.4000000953674316D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Inch));
txtHorizontalLine.Name = "txtHorizontalLine";
txtHorizontalLine.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(2.6700000762939453D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.0099999997764825821D, Telerik.Reporting.Drawing.UnitType.Inch));
txtHorizontalLine.Style.BackgroundColor = System.Drawing.Color.White;
txtHorizontalLine.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
txtHorizontalLine.Style.BorderWidth.Top = new Telerik.Reporting.Drawing.Unit(2D, Telerik.Reporting.Drawing.UnitType.Point);
txtHorizontalLine.Value = "";
#endregion
}
#region "Add Controls In panel"
// if (IsLast)
{
outgoingPanel.Items.AddRange(new Telerik.Reporting.ReportItemBase[]
{
txtOutgoingText,
txtOutgoingDescriptionColumn,
txtOutgoingFrequencyColumn,
txtOutgoingStartDateColumn,
txtOutgoingEndDateColumn,
txtOutgoingIncomingColumn,
txtOutcomeOutgoingColumn,
txtOutgoingAnnualAmountColumn,
txtOutgoingAnnualAmount,
txtOutcomeOutgoing,
txtOutgoingIncoming,
txtOutgoingEndDate,
txtOutgoingStartDate,
txtOutgoingFrequency,
txtOutgoingDescription,
txtOutgoingSubTotalText,
txtOutgoingSubtotal,
txtGrandTotal,
txtGrandTotalText,
txtHorizontalLine
}
);
}
#endregion
#endregion
return outgoingPanel;
}
catch (Exception ex)
{
if (log.IsErrorEnabled)
log.Error("[" + System.DateTime.Now.ToString() + "] AnnualBudgetReport::GetDetailOutgoingSection ", ex);
throw;
}
}
/// <summary>
/// This method is used to retrieve report detail section.
/// </summary>
/// <returns>This method returns report detail section.</returns>
private DetailSection GetReportDetailsection()
{
DetailSection reportDetailSection = new DetailSection();
try
{
// AnnualBudgetReportDetail
reportDetailSection.Height = new Telerik.Reporting.Drawing.Unit(8D, Telerik.Reporting.Drawing.UnitType.Inch);
Panel panelIncomeSection = GetDetailIncomeSection();
reportDetailSection.Items.AddRange(new Telerik.Reporting.ReportItemBase[]
{
GetHeaderPanel(),
panelIncomeSection
//GetDetailOutgoingSection(),
//GetDetailOutgoingSection()
}
);
reportDetailSection.Name = "AnnualBudgetReportDetail";
reportDetailSection.Style.BorderStyle.Left = Telerik.Reporting.Drawing.BorderType.None;
reportDetailSection.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
return reportDetailSection;
}
catch (Exception ex)
{
if (log.IsErrorEnabled)
log.Error("[" + System.DateTime.Now.ToString() + "] AnnualBudgetReport::GetReportDetailsection ", ex);
throw;
}
finally
{
//if (reportDetailSection != null)
// reportDetailSection = null;
}
}
#endregion
#region "Footer Section"
/// <summary>
/// This method is used to retrieve footer panel.
/// </summary>
/// <param name="pageNo">This parameter is the page number of report.</param>
/// <param name="todayDate">This parameter is today's date.</param>
/// <param name="footerText">This parameter is footer text.</param>
/// <returns>This method returns footer panel.</returns>
private Panel GetFooterPanel(string pageNo,string todayDate,string footerText)
{
Panel footerPanel = new Panel();
TextBox txtFooterPageNo = new TextBox();
TextBox txtFooterTodayDate = new TextBox();
TextBox txtFooterText = new TextBox();
try
{
//footerPanel
footerPanel.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0.82291668653488159D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.0416666679084301D, Telerik.Reporting.Drawing.UnitType.Inch));
footerPanel.Name = "footerPanel";
footerPanel.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(5.5999999046325684D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
// txtFooterPageNo
txtFooterPageNo.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(3.9418537198798731E-05D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(3.9418537198798731E-05D, Telerik.Reporting.Drawing.UnitType.Inch));
txtFooterPageNo.Name = "txtFooterPageNo";
txtFooterPageNo.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.51999998092651367D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000012218952179D, Telerik.Reporting.Drawing.UnitType.Inch));
txtFooterPageNo.Value = pageNo;
// txtFooterTodayDate
txtFooterTodayDate.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0.51999998092651367D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch));
txtFooterTodayDate.Name = "txtFooterTodayDate";
txtFooterTodayDate.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.60000008344650269D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000012218952179D, Telerik.Reporting.Drawing.UnitType.Inch));
txtFooterTodayDate.Value = todayDate;
// txtFooterText
txtFooterText.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(1.1200000047683716D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch));
txtFooterText.Name = "txtFooterText";
txtFooterText.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(4.4000000953674316D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
txtFooterText.Value = footerText;
footerPanel.Items.AddRange(new Telerik.Reporting.ReportItemBase[]
{
txtFooterPageNo,
txtFooterTodayDate,
txtFooterText
}
);
return footerPanel;
}
catch (Exception ex)
{
if (log.IsErrorEnabled)
log.Error("[" + System.DateTime.Now.ToString() + "] AnnualBudgetReport::GetFooterPanel ", ex);
throw;
}
}
/// <summary>
/// This method is used to retrieve report footer section.
/// </summary>
/// <returns>This method returns report footer section.</returns>
private PageFooterSection GetReportFooterSection()
{
PageFooterSection reportFooterSection = new PageFooterSection();
try
{
// AnnualBudgetReportFooter
reportFooterSection.Height = new Telerik.Reporting.Drawing.Unit(0.30000001192092896D, Telerik.Reporting.Drawing.UnitType.Inch);
reportFooterSection.Items.AddRange(new Telerik.Reporting.ReportItemBase[]
{
GetFooterPanel("1 of 1 ::","8/5/2011",":: www.MyHome.com :: My Software")
}
);
reportFooterSection.Name = "AnnualBudgetReportFooter";
reportFooterSection.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))));
return reportFooterSection;
}
catch (Exception ex)
{
if (log.IsErrorEnabled)
log.Error("[" + System.DateTime.Now.ToString() + "] AnnualBudgetReport::GetReportFooterSection ", ex);
throw;
}
}
#endregion
/// <summary>
/// This method is used to retrieve report data.
/// </summary>
/// <param name="type">This parameter is the type of data[imcome/outgoing].</param>
/// <returns>This method returns report data.</returns>
private DataTable getDataSource(string type)
{
BudgetViewModel objBudgetViewModel = new BudgetViewModel();
DataTable dtReportData = new DataTable();
try
{
ObservableCollection<UserItems> objUserItem = new ObservableCollection<UserItems>();
dtReportData.Columns.Add("Description", typeof(string));
dtReportData.Columns.Add("Frequency", typeof(string));
dtReportData.Columns.Add("StartDate", typeof(string));
dtReportData.Columns.Add("EndDate", typeof(string));
dtReportData.Columns.Add("Income", typeof(string));
dtReportData.Columns.Add("Outgoing", typeof(string));
dtReportData.Columns.Add("AnnualAmount", typeof(string));
// dtReportData.Columns.Add("SubTotal", typeof(string));
// dtReportData.Columns.Add("GrandTotal", typeof(string));
if (type.ToLower() == "income")
{
objUserItem = objBudgetViewModel.IncommingItemsCollection;
if (objUserItem != null && objUserItem.Count > 0)
{
_subTotal = 0;
foreach(UserItems item in objUserItem)
{
string frequency = objBudgetViewModel.GetFrequencyTypeByFrequencyID(Convert.ToInt32(item.FrequencyID));
_subTotal += Convert.ToDecimal(item.Total);
_grandTotal = _subTotal;
dtReportData.Rows.Add(item.Name, frequency, Convert.ToDateTime(item.StartDate).ToShortDateString(), Convert.ToDateTime(item.EndDate).ToShortDateString(), item.Amount.ToString(), "0.00", item.Total.ToString());//,_subTotal.ToString(), _grandTotal.ToString());
}
}
}
else
{
objUserItem = objBudgetViewModel.OutgoingItemsCollection;
if (objUserItem != null && objUserItem.Count > 0)
{
_subTotal = 0;
foreach (UserItems item in objUserItem)
{
string frequency = objBudgetViewModel.GetFrequencyTypeByFrequencyID(Convert.ToInt32(item.FrequencyID));
_subTotal += Convert.ToDecimal(item.Total);
_grandTotal -= Convert.ToDecimal(item.Total);
dtReportData.Rows.Add(item.Name, frequency, Convert.ToDateTime(item.StartDate).ToShortDateString(), Convert.ToDateTime(item.EndDate).ToShortDateString(), "0.00", item.Amount.ToString(), item.Total.ToString());//,_subTotal.ToString(), _grandTotal.ToString());
}
}
}
return dtReportData;
}
catch (Exception ex)
{
if (log.IsErrorEnabled)
log.Error("[" + System.DateTime.Now.ToString() + "] AnnualBudgetReport::getDataSource ", ex);
throw;
}
}
#endregion
#region "Public Methods"
#region "Add Report Sections to report"
/// <summary>
/// This method is used to combine report sections.
/// </summary>
/// <returns>This method returns complete report with header,deatil and footer section.</returns>
public Report GetAnnualBudgetReport()
{
Report annualBudgetReport = new Report();
try
{
// AnnualBudget
PageHeaderSection pageHeader = new PageHeaderSection();
pageHeader.Height = new Telerik.Reporting.Drawing.Unit(0.019999999552965164D, Telerik.Reporting.Drawing.UnitType.Inch);
pageHeader.Name = "pageHeaderSection1";
annualBudgetReport.Items.AddRange(new Telerik.Reporting.ReportItemBase[]
{
//GetReportHeaderSection(),
GetReportDetailsection(),
GetReportFooterSection()
}
);
annualBudgetReport.PageSettings.Landscape = false;
annualBudgetReport.PageSettings.Margins.Bottom = new Telerik.Reporting.Drawing.Unit(0.5D, Telerik.Reporting.Drawing.UnitType.Inch);
annualBudgetReport.PageSettings.Margins.Left = new Telerik.Reporting.Drawing.Unit(0.5D, Telerik.Reporting.Drawing.UnitType.Inch);
annualBudgetReport.PageSettings.Margins.Right = new Telerik.Reporting.Drawing.Unit(0.5D, Telerik.Reporting.Drawing.UnitType.Inch);
annualBudgetReport.PageSettings.Margins.Top = new Telerik.Reporting.Drawing.Unit(0.5D, Telerik.Reporting.Drawing.UnitType.Inch);
annualBudgetReport.PageSettings.PaperKind = System.Drawing.Printing.PaperKind.A4;
annualBudgetReport.Style.BackgroundColor = System.Drawing.Color.White;
annualBudgetReport.Width = new Telerik.Reporting.Drawing.Unit(7.2604727745056152D, Telerik.Reporting.Drawing.UnitType.Inch);
return annualBudgetReport;
}
catch (Exception ex)
{
if (log.IsErrorEnabled)
log.Error("[" + System.DateTime.Now.ToString() + "] AnnualBudgetReport::GetAnnualBudgetReport ", ex);
throw;
}
}
#endregion
#endregion
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
please Help me.
Thanx in advance.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
#region "Private Variable"
private readonly ILog log = LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
private decimal _subTotal=0;
private decimal _grandTotal=0;
#endregion
#region "Public Variable"
#endregion
#region "Constructor"
public AnnualBudgetReport()
{
}
#endregion
#region "Private Methods"
#region "Header Section"
/// <summary>
/// This method is used to retrieve Header section panel.
/// </summary>
/// <returns>This method returns header panel.</returns>
private Panel GetHeaderPanel()
{
Panel headerPanel = new Panel();
try
{
headerPanel.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(3.9378803194267675E-05D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.080000005662441254D, Telerik.Reporting.Drawing.UnitType.Inch));
headerPanel.Name = "headerPanel";
headerPanel.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(7.1999998092651367D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.5D, Telerik.Reporting.Drawing.UnitType.Inch));
headerPanel.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))));
headerPanel.Items.AddRange(new Telerik.Reporting.ReportItemBase[]
{
GetMainHeader("Budget - Annual report"),
GetSubHeaderPanel("For 52 weeks, starting Monday","8/5/2011",":: Today's date","8/1/2011")
});
return headerPanel;
}
catch (Exception ex)
{
if (log.IsErrorEnabled)
log.Error("[" + System.DateTime.Now.ToString() + "] AnnualBudgetReport::GetHeaderPanel ", ex);
throw;
}
}
/// <summary>
/// This method is used to retrieve Main header text.
/// </summary>
/// <param name="MainHeaderText">This parameter is the main header title of report.</param>
/// <returns> This method returns header title textbox.</returns>
private TextBox GetMainHeader(string MainHeaderText)
{
TextBox txtHeaderTitle = new TextBox();
try
{
// txtHeaderTitle
//
txtHeaderTitle.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(2.4999606609344482D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(3.9339065551757812E-05D, Telerik.Reporting.Drawing.UnitType.Inch));
txtHeaderTitle.Name = "txtHeaderTitle";
txtHeaderTitle.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(2D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000004768371582D, Telerik.Reporting.Drawing.UnitType.Inch));
txtHeaderTitle.Style.Font.Bold = true;
txtHeaderTitle.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(12D, Telerik.Reporting.Drawing.UnitType.Point);
txtHeaderTitle.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
txtHeaderTitle.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
txtHeaderTitle.Value = MainHeaderText;
//
return txtHeaderTitle;
}
catch (Exception ex)
{
if (log.IsErrorEnabled)
log.Error("[" + System.DateTime.Now.ToString() + "] AnnualBudgetReport::GetMainHeader ", ex);
throw;
}
}
/// <summary>
/// Thiis method is sed to retrieve sub header panel.
/// </summary>
/// <param name="subHeaderTitle">This parameter is the sub header title.</param>
/// <param name="todayDate">This parameter is the Today date for report.</param>
/// <param name="todayDateText">This parameter is the today date text.</param>
/// <param name="budgetStartDate">This parameter is the budget start date.</param>
/// <returns>This method returns sub header panel.</returns>
private Panel GetSubHeaderPanel(string subHeaderTitle, string todayDate, string todayDateText, string budgetStartDate)
{
Panel subHeaderPanel = new Panel();
TextBox txtReportTitleDetail = new TextBox();
TextBox txtTodayDate = new TextBox();
TextBox txtTodayDateText = new TextBox();
TextBox txtBudgetStartDate = new TextBox();
try
{
// subHeaderPanel
//
subHeaderPanel.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(1.2999999523162842D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.2199999988079071D, Telerik.Reporting.Drawing.UnitType.Inch));
subHeaderPanel.Name = "pnlsubHeader";
subHeaderPanel.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(4.5999999046325684D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.25D, Telerik.Reporting.Drawing.UnitType.Inch));
subHeaderPanel.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
subHeaderPanel.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
//
// txtReportTitleDetail
//
txtReportTitleDetail.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch));
txtReportTitleDetail.Name = "txtReportTitleDetail";
txtReportTitleDetail.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(2D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000004768371582D, Telerik.Reporting.Drawing.UnitType.Inch));
txtReportTitleDetail.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(10D, Telerik.Reporting.Drawing.UnitType.Point);
txtReportTitleDetail.Value = subHeaderTitle;//"For 52 weeks, starting Monday";
//
// txtTodayDate
//
txtTodayDate.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(3.6000001430511475D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch));
txtTodayDate.Name = "txtTodayDate";
txtTodayDate.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.7999998927116394D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000004768371582D, Telerik.Reporting.Drawing.UnitType.Inch));
txtTodayDate.Value = todayDate;// "8/5/2011";
//
// txtTodayDateText
//
txtTodayDateText.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(2.6000001430511475D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch));
txtTodayDateText.Name = "txtTodayDateText";
txtTodayDateText.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000004768371582D, Telerik.Reporting.Drawing.UnitType.Inch));
txtTodayDateText.Value = todayDateText;// ":: Today's date";
//
// txtBudgetStartDate
//
txtBudgetStartDate.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(2.0000002384185791D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch));
txtBudgetStartDate.Name = "txtBudgetStartDate";
txtBudgetStartDate.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.60000008344650269D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000004768371582D, Telerik.Reporting.Drawing.UnitType.Inch));
txtBudgetStartDate.Value = budgetStartDate;// "8/1/2011";
//
subHeaderPanel.Items.AddRange(new Telerik.Reporting.ReportItemBase[]
{
txtReportTitleDetail,
txtTodayDate,
txtTodayDateText,
txtBudgetStartDate
});
return subHeaderPanel;
}
catch (Exception ex)
{
if (log.IsErrorEnabled)
log.Error("[" + System.DateTime.Now.ToString() + "] AnnualBudgetReport::GetSubHeaderPanel ", ex);
throw;
}
}
/// <summary>
/// This method is used to retrieve Report header section.
/// </summary>
/// <returns>This method returns report header aection.</returns>
private PageHeaderSection GetReportHeaderSection()
{
PageHeaderSection reportHeaderSection = new PageHeaderSection();
try
{
// AnnualBudgetReportHeader
reportHeaderSection.Height = new Telerik.Reporting.Drawing.Unit(0.019999999552965164D, Telerik.Reporting.Drawing.UnitType.Inch);
reportHeaderSection.Name = "AnnualBudgetReportHeader";
reportHeaderSection.Style.BackgroundColor = System.Drawing.Color.White;
//
return reportHeaderSection;
}
catch (Exception ex)
{
if (log.IsErrorEnabled)
log.Error("[" + System.DateTime.Now.ToString() + "] AnnualBudgetReport::GetReportHeaderSection ", ex);
throw;
}
finally
{
//if (reportHeaderSection != null)
// reportHeaderSection = null;
}
}
#endregion
#region "Detail Section"
/// <summary>
/// This method is used to retrieve report detail section's income detail.
/// </summary>
/// <param name="Description"></param>
/// <param name="Frequency"></param>
/// <param name="StartDate"></param>
/// <param name="EndDate"></param>
/// <param name="Income"></param>
/// <param name="Outgoing"></param>
/// <param name="AnnualAmount"></param>
/// <param name="SubTotal"></param>
/// <returns>This method returns Report detail income section.</returns>
//private Panel GetDetailIncomeSection()
//{
// #region "Declaration"
// Panel incomePanel = new Panel();
// Table incomeTable = new Table();
// TableGroup tableGroupFirst = new TableGroup();
// TableGroup tableGroupSecond = new TableGroup();
// TableGroup tableGroupThird = new TableGroup();
// TableGroup tableGroupFourth = new TableGroup();
// TableGroup tableGroupFifth = new TableGroup();
// TableGroup tableGroupSixth = new TableGroup();
// TableGroup tableGroupSeventh = new TableGroup();
// TableGroup tableGroupEightth = new TableGroup();
// //int initialCount = 0;
// //int columnHeaderCount = 7;
// //const double rowHeight = 0.2;
// //double width = 7.26D;
// //int rowCount = 0;
// TextBox txtIncomeText = new TextBox();
// TextBox txtIncomeDescriptionColumn = new TextBox();
// TextBox txtIncomeFrequencyColumn = new TextBox();
// TextBox txtIncomeStartDateColumn = new TextBox();
// TextBox txtIncomeEndDateColumn = new TextBox();
// TextBox txtIncomeIncomingColumn = new TextBox();
// TextBox txtIncomeOutgoingColumn = new TextBox();
// TextBox txtIncomeAnnualAmountColumn = new TextBox();
// TextBox txtIncomeDescription = new TextBox();
// TextBox txtIncomeFrequency = new TextBox();
// TextBox txtIncomeStartDate = new TextBox();
// TextBox txtIncomeEndDate = new TextBox();
// TextBox txtIncomeIncoming = new TextBox();
// TextBox txtIncomeOutgoing = new TextBox();
// TextBox txtIncomeAnnualAmount = new TextBox();
// TextBox txtIncomeSubTotal = new TextBox();
// TextBox txtIncomeSubTotalText = new TextBox();
// #endregion
// try
// {
// //if (RowNum == 0)
// {
// //incomePanel
// incomePanel.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(3.9378803194267675E-05D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.880000114440918D, Telerik.Reporting.Drawing.UnitType.Inch));
// incomePanel.Name = "incomePanel";
// incomePanel.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(7.1999998092651367D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(1.3000000715255737D, Telerik.Reporting.Drawing.UnitType.Inch));
// // txtIncomeText
// txtIncomeText.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.019999999552965164D, Telerik.Reporting.Drawing.UnitType.Inch));
// txtIncomeText.Name = "txtIncomeText";
// txtIncomeText.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.0898698568344116D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19996054470539093D, Telerik.Reporting.Drawing.UnitType.Inch));
// txtIncomeText.Style.Font.Bold = true;
// txtIncomeText.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(12D, Telerik.Reporting.Drawing.UnitType.Point);
// txtIncomeText.Style.Font.Strikeout = false;
// txtIncomeText.Style.Font.Underline = true;
// txtIncomeText.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Left;
// txtIncomeText.Value = "Income";
// //incomePanel.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(LocY, Telerik.Reporting.Drawing.UnitType.Inch));
// //incomePanel.Name = "pnlIncomeDetail";
// //incomePanel.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(7.2604331970214844D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(1.5999208688735962D, Telerik.Reporting.Drawing.UnitType.Inch));
// //incomePanel.Style.BackgroundColor = System.Drawing.Color.White;
// //incomePanel.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.None;
// #region "Columns"
// // txtIncomeDescriptionColumn
// txtIncomeDescriptionColumn.Name = "txtIncomeDescriptionColumn";
// txtIncomeDescriptionColumn.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.3020833730697632D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
// txtIncomeDescriptionColumn.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))));
// txtIncomeDescriptionColumn.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
// txtIncomeDescriptionColumn.Style.BorderStyle.Left = Telerik.Reporting.Drawing.BorderType.Solid;
// txtIncomeDescriptionColumn.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
// txtIncomeDescriptionColumn.Style.Font.Bold = true;
// txtIncomeDescriptionColumn.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
// txtIncomeDescriptionColumn.Value = "Description";
// // txtIncomeStartDateColumn
// txtIncomeFrequencyColumn.Name = "txtIncomeFrequencyColumn";
// txtIncomeFrequencyColumn.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.92708373069763184D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
// txtIncomeFrequencyColumn.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))));
// txtIncomeFrequencyColumn.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
// txtIncomeFrequencyColumn.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
// txtIncomeFrequencyColumn.Style.Font.Bold = true;
// txtIncomeFrequencyColumn.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
// txtIncomeFrequencyColumn.Value = "Frequency";
// // txtIncomeEndDateColumn
// txtIncomeEndDateColumn.Name = "txtIncomeEndDateColumn";
// txtIncomeEndDateColumn.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.80208361148834229D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
// txtIncomeEndDateColumn.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))));
// txtIncomeEndDateColumn.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
// txtIncomeEndDateColumn.Style.BorderStyle.Right = Telerik.Reporting.Drawing.BorderType.None;
// txtIncomeEndDateColumn.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
// txtIncomeEndDateColumn.Style.Font.Bold = true;
// txtIncomeEndDateColumn.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
// txtIncomeEndDateColumn.StyleName = "";
// txtIncomeEndDateColumn.Value = "End Date";
// // txtIncomeIncomingColumn
// txtIncomeIncomingColumn.Anchoring = Telerik.Reporting.AnchoringStyles.Left;
// txtIncomeIncomingColumn.Name = "txtIncomeIncomingColumn";
// txtIncomeIncomingColumn.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
// txtIncomeIncomingColumn.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))));
// txtIncomeIncomingColumn.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
// txtIncomeIncomingColumn.Style.BorderStyle.Right = Telerik.Reporting.Drawing.BorderType.None;
// txtIncomeIncomingColumn.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
// txtIncomeIncomingColumn.Style.Font.Bold = true;
// txtIncomeIncomingColumn.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
// txtIncomeIncomingColumn.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Top;
// txtIncomeIncomingColumn.StyleName = "";
// txtIncomeIncomingColumn.Value = "Income";
// // txtIncomeOutgoingColumn
// txtIncomeOutgoingColumn.Anchoring = Telerik.Reporting.AnchoringStyles.Left;
// txtIncomeOutgoingColumn.Name = "txtIncomeOutgoingColumn";
// txtIncomeOutgoingColumn.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
// txtIncomeOutgoingColumn.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))));
// txtIncomeOutgoingColumn.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
// txtIncomeOutgoingColumn.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
// txtIncomeOutgoingColumn.Style.Font.Bold = true;
// txtIncomeOutgoingColumn.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
// txtIncomeOutgoingColumn.StyleName = "";
// txtIncomeOutgoingColumn.Value = "Outgoing";
// // txtIncomeAnnualAmountColumn
// txtIncomeAnnualAmountColumn.Name = "txtIncomeAnnualAmountColumn";
// txtIncomeAnnualAmountColumn.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.3125003576278687D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
// txtIncomeAnnualAmountColumn.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))));
// txtIncomeAnnualAmountColumn.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
// txtIncomeAnnualAmountColumn.Style.BorderStyle.Right = Telerik.Reporting.Drawing.BorderType.Solid;
// txtIncomeAnnualAmountColumn.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
// txtIncomeAnnualAmountColumn.Style.Font.Bold = true;
// txtIncomeAnnualAmountColumn.StyleName = "";
// txtIncomeAnnualAmountColumn.Value = "Annual Amount";
// }
// // incomeTable
// //
// incomeTable.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(1.3020836114883423D, Telerik.Reporting.Drawing.UnitType.Inch)));
// incomeTable.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(0.92708367109298706D, Telerik.Reporting.Drawing.UnitType.Inch)));
// incomeTable.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(0.84374964237213135D, Telerik.Reporting.Drawing.UnitType.Inch)));
// incomeTable.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(0.80208379030227661D, Telerik.Reporting.Drawing.UnitType.Inch)));
// incomeTable.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(1.0000001192092896D, Telerik.Reporting.Drawing.UnitType.Inch)));
// incomeTable.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(1.0000001192092896D, Telerik.Reporting.Drawing.UnitType.Inch)));
// incomeTable.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(1.3125002384185791D, Telerik.Reporting.Drawing.UnitType.Inch)));
// incomeTable.Body.Rows.Add(new Telerik.Reporting.TableBodyRow(new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch)));
// incomeTable.Body.SetCellContent(0, 0, txtIncomeDescription);
// incomeTable.Body.SetCellContent(0, 1, txtIncomeFrequency);
// incomeTable.Body.SetCellContent(0, 2, txtIncomeStartDate);
// incomeTable.Body.SetCellContent(0, 3, txtIncomeEndDate);
// incomeTable.Body.SetCellContent(0, 4, txtIncomeIncoming);
// incomeTable.Body.SetCellContent(0, 5, txtIncomeOutgoing);
// incomeTable.Body.SetCellContent(0, 6, txtIncomeAnnualAmount);
// tableGroupFirst.ReportItem = txtIncomeDescriptionColumn;
// tableGroupSecond.ReportItem = txtIncomeFrequencyColumn;
// tableGroupThird.ReportItem = txtIncomeStartDateColumn;
// //tableGroupFourth.Name = "Group1";
// tableGroupFourth.ReportItem = txtIncomeEndDateColumn;
// //tableGroupFifth.Name = "Group2";
// tableGroupFifth.ReportItem = txtIncomeIncomingColumn;
// //tableGroupSixth.Name = "Group3";
// tableGroupSixth.ReportItem = txtIncomeOutgoingColumn;
// //tableGroupSeventh.Name = "Group4";
// tableGroupSeventh.ReportItem = txtIncomeAnnualAmountColumn;
// incomeTable.ColumnGroups.Add(tableGroupFirst);
// incomeTable.ColumnGroups.Add(tableGroupSecond);
// incomeTable.ColumnGroups.Add(tableGroupThird);
// incomeTable.ColumnGroups.Add(tableGroupFourth);
// incomeTable.ColumnGroups.Add(tableGroupFifth);
// incomeTable.ColumnGroups.Add(tableGroupSixth);
// incomeTable.ColumnGroups.Add(tableGroupSeventh);
// DataTable dt = new DataTable();
// dt.Columns.Add("Description", typeof(string));
// dt.Columns.Add("Frequency", typeof(string));
// dt.Columns.Add("StartDate", typeof(string));
// dt.Columns.Add("EndDate", typeof(string));
// dt.Columns.Add("Income", typeof(string));
// dt.Columns.Add("Outgoing", typeof(string));
// dt.Columns.Add("AnnualAmount", typeof(string));
// dt.Columns.Add("Last", typeof(string));
// for (int i = 0; i < 5; i++)
// {
// dt.Rows.Add(i.ToString(), i.ToString(), i.ToString(), i.ToString(), i.ToString(), i.ToString(), i.ToString(),"Last");
// }
// DataSet ds = new DataSet();
// ds.Tables.Add(dt);
// // incomeTable.DataSource = ds;
// //incomeTable.DataSource = getDataSource("income");
// incomeTable.Items.AddRange(new Telerik.Reporting.ReportItemBase[]
// {
// txtIncomeDescription,
// txtIncomeFrequency,
// txtIncomeStartDate,
// txtIncomeEndDate,
// txtIncomeIncoming,
// txtIncomeOutgoing,
// txtIncomeAnnualAmount,
// txtIncomeDescriptionColumn,
// txtIncomeFrequencyColumn,
// txtIncomeStartDateColumn,
// txtIncomeEndDateColumn,
// txtIncomeIncomingColumn,
// txtIncomeOutgoingColumn,
// txtIncomeAnnualAmountColumn
// });
// incomeTable.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(3.929932790924795E-05D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.2800000011920929D, Telerik.Reporting.Drawing.UnitType.Inch));
// incomeTable.Name = "incomeTable";
// tableGroupEightth.Groupings.AddRange(new Telerik.Reporting.Data.Grouping[]
// {
// new Telerik.Reporting.Data.Grouping("")
// });
// tableGroupEightth.Name = "DetailGroup";
// incomeTable.RowGroups.Add(tableGroupEightth);
// incomeTable.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(7.187502384185791D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.40000000596046448D, Telerik.Reporting.Drawing.UnitType.Inch));
// #region "Rows"
// // txtIncomeDescription
// txtIncomeDescription.Name = "txtIncomeDescription";
// txtIncomeDescription.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.3020833730697632D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
// txtIncomeDescription.Value = "A";//"= Fields.Description";
// // txtIncomeFrequency
// txtIncomeFrequency.Name = "txtIncomeFrequency";
// txtIncomeFrequency.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.92708373069763184D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
// txtIncomeFrequency.Value = "A";//"= Fields.Frequency";
// // txtIncomeStartDate
// txtIncomeStartDate.Name = "txtIncomeStartDate";
// txtIncomeStartDate.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.80208361148834229D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
// txtIncomeStartDate.Value = "A";//"= Fields.StartDate";
// // txtIncomeEndDate
// txtIncomeEndDate.Name = "txtIncomeEndDate";
// txtIncomeEndDate.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.80208361148834229D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
// txtIncomeEndDate.Value = "A";//"= Fields.EndDate";
// // txtIncomeIncoming
// txtIncomeIncoming.Name = "txtIncomeIncoming";
// txtIncomeIncoming.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
// txtIncomeIncoming.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
// txtIncomeIncoming.Value = "A";//"= Fields.Income";//"=\'$\' + Fields.Income";
// // txtIncomeOutgoing
// txtIncomeOutgoing.Name = "txtIncomeOutgoing";
// txtIncomeOutgoing.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
// txtIncomeOutgoing.Value = "A";//"= Fields.Outgoing";
// // txtIncomeAnnualAmount
// txtIncomeAnnualAmount.Name = "txtIncomeAnnualAmount";
// txtIncomeAnnualAmount.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.3125003576278687D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
// txtIncomeAnnualAmount.Value = "A";//"= Fields.AnnualAmount";
// #endregion
// #region "SubTotal"
// //if (IsLast)
// {
// // txtIncomeSubTotal
// txtIncomeSubTotal.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(5.880000114440918D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.89999991655349731D, Telerik.Reporting.Drawing.UnitType.Inch));
// txtIncomeSubTotal.Name = "txtIncomeSubTotal";
// txtIncomeSubTotal.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.2800010442733765D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch));
// txtIncomeSubTotal.Style.Font.Bold = true;
// txtIncomeSubTotal.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(12D, Telerik.Reporting.Drawing.UnitType.Point);
// txtIncomeSubTotal.Value = "";//"=\'$\' + Fields.SubTotal";
// // txtIncomeSubTotalText
// txtIncomeSubTotalText.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(4.6399998664855957D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.89999991655349731D, Telerik.Reporting.Drawing.UnitType.Inch));
// txtIncomeSubTotalText.Name = "txtIncomeSubTOtalText";
// txtIncomeSubTotalText.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.0000003576278687D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch));
// txtIncomeSubTotalText.Style.Font.Bold = true;
// txtIncomeSubTotalText.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(12D, Telerik.Reporting.Drawing.UnitType.Point);
// txtIncomeSubTotalText.Value = "Sub Total :";
// }
// #endregion
// #region "Add Controls In panel"
// incomePanel.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
// txtIncomeText,
// incomeTable,
// txtIncomeSubTotalText,
// txtIncomeSubTotal,
// });
// #endregion
// #endregion
// return incomePanel;
// }
// catch (Exception ex)
// {
// if (log.IsErrorEnabled)
// log.Error("[" + System.DateTime.Now.ToString() + "] AnnualBudgetReport::GetDetailIncomeSection ", ex);
// throw;
// }
//}
//private Telerik.Reporting.PageHeaderSection pageHeaderSection1;
private Telerik.Reporting.DetailSection detail;
private Telerik.Reporting.PageFooterSection pageFooterSection1;
private Telerik.Reporting.Panel headerPanel;
private Telerik.Reporting.TextBox txtReportTitle;
private Telerik.Reporting.Panel pnlsubHeader;
private Telerik.Reporting.TextBox txtReportTitleDetail;
private Telerik.Reporting.TextBox txtTodayDate;
private Telerik.Reporting.TextBox txtTodayDateText;
private Telerik.Reporting.TextBox txtBudgetStartDate;
private Telerik.Reporting.Panel incomePanel;
private Telerik.Reporting.TextBox txtIncomeText;
private Telerik.Reporting.Table incomeTable;
private Telerik.Reporting.TextBox txtIncomeDescription;
private Telerik.Reporting.TextBox txtIncomeFrequency;
private Telerik.Reporting.TextBox txtIncomeStartDate;
private Telerik.Reporting.TextBox txtIncomeDescriptionColumn;
private Telerik.Reporting.TextBox txtIncomeFrequencyColumn;
private Telerik.Reporting.TextBox txtIncomeStartDateColumn;
private Telerik.Reporting.TextBox txtIncomeEndDate;
private Telerik.Reporting.TextBox txtIncomeIncoming;
private Telerik.Reporting.TextBox txtIncomeOutgoing;
private Telerik.Reporting.TextBox txtIncomeAnnualAmount;
private Telerik.Reporting.TextBox txtIncomeEndDateColumn;
private Telerik.Reporting.TextBox txtIncomeIncomingColumn;
private Telerik.Reporting.TextBox txtIncomeOutgoingColumn;
private Telerik.Reporting.TextBox txtIncomeAnnualAmountColumn;
private Telerik.Reporting.TextBox textBox2;
private Telerik.Reporting.TextBox textBox1;
private Telerik.Reporting.SqlDataSource sqlDataSource1;
private Panel GetDetailIncomeSection()
{
Panel incomePanel = new Panel();
Telerik.Reporting.TableGroup tableGroup1 = new Telerik.Reporting.TableGroup();
Telerik.Reporting.TableGroup tableGroup2 = new Telerik.Reporting.TableGroup();
Telerik.Reporting.TableGroup tableGroup3 = new Telerik.Reporting.TableGroup();
Telerik.Reporting.TableGroup tableGroup4 = new Telerik.Reporting.TableGroup();
Telerik.Reporting.TableGroup tableGroup5 = new Telerik.Reporting.TableGroup();
Telerik.Reporting.TableGroup tableGroup6 = new Telerik.Reporting.TableGroup();
Telerik.Reporting.TableGroup tableGroup7 = new Telerik.Reporting.TableGroup();
Telerik.Reporting.TableGroup tableGroup8 = new Telerik.Reporting.TableGroup();
this.txtIncomeDescriptionColumn = new Telerik.Reporting.TextBox();
this.txtIncomeFrequencyColumn = new Telerik.Reporting.TextBox();
this.txtIncomeStartDateColumn = new Telerik.Reporting.TextBox();
this.txtIncomeEndDateColumn = new Telerik.Reporting.TextBox();
this.txtIncomeIncomingColumn = new Telerik.Reporting.TextBox();
this.txtIncomeOutgoingColumn = new Telerik.Reporting.TextBox();
this.txtIncomeAnnualAmountColumn = new Telerik.Reporting.TextBox();
this.headerPanel = new Telerik.Reporting.Panel();
this.txtReportTitle = new Telerik.Reporting.TextBox();
this.pnlsubHeader = new Telerik.Reporting.Panel();
this.txtReportTitleDetail = new Telerik.Reporting.TextBox();
this.txtTodayDate = new Telerik.Reporting.TextBox();
this.txtTodayDateText = new Telerik.Reporting.TextBox();
this.txtBudgetStartDate = new Telerik.Reporting.TextBox();
this.incomePanel = new Telerik.Reporting.Panel();
this.txtIncomeText = new Telerik.Reporting.TextBox();
this.incomeTable = new Telerik.Reporting.Table();
this.txtIncomeDescription = new Telerik.Reporting.TextBox();
this.txtIncomeFrequency = new Telerik.Reporting.TextBox();
this.txtIncomeStartDate = new Telerik.Reporting.TextBox();
this.txtIncomeEndDate = new Telerik.Reporting.TextBox();
this.txtIncomeIncoming = new Telerik.Reporting.TextBox();
this.txtIncomeOutgoing = new Telerik.Reporting.TextBox();
this.txtIncomeAnnualAmount = new Telerik.Reporting.TextBox();
this.textBox2 = new Telerik.Reporting.TextBox();
this.textBox1 = new Telerik.Reporting.TextBox();
this.sqlDataSource1 = new Telerik.Reporting.SqlDataSource();
//
// txtIncomeDescriptionColumn
//
this.txtIncomeDescriptionColumn.Name = "txtIncomeDescriptionColumn";
this.txtIncomeDescriptionColumn.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.2999999523162842D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
this.txtIncomeDescriptionColumn.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))));
this.txtIncomeDescriptionColumn.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
this.txtIncomeDescriptionColumn.Style.BorderStyle.Left = Telerik.Reporting.Drawing.BorderType.Solid;
this.txtIncomeDescriptionColumn.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
this.txtIncomeDescriptionColumn.Style.Font.Bold = true;
this.txtIncomeDescriptionColumn.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
this.txtIncomeDescriptionColumn.Value = "Description";
//
// txtIncomeFrequencyColumn
//
this.txtIncomeFrequencyColumn.Name = "txtIncomeFrequencyColumn";
this.txtIncomeFrequencyColumn.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.92708373069763184D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
this.txtIncomeFrequencyColumn.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))));
this.txtIncomeFrequencyColumn.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
this.txtIncomeFrequencyColumn.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
this.txtIncomeFrequencyColumn.Style.Font.Bold = true;
this.txtIncomeFrequencyColumn.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
this.txtIncomeFrequencyColumn.Value = "Frequency";
//
// txtIncomeStartDateColumn
//
this.txtIncomeStartDateColumn.Name = "txtIncomeStartDateColumn";
this.txtIncomeStartDateColumn.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.84374964237213135D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
this.txtIncomeStartDateColumn.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))));
this.txtIncomeStartDateColumn.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
this.txtIncomeStartDateColumn.Style.BorderStyle.Right = Telerik.Reporting.Drawing.BorderType.None;
this.txtIncomeStartDateColumn.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
this.txtIncomeStartDateColumn.Style.Font.Bold = true;
this.txtIncomeStartDateColumn.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
this.txtIncomeStartDateColumn.Value = "Start Date";
//
// txtIncomeEndDateColumn
//
this.txtIncomeEndDateColumn.Name = "txtIncomeEndDateColumn";
this.txtIncomeEndDateColumn.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.80208361148834229D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
this.txtIncomeEndDateColumn.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))));
this.txtIncomeEndDateColumn.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
this.txtIncomeEndDateColumn.Style.BorderStyle.Right = Telerik.Reporting.Drawing.BorderType.None;
this.txtIncomeEndDateColumn.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
this.txtIncomeEndDateColumn.Style.Font.Bold = true;
this.txtIncomeEndDateColumn.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
this.txtIncomeEndDateColumn.StyleName = "";
this.txtIncomeEndDateColumn.Value = "End Date";
//
// txtIncomeIncomingColumn
//
this.txtIncomeIncomingColumn.Anchoring = Telerik.Reporting.AnchoringStyles.Left;
this.txtIncomeIncomingColumn.Name = "txtIncomeIncomingColumn";
this.txtIncomeIncomingColumn.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
this.txtIncomeIncomingColumn.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))));
this.txtIncomeIncomingColumn.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
this.txtIncomeIncomingColumn.Style.BorderStyle.Right = Telerik.Reporting.Drawing.BorderType.None;
this.txtIncomeIncomingColumn.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
this.txtIncomeIncomingColumn.Style.Font.Bold = true;
this.txtIncomeIncomingColumn.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
this.txtIncomeIncomingColumn.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Top;
this.txtIncomeIncomingColumn.StyleName = "";
this.txtIncomeIncomingColumn.Value = "Income";
//
// txtIncomeOutgoingColumn
//
this.txtIncomeOutgoingColumn.Anchoring = Telerik.Reporting.AnchoringStyles.Left;
this.txtIncomeOutgoingColumn.Name = "txtIncomeOutgoingColumn";
this.txtIncomeOutgoingColumn.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
this.txtIncomeOutgoingColumn.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))));
this.txtIncomeOutgoingColumn.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
this.txtIncomeOutgoingColumn.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
this.txtIncomeOutgoingColumn.Style.Font.Bold = true;
this.txtIncomeOutgoingColumn.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
this.txtIncomeOutgoingColumn.StyleName = "";
this.txtIncomeOutgoingColumn.Value = "Outgoing";
//
// txtIncomeAnnualAmountColumn
//
this.txtIncomeAnnualAmountColumn.Name = "txtIncomeAnnualAmountColumn";
this.txtIncomeAnnualAmountColumn.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.3125003576278687D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
this.txtIncomeAnnualAmountColumn.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))));
this.txtIncomeAnnualAmountColumn.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
this.txtIncomeAnnualAmountColumn.Style.BorderStyle.Right = Telerik.Reporting.Drawing.BorderType.Solid;
this.txtIncomeAnnualAmountColumn.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
this.txtIncomeAnnualAmountColumn.Style.Font.Bold = true;
this.txtIncomeAnnualAmountColumn.StyleName = "";
this.txtIncomeAnnualAmountColumn.Value = "Annual Amount";
// incomePanel
//
this.incomePanel.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.txtIncomeText,
this.incomeTable,
this.textBox2,
this.textBox1});
this.incomePanel.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(3.9378803194267675E-05D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.880000114440918D, Telerik.Reporting.Drawing.UnitType.Inch));
this.incomePanel.Name = "incomePanel";
this.incomePanel.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(7.1999998092651367D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(1.3000000715255737D, Telerik.Reporting.Drawing.UnitType.Inch));
//
// txtIncomeText
//
this.txtIncomeText.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.019999999552965164D, Telerik.Reporting.Drawing.UnitType.Inch));
this.txtIncomeText.Name = "txtIncomeText";
this.txtIncomeText.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.0898698568344116D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19996054470539093D, Telerik.Reporting.Drawing.UnitType.Inch));
this.txtIncomeText.Style.Font.Bold = true;
this.txtIncomeText.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(12D, Telerik.Reporting.Drawing.UnitType.Point);
this.txtIncomeText.Style.Font.Strikeout = false;
this.txtIncomeText.Style.Font.Underline = true;
this.txtIncomeText.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
this.txtIncomeText.Value = "Income";
//
// incomeTable
//
this.incomeTable.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(1.3020836114883423D, Telerik.Reporting.Drawing.UnitType.Inch)));
this.incomeTable.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(0.92708367109298706D, Telerik.Reporting.Drawing.UnitType.Inch)));
this.incomeTable.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(0.84374964237213135D, Telerik.Reporting.Drawing.UnitType.Inch)));
this.incomeTable.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(0.80208379030227661D, Telerik.Reporting.Drawing.UnitType.Inch)));
this.incomeTable.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(1.0000001192092896D, Telerik.Reporting.Drawing.UnitType.Inch)));
this.incomeTable.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(1.0000001192092896D, Telerik.Reporting.Drawing.UnitType.Inch)));
this.incomeTable.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(1.3125002384185791D, Telerik.Reporting.Drawing.UnitType.Inch)));
this.incomeTable.Body.Rows.Add(new Telerik.Reporting.TableBodyRow(new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch)));
this.incomeTable.Body.SetCellContent(0, 0, this.txtIncomeDescription);
this.incomeTable.Body.SetCellContent(0, 1, this.txtIncomeFrequency);
this.incomeTable.Body.SetCellContent(0, 2, this.txtIncomeStartDate);
this.incomeTable.Body.SetCellContent(0, 3, this.txtIncomeEndDate);
this.incomeTable.Body.SetCellContent(0, 4, this.txtIncomeIncoming);
this.incomeTable.Body.SetCellContent(0, 5, this.txtIncomeOutgoing);
this.incomeTable.Body.SetCellContent(0, 6, this.txtIncomeAnnualAmount);
tableGroup1.ReportItem = this.txtIncomeDescriptionColumn;
tableGroup2.ReportItem = this.txtIncomeFrequencyColumn;
tableGroup3.ReportItem = this.txtIncomeStartDateColumn;
tableGroup4.Name = "Group1";
tableGroup4.ReportItem = this.txtIncomeEndDateColumn;
tableGroup5.Name = "Group2";
tableGroup5.ReportItem = this.txtIncomeIncomingColumn;
tableGroup6.Name = "Group3";
tableGroup6.ReportItem = this.txtIncomeOutgoingColumn;
tableGroup7.Name = "Group4";
tableGroup7.ReportItem = this.txtIncomeAnnualAmountColumn;
this.incomeTable.ColumnGroups.Add(tableGroup1);
this.incomeTable.ColumnGroups.Add(tableGroup2);
this.incomeTable.ColumnGroups.Add(tableGroup3);
this.incomeTable.ColumnGroups.Add(tableGroup4);
this.incomeTable.ColumnGroups.Add(tableGroup5);
this.incomeTable.ColumnGroups.Add(tableGroup6);
this.incomeTable.ColumnGroups.Add(tableGroup7);
this.incomeTable.DataSource = this.sqlDataSource1;
this.incomeTable.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.txtIncomeDescription,
this.txtIncomeFrequency,
this.txtIncomeStartDate,
this.txtIncomeEndDate,
this.txtIncomeIncoming,
this.txtIncomeOutgoing,
this.txtIncomeAnnualAmount,
this.txtIncomeDescriptionColumn,
this.txtIncomeFrequencyColumn,
this.txtIncomeStartDateColumn,
this.txtIncomeEndDateColumn,
this.txtIncomeIncomingColumn,
this.txtIncomeOutgoingColumn,
this.txtIncomeAnnualAmountColumn});
this.incomeTable.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(3.929932790924795E-05D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.2800000011920929D, Telerik.Reporting.Drawing.UnitType.Inch));
this.incomeTable.Name = "incomeTable";
tableGroup8.Groupings.AddRange(new Telerik.Reporting.Data.Grouping[] {
new Telerik.Reporting.Data.Grouping("")});
tableGroup8.Name = "DetailGroup";
this.incomeTable.RowGroups.Add(tableGroup8);
this.incomeTable.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(7.187502384185791D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.40000000596046448D, Telerik.Reporting.Drawing.UnitType.Inch));
//
// txtIncomeDescription
//
this.txtIncomeDescription.Name = "txtIncomeDescription";
this.txtIncomeDescription.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.3020833730697632D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
//this.txtIncomeDescription.Value = "A";
this.txtIncomeDescription.Value = "= Fields.KEYWORD_ID";
//
// txtIncomeFrequency
//
this.txtIncomeFrequency.Name = "txtIncomeFrequency";
this.txtIncomeFrequency.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.92708373069763184D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
//this.txtIncomeFrequency.Value = "B";
this.txtIncomeFrequency.Value = "= Fields.KEYWORD";
//
// txtIncomeStartDate
//
this.txtIncomeStartDate.Name = "txtIncomeStartDate";
this.txtIncomeStartDate.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.84374970197677612D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
// this.txtIncomeStartDate.Value = "C";
this.txtIncomeStartDate.Value = "= Fields.ADGROUP_ID";
//
// txtIncomeEndDate
//
this.txtIncomeEndDate.Name = "txtIncomeEndDate";
this.txtIncomeEndDate.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.80208361148834229D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
this.txtIncomeEndDate.Style.BackgroundColor = System.Drawing.Color.Empty;
this.txtIncomeEndDate.StyleName = "";
//this.txtIncomeEndDate.Value = "D";
this.txtIncomeEndDate.Value = "= Fields.SYNC_STATE";
//
// txtIncomeIncoming
//
this.txtIncomeIncoming.Anchoring = Telerik.Reporting.AnchoringStyles.Left;
this.txtIncomeIncoming.Name = "txtIncomeIncoming";
this.txtIncomeIncoming.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
this.txtIncomeIncoming.Style.BackgroundColor = System.Drawing.Color.Empty;
this.txtIncomeIncoming.StyleName = "";
//this.txtIncomeIncoming.Value = "E";
this.txtIncomeIncoming.Value = "= Fields.VALIDATION_STATE";
//
// txtIncomeOutgoing
//
this.txtIncomeOutgoing.Anchoring = Telerik.Reporting.AnchoringStyles.Left;
this.txtIncomeOutgoing.Name = "txtIncomeOutgoing";
this.txtIncomeOutgoing.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
this.txtIncomeOutgoing.StyleName = "";
//this.txtIncomeOutgoing.Value = "F";
this.txtIncomeOutgoing.Value = "= Fields.LAST_UPDATED";
//
// txtIncomeAnnualAmount
//
this.txtIncomeAnnualAmount.Name = "txtIncomeAnnualAmount";
this.txtIncomeAnnualAmount.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.3125003576278687D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
this.txtIncomeAnnualAmount.StyleName = "";
//this.txtIncomeAnnualAmount.Value = "G";
this.txtIncomeAnnualAmount.Value = "= Fields.KWD_ENGINE_ID";
// textBox2
//
this.textBox2.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(4.6399998664855957D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.89999991655349731D, Telerik.Reporting.Drawing.UnitType.Inch));
this.textBox2.Name = "textBox2";
this.textBox2.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.0000003576278687D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch));
this.textBox2.Style.Font.Bold = true;
this.textBox2.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(12D, Telerik.Reporting.Drawing.UnitType.Point);
this.textBox2.Value = "Sub Total :";
//
// textBox1
//
this.textBox1.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(5.880000114440918D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.89999991655349731D, Telerik.Reporting.Drawing.UnitType.Inch));
this.textBox1.Name = "textBox1";
this.textBox1.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.2800010442733765D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch));
this.textBox1.Style.Font.Bold = true;
this.textBox1.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(12D, Telerik.Reporting.Drawing.UnitType.Point);
this.textBox1.Value = "$123456789";
//
// entityDataSource1
//
//
// sqlDataSource1
//
this.sqlDataSource1.ConnectionString = "SHMMSampleReport.Properties.Settings.SpringZipnew";
this.sqlDataSource1.Name = "sqlDataSource1";
this.sqlDataSource1.SelectCommand = "SELECT KEYWORD_ID, KEYWORD, ADGROUP_ID, SYNC_STATE, VALIDATION_STATE, LAST" +
"_UPDATED, KWD_ENGINE_ID\r\nFROM KEYWORD";
//
return incomePanel;
}
/// <summary>
/// This method is used to retrieve report detail section's outgoing detail.
/// </summary>
/// <param name="Description"></param>
/// <param name="Frequency"></param>
/// <param name="StartDate"></param>
/// <param name="EndDate"></param>
/// <param name="Income"></param>
/// <param name="Outgoing"></param>
/// <param name="AnnualAmount"></param>
/// <param name="SubTotal"></param>
/// <param name="GrandTotal"></param>
/// <returns>This method returns Report detail outgoing section.</returns>
private Panel GetDetailOutgoingSection()
{
#region "Declaration"
Panel outgoingPanel = new Panel();
Table telerikTable = new Table();
int initialCount = 0;
int columnHeaderCount = 7;
const double rowHeight = 0.2;
double width = 7.26D;
List<TextBox> headerTableBoxCollection = new List<TextBox>();
List<TextBox> bodyTableCollection = new List<TextBox>();
TextBox txtOutgoingText = new TextBox();
TextBox txtOutgoingDescriptionColumn = new TextBox();
TextBox txtOutgoingFrequencyColumn = new TextBox();
TextBox txtOutgoingStartDateColumn = new TextBox();
TextBox txtOutgoingEndDateColumn = new TextBox();
TextBox txtOutgoingIncomingColumn = new TextBox();
TextBox txtOutcomeOutgoingColumn = new TextBox();
TextBox txtOutgoingAnnualAmountColumn = new TextBox();
TextBox txtOutgoingAnnualAmount = new TextBox();
TextBox txtOutcomeOutgoing = new TextBox();
TextBox txtOutgoingIncoming = new TextBox();
TextBox txtOutgoingEndDate = new TextBox();
TextBox txtOutgoingStartDate = new TextBox();
TextBox txtOutgoingFrequency = new TextBox();
TextBox txtOutgoingDescription = new TextBox();
TextBox txtOutgoingSubTotalText = new TextBox();
TextBox txtOutgoingSubtotal = new TextBox();
TextBox txtGrandTotal = new TextBox();
TextBox txtGrandTotalText = new TextBox();
TextBox txtHorizontalLine = new TextBox();
#endregion
try
{
#region "Commented Area"
// if (RowNum == 0)
{
//outgoingPanel
outgoingPanel.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(2.3999998569488525D, Telerik.Reporting.Drawing.UnitType.Inch));
outgoingPanel.Name = "pnlOutgoing";
outgoingPanel.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(7.2604331970214844D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(1.3999999761581421D, Telerik.Reporting.Drawing.UnitType.Inch));
outgoingPanel.Style.BackgroundColor = System.Drawing.Color.White;
outgoingPanel.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.None;
// txtOutgoingText
txtOutgoingText.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.029999999329447746D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingText.Name = "txtOutgoingText";
txtOutgoingText.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.2794309854507446D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19996054470539093D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingText.Style.Font.Bold = true;
txtOutgoingText.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(12D, Telerik.Reporting.Drawing.UnitType.Point);
txtOutgoingText.Style.Font.Strikeout = false;
txtOutgoingText.Style.Font.Underline = true;
txtOutgoingText.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Left;
txtOutgoingText.Value = "Outgoing";
#region "Columns"
// txtOutgoingDescriptionColumn
txtOutgoingDescriptionColumn.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.25D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingDescriptionColumn.Name = "txtOutgoingDescriptionColumn";
txtOutgoingDescriptionColumn.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.3999212980270386D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000012218952179D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingDescriptionColumn.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))));
txtOutgoingDescriptionColumn.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
txtOutgoingDescriptionColumn.Style.BorderStyle.Left = Telerik.Reporting.Drawing.BorderType.Solid;
txtOutgoingDescriptionColumn.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
txtOutgoingDescriptionColumn.Style.Font.Bold = true;
txtOutgoingDescriptionColumn.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Left;
txtOutgoingDescriptionColumn.Value = "Description";
// txtOutgoingFrequencyColumn
txtOutgoingFrequencyColumn.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(1.4000000953674316D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.25D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingFrequencyColumn.Name = "txtOutgoingFrequencyColumn";
txtOutgoingFrequencyColumn.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.80000019073486328D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999980926513672D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingFrequencyColumn.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))));
txtOutgoingFrequencyColumn.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
txtOutgoingFrequencyColumn.Style.BorderStyle.Right = Telerik.Reporting.Drawing.BorderType.None;
txtOutgoingFrequencyColumn.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
txtOutgoingFrequencyColumn.Style.Font.Bold = true;
txtOutgoingFrequencyColumn.Value = "Frequency";
// txtOutgoingStartDateColumn
txtOutgoingStartDateColumn.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(2.2000000476837158D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.25D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingStartDateColumn.Name = "txtOutgoingStartDateColumn";
txtOutgoingStartDateColumn.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.800000011920929D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingStartDateColumn.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))));
txtOutgoingStartDateColumn.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
txtOutgoingStartDateColumn.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
txtOutgoingStartDateColumn.Style.Font.Bold = true;
txtOutgoingStartDateColumn.Value = "Start Date";
// txtOutgoingEndDateColumn
txtOutgoingEndDateColumn.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(3D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.25D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingEndDateColumn.Name = "txtOutgoingEndDateColumn";
txtOutgoingEndDateColumn.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.800000011920929D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingEndDateColumn.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))));
txtOutgoingEndDateColumn.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
txtOutgoingEndDateColumn.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
txtOutgoingEndDateColumn.Style.Font.Bold = true;
txtOutgoingEndDateColumn.Value = "End Date";
// txtOutgoingIncomingColumn
txtOutgoingIncomingColumn.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(3.8005897998809814D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.25D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingIncomingColumn.Name = "txtOutgoingIncomingColumn";
txtOutgoingIncomingColumn.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingIncomingColumn.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))));
txtOutgoingIncomingColumn.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
txtOutgoingIncomingColumn.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Double;
txtOutgoingIncomingColumn.Style.Font.Bold = true;
txtOutgoingIncomingColumn.Value = "Income";
// txtOutcomeOutgoingColumn
txtOutcomeOutgoingColumn.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(4.8006687164306641D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.25D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutcomeOutgoingColumn.Name = "txtOutcomeOutgoingColumn";
txtOutcomeOutgoingColumn.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.99968528747558594D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000012218952179D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutcomeOutgoingColumn.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))));
txtOutcomeOutgoingColumn.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
txtOutcomeOutgoingColumn.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
txtOutcomeOutgoingColumn.Style.Font.Bold = true;
txtOutcomeOutgoingColumn.Value = "Outgoing";
// txtOutgoingAnnualAmountColumn
txtOutgoingAnnualAmountColumn.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(5.8004326820373535D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.25D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingAnnualAmountColumn.Name = "txtOutgoingAnnualAmountColumn";
txtOutgoingAnnualAmountColumn.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.4600000381469727D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingAnnualAmountColumn.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))));
txtOutgoingAnnualAmountColumn.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
txtOutgoingAnnualAmountColumn.Style.BorderStyle.Right = Telerik.Reporting.Drawing.BorderType.Solid;
txtOutgoingAnnualAmountColumn.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
txtOutgoingAnnualAmountColumn.Style.Font.Bold = true;
txtOutgoingAnnualAmountColumn.Value = "Annual Amount";
#endregion
}
#region "Rows"
// txtOutgoingAnnualAmount
txtOutgoingAnnualAmount.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(5.7917060852050781D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.45007863640785217D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingAnnualAmount.Name = "txtOutgoingAnnualAmount";
txtOutgoingAnnualAmount.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.4527168273925781D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000012218952179D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingAnnualAmount.Value = "$100";
// txtOutcomeOutgoing
txtOutcomeOutgoing.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(4.8021225929260254D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.45007863640785217D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutcomeOutgoing.Name = "txtOutcomeOutgoing";
txtOutcomeOutgoing.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.98871421813964844D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutcomeOutgoing.Value = "$200";
// txtOutgoingIncoming
txtOutgoingIncoming.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(3.7917060852050781D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.45007863640785217D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingIncoming.Name = "txtOutgoingIncoming";
txtOutgoingIncoming.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.0006290674209595D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000012218952179D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingIncoming.Value = "$200";
// txtOutgoingEndDate
txtOutgoingEndDate.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(3.0000393390655518D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.45007863640785217D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingEndDate.Name = "txtOutgoingEndDate";
txtOutgoingEndDate.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.79158782958984375D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000012218952179D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingEndDate.Value = "01/01/2011";
// txtOutgoingStartDate
txtOutgoingStartDate.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(2.1979560852050781D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.45007863640785217D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingStartDate.Name = "txtOutgoingStartDate";
txtOutgoingStartDate.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.7999998927116394D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000012218952179D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingStartDate.Value ="01/01/2010";
// txtOutgoingFrequency
txtOutgoingFrequency.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(1.3958727121353149D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.45007863640785217D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingFrequency.Name = "txtOutgoingFrequency";
txtOutgoingFrequency.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.7999998927116394D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000012218952179D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingFrequency.Value = "Monthly";
// txtOutgoingDescription
txtOutgoingDescription.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(3.9418537198798731E-05D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.45007863640785217D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingDescription.Name = "txtOutgoingDescription";
txtOutgoingDescription.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.3926376104354858D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingDescription.Value = "ABC";
#endregion
// if (IsLast)
{
#region "SubTotal and GrandTotal"
// txtOutgoingSubTotalText
txtOutgoingSubTotalText.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(4.5999999046325684D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.75D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingSubTotalText.Name = "txtOutgoingSubTotalText";
txtOutgoingSubTotalText.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.0000003576278687D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingSubTotalText.Style.Font.Bold = true;
txtOutgoingSubTotalText.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(12D, Telerik.Reporting.Drawing.UnitType.Point);
txtOutgoingSubTotalText.Value = "Sub Total :";
// txtOutgoingSubtotal
txtOutgoingSubtotal.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(5.7899999618530273D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.75D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingSubtotal.Name = "txtOutgoingSubtotal";
txtOutgoingSubtotal.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.4439502954483032D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch));
txtOutgoingSubtotal.Style.Font.Bold = true;
txtOutgoingSubtotal.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(12D, Telerik.Reporting.Drawing.UnitType.Point);
txtOutgoingSubtotal.Value = "$1000";
;
// txtGrandTotal
txtGrandTotal.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(5.7899994850158691D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(1.1000789403915405D, Telerik.Reporting.Drawing.UnitType.Inch));
txtGrandTotal.Name = "txtGrandTotal";
txtGrandTotal.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.4439502954483032D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch));
txtGrandTotal.Style.Font.Bold = true;
txtGrandTotal.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(12D, Telerik.Reporting.Drawing.UnitType.Point);
txtGrandTotal.Value = "$500";
// txtGrandTotalText
txtGrandTotalText.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(4.4000000953674316D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(1.1000789403915405D, Telerik.Reporting.Drawing.UnitType.Inch));
txtGrandTotalText.Name = "txtGrandTotalText";
txtGrandTotalText.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.2004156112670898D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch));
txtGrandTotalText.Style.Font.Bold = true;
txtGrandTotalText.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(12D, Telerik.Reporting.Drawing.UnitType.Point);
txtGrandTotalText.Value = "Grand Total :";
// txtHorizontalLine
txtHorizontalLine.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(4.4000000953674316D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Inch));
txtHorizontalLine.Name = "txtHorizontalLine";
txtHorizontalLine.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(2.6700000762939453D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.0099999997764825821D, Telerik.Reporting.Drawing.UnitType.Inch));
txtHorizontalLine.Style.BackgroundColor = System.Drawing.Color.White;
txtHorizontalLine.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
txtHorizontalLine.Style.BorderWidth.Top = new Telerik.Reporting.Drawing.Unit(2D, Telerik.Reporting.Drawing.UnitType.Point);
txtHorizontalLine.Value = "";
#endregion
}
#region "Add Controls In panel"
// if (IsLast)
{
outgoingPanel.Items.AddRange(new Telerik.Reporting.ReportItemBase[]
{
txtOutgoingText,
txtOutgoingDescriptionColumn,
txtOutgoingFrequencyColumn,
txtOutgoingStartDateColumn,
txtOutgoingEndDateColumn,
txtOutgoingIncomingColumn,
txtOutcomeOutgoingColumn,
txtOutgoingAnnualAmountColumn,
txtOutgoingAnnualAmount,
txtOutcomeOutgoing,
txtOutgoingIncoming,
txtOutgoingEndDate,
txtOutgoingStartDate,
txtOutgoingFrequency,
txtOutgoingDescription,
txtOutgoingSubTotalText,
txtOutgoingSubtotal,
txtGrandTotal,
txtGrandTotalText,
txtHorizontalLine
}
);
}
#endregion
#endregion
return outgoingPanel;
}
catch (Exception ex)
{
if (log.IsErrorEnabled)
log.Error("[" + System.DateTime.Now.ToString() + "] AnnualBudgetReport::GetDetailOutgoingSection ", ex);
throw;
}
}
/// <summary>
/// This method is used to retrieve report detail section.
/// </summary>
/// <returns>This method returns report detail section.</returns>
private DetailSection GetReportDetailsection()
{
DetailSection reportDetailSection = new DetailSection();
try
{
// AnnualBudgetReportDetail
reportDetailSection.Height = new Telerik.Reporting.Drawing.Unit(8D, Telerik.Reporting.Drawing.UnitType.Inch);
Panel panelIncomeSection = GetDetailIncomeSection();
reportDetailSection.Items.AddRange(new Telerik.Reporting.ReportItemBase[]
{
GetHeaderPanel(),
panelIncomeSection
//GetDetailOutgoingSection(),
//GetDetailOutgoingSection()
}
);
reportDetailSection.Name = "AnnualBudgetReportDetail";
reportDetailSection.Style.BorderStyle.Left = Telerik.Reporting.Drawing.BorderType.None;
reportDetailSection.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
return reportDetailSection;
}
catch (Exception ex)
{
if (log.IsErrorEnabled)
log.Error("[" + System.DateTime.Now.ToString() + "] AnnualBudgetReport::GetReportDetailsection ", ex);
throw;
}
finally
{
//if (reportDetailSection != null)
// reportDetailSection = null;
}
}
#endregion
#region "Footer Section"
/// <summary>
/// This method is used to retrieve footer panel.
/// </summary>
/// <param name="pageNo">This parameter is the page number of report.</param>
/// <param name="todayDate">This parameter is today's date.</param>
/// <param name="footerText">This parameter is footer text.</param>
/// <returns>This method returns footer panel.</returns>
private Panel GetFooterPanel(string pageNo,string todayDate,string footerText)
{
Panel footerPanel = new Panel();
TextBox txtFooterPageNo = new TextBox();
TextBox txtFooterTodayDate = new TextBox();
TextBox txtFooterText = new TextBox();
try
{
//footerPanel
footerPanel.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0.82291668653488159D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.0416666679084301D, Telerik.Reporting.Drawing.UnitType.Inch));
footerPanel.Name = "footerPanel";
footerPanel.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(5.5999999046325684D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
// txtFooterPageNo
txtFooterPageNo.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(3.9418537198798731E-05D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(3.9418537198798731E-05D, Telerik.Reporting.Drawing.UnitType.Inch));
txtFooterPageNo.Name = "txtFooterPageNo";
txtFooterPageNo.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.51999998092651367D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000012218952179D, Telerik.Reporting.Drawing.UnitType.Inch));
txtFooterPageNo.Value = pageNo;
// txtFooterTodayDate
txtFooterTodayDate.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0.51999998092651367D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch));
txtFooterTodayDate.Name = "txtFooterTodayDate";
txtFooterTodayDate.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.60000008344650269D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000012218952179D, Telerik.Reporting.Drawing.UnitType.Inch));
txtFooterTodayDate.Value = todayDate;
// txtFooterText
txtFooterText.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(1.1200000047683716D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch));
txtFooterText.Name = "txtFooterText";
txtFooterText.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(4.4000000953674316D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
txtFooterText.Value = footerText;
footerPanel.Items.AddRange(new Telerik.Reporting.ReportItemBase[]
{
txtFooterPageNo,
txtFooterTodayDate,
txtFooterText
}
);
return footerPanel;
}
catch (Exception ex)
{
if (log.IsErrorEnabled)
log.Error("[" + System.DateTime.Now.ToString() + "] AnnualBudgetReport::GetFooterPanel ", ex);
throw;
}
}
/// <summary>
/// This method is used to retrieve report footer section.
/// </summary>
/// <returns>This method returns report footer section.</returns>
private PageFooterSection GetReportFooterSection()
{
PageFooterSection reportFooterSection = new PageFooterSection();
try
{
// AnnualBudgetReportFooter
reportFooterSection.Height = new Telerik.Reporting.Drawing.Unit(0.30000001192092896D, Telerik.Reporting.Drawing.UnitType.Inch);
reportFooterSection.Items.AddRange(new Telerik.Reporting.ReportItemBase[]
{
GetFooterPanel("1 of 1 ::","8/5/2011",":: www.MyHome.com :: My Software")
}
);
reportFooterSection.Name = "AnnualBudgetReportFooter";
reportFooterSection.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))), ((int)(((byte)(216)))));
return reportFooterSection;
}
catch (Exception ex)
{
if (log.IsErrorEnabled)
log.Error("[" + System.DateTime.Now.ToString() + "] AnnualBudgetReport::GetReportFooterSection ", ex);
throw;
}
}
#endregion
/// <summary>
/// This method is used to retrieve report data.
/// </summary>
/// <param name="type">This parameter is the type of data[imcome/outgoing].</param>
/// <returns>This method returns report data.</returns>
private DataTable getDataSource(string type)
{
BudgetViewModel objBudgetViewModel = new BudgetViewModel();
DataTable dtReportData = new DataTable();
try
{
ObservableCollection<UserItems> objUserItem = new ObservableCollection<UserItems>();
dtReportData.Columns.Add("Description", typeof(string));
dtReportData.Columns.Add("Frequency", typeof(string));
dtReportData.Columns.Add("StartDate", typeof(string));
dtReportData.Columns.Add("EndDate", typeof(string));
dtReportData.Columns.Add("Income", typeof(string));
dtReportData.Columns.Add("Outgoing", typeof(string));
dtReportData.Columns.Add("AnnualAmount", typeof(string));
// dtReportData.Columns.Add("SubTotal", typeof(string));
// dtReportData.Columns.Add("GrandTotal", typeof(string));
if (type.ToLower() == "income")
{
objUserItem = objBudgetViewModel.IncommingItemsCollection;
if (objUserItem != null && objUserItem.Count > 0)
{
_subTotal = 0;
foreach(UserItems item in objUserItem)
{
string frequency = objBudgetViewModel.GetFrequencyTypeByFrequencyID(Convert.ToInt32(item.FrequencyID));
_subTotal += Convert.ToDecimal(item.Total);
_grandTotal = _subTotal;
dtReportData.Rows.Add(item.Name, frequency, Convert.ToDateTime(item.StartDate).ToShortDateString(), Convert.ToDateTime(item.EndDate).ToShortDateString(), item.Amount.ToString(), "0.00", item.Total.ToString());//,_subTotal.ToString(), _grandTotal.ToString());
}
}
}
else
{
objUserItem = objBudgetViewModel.OutgoingItemsCollection;
if (objUserItem != null && objUserItem.Count > 0)
{
_subTotal = 0;
foreach (UserItems item in objUserItem)
{
string frequency = objBudgetViewModel.GetFrequencyTypeByFrequencyID(Convert.ToInt32(item.FrequencyID));
_subTotal += Convert.ToDecimal(item.Total);
_grandTotal -= Convert.ToDecimal(item.Total);
dtReportData.Rows.Add(item.Name, frequency, Convert.ToDateTime(item.StartDate).ToShortDateString(), Convert.ToDateTime(item.EndDate).ToShortDateString(), "0.00", item.Amount.ToString(), item.Total.ToString());//,_subTotal.ToString(), _grandTotal.ToString());
}
}
}
return dtReportData;
}
catch (Exception ex)
{
if (log.IsErrorEnabled)
log.Error("[" + System.DateTime.Now.ToString() + "] AnnualBudgetReport::getDataSource ", ex);
throw;
}
}
#endregion
#region "Public Methods"
#region "Add Report Sections to report"
/// <summary>
/// This method is used to combine report sections.
/// </summary>
/// <returns>This method returns complete report with header,deatil and footer section.</returns>
public Report GetAnnualBudgetReport()
{
Report annualBudgetReport = new Report();
try
{
// AnnualBudget
PageHeaderSection pageHeader = new PageHeaderSection();
pageHeader.Height = new Telerik.Reporting.Drawing.Unit(0.019999999552965164D, Telerik.Reporting.Drawing.UnitType.Inch);
pageHeader.Name = "pageHeaderSection1";
annualBudgetReport.Items.AddRange(new Telerik.Reporting.ReportItemBase[]
{
//GetReportHeaderSection(),
GetReportDetailsection(),
GetReportFooterSection()
}
);
annualBudgetReport.PageSettings.Landscape = false;
annualBudgetReport.PageSettings.Margins.Bottom = new Telerik.Reporting.Drawing.Unit(0.5D, Telerik.Reporting.Drawing.UnitType.Inch);
annualBudgetReport.PageSettings.Margins.Left = new Telerik.Reporting.Drawing.Unit(0.5D, Telerik.Reporting.Drawing.UnitType.Inch);
annualBudgetReport.PageSettings.Margins.Right = new Telerik.Reporting.Drawing.Unit(0.5D, Telerik.Reporting.Drawing.UnitType.Inch);
annualBudgetReport.PageSettings.Margins.Top = new Telerik.Reporting.Drawing.Unit(0.5D, Telerik.Reporting.Drawing.UnitType.Inch);
annualBudgetReport.PageSettings.PaperKind = System.Drawing.Printing.PaperKind.A4;
annualBudgetReport.Style.BackgroundColor = System.Drawing.Color.White;
annualBudgetReport.Width = new Telerik.Reporting.Drawing.Unit(7.2604727745056152D, Telerik.Reporting.Drawing.UnitType.Inch);
return annualBudgetReport;
}
catch (Exception ex)
{
if (log.IsErrorEnabled)
log.Error("[" + System.DateTime.Now.ToString() + "] AnnualBudgetReport::GetAnnualBudgetReport ", ex);
throw;
}
}
#endregion
#endregion
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
2 Answers, 1 is accepted
0
Randa
Top achievements
Rank 1
Rank 1
answered on 04 Apr 2012, 10:38 PM
I have the same problem but I am not using WPF and I have the Q2 2011 Telerik Reports in a web application with Visual Studio 2010
Can not get the details to bind to the table using datatable from a stored procedure.
Can you provide a sample other than the invoice summary one that show details of a table with grouping by a specific column and having total in the group footer.
Can not get the details to bind to the table using datatable from a stored procedure.
Can you provide a sample other than the invoice summary one that show details of a table with grouping by a specific column and having total in the group footer.
0
Hello Randa,
The Invoice demo report uses SubReport to show detail data, however it could be easily changed to use Table items instead. I've attached a modified Invoice report that uses Table item to show you how this is accomplished.
According to your description and the description of the original poster, the problem is with the binding itself. Are you by any chance using temporary tables in your stored procedure? If that is the case, check the following forum thread.
Kind regards,
Steve
the Telerik team
The Invoice demo report uses SubReport to show detail data, however it could be easily changed to use Table items instead. I've attached a modified Invoice report that uses Table item to show you how this is accomplished.
According to your description and the description of the original poster, the problem is with the binding itself. Are you by any chance using temporary tables in your stored procedure? If that is the case, check the following forum thread.
Kind regards,
Steve
the Telerik team
NEW in Q1'12: Telerik Report Designer (Beta) for ad-hoc report creation. Download as part of Telerik Reporting Q1 2012. For questions and feedback, use the new Telerik Report Designer Forum.