I want to use telerik reporting & Dotnetnuke.
Where can I put report.vb on dotnetnuke source code and how can I read ConnectionString.
I want to use store procdedure on telerik Reporting with parameters of store.

Thanks so much.
Excuse my english.

Hello,

I'm making a report that restricts data to definable time span. I made two parameters: dateFrom and dateTo. Obviously dateFrom can't be bigger than dateTo. Hence my question: it there possibility to set max and min values to parameters of DateTime type? 

In this case max value of dateTo parameter would be today's date and max value of dateFrom parameter would be dateTo's value. Paramater dateFrom wouldn't have min value, but dateTo's min value would be value of dateFrom parameter. 

That's the scenario. I just need help with implementing it. :)

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


---------------------------------------------------------------------------------------------------------------------------------------------------------------------

Help i would like to number my rows of data like;
    Student Name | Marks Attained | Final Grade
1. John Denis      |  60                    | 45
2.  Mark Evans    | 90                     |50
3.  Clare              | 78                     | 90

what function can i use any where do i use it?
I have trie Row Number for Coloring the different Rows(i.e RowNumber()%2 = 1 in conditional  formating ) but cant number the rows.

Hello, 

Does Telerik Reporting support query builder for cubes as Microsoft reporting? If it is not supported, is it planned to be included soon in the releases?

Kind regards,
Teodora.

Hi,
I'm creating a report right now and i'd like to know how could i set a delimiter of my own choice for the CSV rendering in export functionnality. I've searched but i haven't found a solution. I only know it wasn't possible in March 2011, so is it possible now, and how to?
Thanks for replies and sorry about my crappy english!

Hello, i´m using 

RadControls_for_Silverlight4_2011_3_1220_Dev
Telerik_Reporting_Q1_2012_v6_0_12_215_Dev.msi

And i get the error.

Could help me?

thanks.

{System.InvalidCastException: Specified cast is not valid.
   em Telerik.ReportViewer.Silverlight.ZoomConverter.Convert(Object value, Type targetType, Object parameter, CultureInfo culture)
   em System.Windows.Data.BindingExpression.ConvertToTarget(Object value)
   em System.Windows.Data.BindingExpression.UpdateTemporaryValue()
   em System.Windows.Data.BindingExpression.GetValue(DependencyObject d, DependencyProperty dp)
   em System.Windows.DependencyObject.EvaluateExpression(DependencyProperty property, EffectiveValueEntry oldEntry, EffectiveValueEntry& newEntry)
   em System.Windows.DependencyObject.EvaluateBaseValue(DependencyProperty property, EffectiveValueEntry oldEntry, EffectiveValueEntry& newEntry, ValueOperation operation)
   em System.Windows.DependencyObject.EvaluateEffectiveValue(DependencyProperty property, EffectiveValueEntry oldEntry, EffectiveValueEntry newEntry, ValueOperation operation)
   em System.Windows.DependencyObject.UpdateEffectiveValue(DependencyProperty property, EffectiveValueEntry oldEntry, EffectiveValueEntry& newEntry, ValueOperation operation)
   em System.Windows.DependencyObject.RefreshExpression(DependencyProperty dp)
   em System.Windows.Data.BindingExpression.SendDataToTarget()
   em System.Windows.Data.BindingExpression.SourceAcquired()
   em System.Windows.Data.Debugging.BindingBreakPoint.<>c__DisplayClass4.<BreakOnSharedType>b__3()}

I am using RadEditor to create content for use in the HtmlTextBox item. I have the following problem. The HtmlTextBox does not support <span style="text-decoration: underline;"> markup for underline and instead supports <u></u> but the RadEditor outputs <span style="text-decoration: underline;">. I assume this is because the RadEditor is XHTML compliant and the <u> tag is deprecated. Is there any workaround for this issue?  I am investigating creating a content filter for RadEditor to handle this but wanted to check to see if there is a simpler solution.

Hi,
Why show me this error?
"Error loading extension type with name Telerik.Reporting.ExcelRendering.Excel97.ExcelReport, Telerik.Reporting, Version=5.3.12.119 Culture=neutral, PublicKeyToken=a9d7983dfcc261be.
The given assembly name or codebase was invalid. (Exception from HRESULT: 0x80131047)"
This happend when i want view a report.
We are do a testing to telerik, we want to purchase it. 
This error is because we have the trial version?.

Sorry for my english language, I from Colombia.

Thanks.

hi all ..
At the View, the hyperlink is displayed correctly.
The hyperlink field is called Apellido.
View
but .. when exported to PDF, it generates a black box in the field with hyperlink.
PDF
Is it possible to remove the black box? or make invisible the field "Apellido"?

please,Help Me!