Hi,

I'm hitting an error building the Reporting samples (or any other project using them):

Error 1 The tag 'ReportViewer' does not exist in XML namespace 'clr-namespace:Telerik.ReportViewer.Silverlight;assembly=Telerik.ReportViewer.Silverlight'. C:\Program Files (x86)\Telerik\Reporting Q3 2011\Examples\CSharp\SilverlightDemo\MainPage.xaml 48 14 CSharp.SilverlightDemo

* Telerik Reporting Q3 2011 SP1 (5.3.12.119)
* Visual Studio 2010 Ultimate (10.0.40219.1 SP1Rel)
* Building C# Silverlight applications

What I've found so far:
1. The samples (and my own applications) work fine on multiple Windows Server 2003 environments that I've tried it on.
2. The samples (and my own applications) all fail to compile on the one Windows Server 2008 R2 environment that I've tried it on. Not certain if the OS difference is a factor, or if this is just a coincidence.
3. Uninstalling / re-installing Telerik Reporting on the Windows Server 2008 R2 environment has not resolved it.
4. Yes, I am running Visual Studio as an Administrator.
5. Commenting out the ReportViewer in the .xaml file and creating it programmatically in the .cs file works fine.
6. Autocomplete when editing the .xaml works fine and appears to correctly resolve; however, compilation fails.
7. Other Telerik components are NOT affected. RadControls for Silverlight works great on all environments.

Any thoughts on what I should look at next? Any assistance appreciated...

Thanks,

William Cook

Hello,

I tried to define a project SqlDataSource using a stored procedure. I defined it with a default value as required in order to see it in the Data Explorer. However, when I go to select the table item I applied the data source to, the Data Explorer shows No Data Source.

I used SQL Profiler to see what was happening. When I click on the data source at the bottom of the designer it executes the stored procedure with all parameters as null, thus returning no result set.

I opened the SqlDataSource component I created and it does have the parameter defined with a default value.

Oh, and if you select Preview it returns data.

Any help would be appreciated.

I ran into the following issue when trying to build a report and although I finally found the answer in Telerik's documentation it wasn't without some lost productivity.  Perhaps this thread can help out some other developers.

Scenario:
So I was working on the visual representation on a number of .aspx web pages and
I had to switch over to create a report that was a form letter.  My typical process when I develop in this fashion is to...

1. Develop the report without a data source
2. Call the report programmatically and give it a data source
3. Output the report to the web viewer, pdf or some other export format

In the form letter I wanted to create a date in a certain format and an inside address for the letter.  I created two user
functions to accomplish this. [Note:  If you haven't looked into using user functions for your Telerik reports then I would
recommend doing so as Telerik has provided a powerful mechanism for extending functionality].

In my Telerik Reporting Class Library, I added a class file named UserFunctions.vb  Here is the code:

The first function GetAddress takes several input parameters and builds an address.  The second function GetLetterDate() returns a date in the format (April 5, 2012).

This information I wanted to go into the Report Header section.  (Here is my mistake!!!)  Since I wanted the info of these 2 User Functions to show up side by side, I dropped a Table into the Report Header section of my Report.  I re-formatted the table to 1 row with 2 columns and entered the correct syntax for calling the user functions.  When I ran the report, my GetAddress function returned an empty string.  What was going on?

After wasting a decent amount of time, troubleshooting I finally figured out that the inputs to the GetAddress function were empty.  Why would the data source data be empty?  It wasn't when I passed it in.

Several days later (after solving the problem in a completely different way), I came across the following line in Telerik's documentation:

The Table report item is a separate data region and does not make use of the report's data source. It has its own Table..::.DataSource property which you have to set in order to populate the item with data.

And that was my whole problem!  I gave the Report a Data Source programmically.

But I never gave the Table a Data Source (which can easily be accomplished with the following event code in the report itself)

Now, my whole problem started because I had carried over a style practice from web pages (using tables to line things up) to Telerik.Reporting (which does not need tables to align columns).

So, here were the learnings on my part...

1. Make sure that your guidelines and practices apply to your environment  (I was in Telerik Reporting not web pages)
2. Always keep in mind that there usually is a simpler way to solve your current dilemma (I didn't need tables to align items in Reporting)
3. Telerik Reporting Tables require their own data sources!!!

I am attaching a PDF test report that shows the differences of using a Table with and without its' own data source.

Reporting 1.5

I have a letter style report with some data in the details section and several subreports.  Prior to any subreport, the details section has a report wide, "can grow" text box containing variable length summary text information.  When exporting to PDF, if the textbox is too long to be rendered completely on the first page, the report page breaks before the textbox rendering.  This leaves a large blank space on the first page.  The details section has Keeptogether explicity set to false.  Any ideas on how to cause this to be paginated correctly?

Hiya.  I'm using Telerik Q3 2011 in Visual Studios 2010 on a machine running Windows 7.  I am new to Telerik and  learning the basics.  I am having trouble with the syntax for a parameter where multiple values will be allowed.  Currently I have the following in the sql query:


This works fine if the parameter is set to single value.  However when I change the parameter to multi value and select multiple choices I get an error saying the sql query is not ended properly.

I have tried eliminating the parantheses with no luck.  I tried an = sign instead of "in" (not logical I know, but I tried it anyway), also without success.

Can someone tell me what I am doing wrong with the syntax?

Thanks!

Kevin

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.