Ejemplo n.º 1
0
        private void ReadPageFooterBand(XmlNode node, StiPage page)
        {
            StiPageFooterBand band = new StiPageFooterBand();

            page.Components.Add(band);

            ReadBand(node, band);
        }
Ejemplo n.º 2
0
        public IReportBuilder WithPageFooterBand(double height = 0.2)
        {
            CurrentPageFooter = new StiPageFooterBand(MakeRectangle(0, 0, 0, height));
            Page.Components.Add(CurrentPageFooter);

            CurrentPageFooter.BeforePrintEvent = new StiBeforePrintEvent("Xdec=Xdec+1;");
            CurrentPageFooter.AfterPrintEvent  = new StiAfterPrintEvent("Xdec=Xdec+1;");

            return(this);
        }
Ejemplo n.º 3
0
        private void ReadBottomMarginBand(XtraReportBase xtraReport, BottomMarginBand xtraBand, StiPage page)
        {
            StiPageFooterBand band = new StiPageFooterBand();

            page.Components.Add(band);

            ReadBand(xtraBand, band);

            page.Margins.Bottom = page.Margins.Bottom - report.Unit.ConvertToHInches(band.Height);
        }
Ejemplo n.º 4
0
        private static void AddFooter(ref StiPage page)
        {
            #region Footer

            //Create FooterBand
            StiPageFooterBand FooterBand = new StiPageFooterBand();
            FooterBand.Height  = 0.5;
            FooterBand.Name    = "FooterBandBand";
            FooterBand.Enabled = true;
            page.Components.Add(FooterBand);

            ////Create countText text on Footer
            //StiText countText = new StiText(new RectangleD(0, 0, page.Width, 0.85));
            //countText.Text = dataSet.Tables[0].Rows.Count.ToString();
            //countText.HorAlignment = StiTextHorAlignment.Right;
            //countText.Name = "countText";
            //FooterBand.Components.Add(countText);

            #endregion Footer
        }
Ejemplo n.º 5
0
        private void CreateReport(DataTable table, DataGridView dgv, string title, string subtitle)
        {
            StiReport          report      = new StiReport();
            StiDataTableSource sourceTable = new StiDataTableSource("DS", "DS", "DS");

            report.Dictionary.DataSources.Add(sourceTable);
            report.RegData("DS", "DS", table);
            sourceTable.SynchronizeColumns();


            StiPage page = report.Pages.Items[0];

            page.Orientation = StiPageOrientation.Landscape;
            double pageW = page.Width;
            double pageH = page.Height;

            //============заголовок
            StiText headerReport = new StiText(new RectangleD(new PointD(0, 0), new SizeD(pageW, 0.6)),
                                               "Заголовок1");

            headerReport.Font         = new Font("Arial", 10, FontStyle.Bold);
            headerReport.HorAlignment = StiTextHorAlignment.Center;
            headerReport.Text         = "История обработок";

            StiText subtitleReport = new StiText(new RectangleD(new PointD(0, 0.6), new SizeD(pageW, 0.4)),
                                                 "Подзаголовок1");

            subtitleReport.Font         = new Font("Arial", 10, FontStyle.Regular);
            subtitleReport.HorAlignment = StiTextHorAlignment.Center;
            subtitleReport.Text         = subtitle;

            PointD BrandLoc = new PointD(0, 0.4);

            //хедер рапорта
            StiReportTitleBand headerPage = new StiReportTitleBand(new RectangleD(BrandLoc, new SizeD(pageW, 1.2)));

            page.Components.Add(headerPage);
            headerPage.Components.Add(headerReport);
            headerPage.Components.Add(subtitleReport);


            //хедер таблицы
            BrandLoc = new PointD(0, 1.2);
            StiHeaderBand headerTable = new StiHeaderBand(new RectangleD(BrandLoc, new SizeD(pageW, 0.6)));

            page.Components.Add(headerTable);

            //область данных
            PointD      BrandDataLoc = new PointD(0, 1.8);
            StiDataBand BrandData    = new StiDataBand(new RectangleD(BrandDataLoc, new SizeD(pageW, 0.4)));

            page.Components.Add(BrandData);
            BrandData.DataSourceName = "DS";

            StiPageFooterBand FooterBand = new StiPageFooterBand();

            page.Components.Add(FooterBand);
            FooterBand.Height = 0.6;

            StiText FooterNameTxt = new StiText(new RectangleD(0, 0, pageW, 0.6));

            FooterNameTxt.Text                       = title;
            FooterNameTxt.ShrinkFontToFit            = true;
            FooterNameTxt.HorAlignment               = StiTextHorAlignment.Right;
            FooterNameTxt.ShrinkFontToFitMinimumSize = 8;


            StiText FooterTxt = new StiText(new RectangleD(0, 0, 1, 0.6));

            FooterTxt.Text                       = "Лист {PageNumber}";
            FooterTxt.ShrinkFontToFit            = true;
            FooterTxt.ShrinkFontToFitMinimumSize = 8;
            FooterBand.Components.Add(FooterNameTxt);
            FooterBand.Components.Add(FooterTxt);

            StiText TimeText = new StiText(new RectangleD(-0.2, -0.4, 3, 0.6));

            TimeText.Text                       = "{Time}";
            TimeText.ShrinkFontToFit            = true;
            TimeText.ShrinkFontToFitMinimumSize = 8;
            page.Components.Add(TimeText);

            double numWidth = .5;

            double Wkoef = pageW / GetColumnWidth(table, dgv);
            double prevX = 0; //numWidth;

            //StiText headerNum = new StiText(new RectangleD(BrandLoc.X, 0, numWidth, 0.4));
            //headerNum.Border.Side = StiBorderSides.All;
            //headerNum.Border.Size = 1.5;
            //headerNum.Text = "N п/п";
            //headerNum.Font = new Font("Arial", 8, FontStyle.Bold);
            //headerNum.HorAlignment = StiTextHorAlignment.Center;
            //headerNum.ShrinkFontToFit = true;
            //headerNum.ShrinkFontToFitMinimumSize = 8;
            //headerTable.Components.Add(headerNum);

            //StiText dataNum = new StiText(new RectangleD(BrandLoc.X, 0, numWidth, 0.4));
            //dataNum.Border.Side = StiBorderSides.All;
            //dataNum.ShrinkFontToFit = true;
            //dataNum.ShrinkFontToFitMinimumSize = 8;
            //dataNum.Text = "{Line}";
            //dataNum.HorAlignment = StiTextHorAlignment.Right;
            //dataNum.Font = new Font("Arial", 8, FontStyle.Regular);
            //BrandData.Components.Add(dataNum);

            foreach (DataColumn column in table.Columns) //добалвляем в область заголовка и в область данных
            {
                string             colName   = column.ColumnName;
                DataGridViewColumn dgvColumn = dgv.Columns[colName];

                StiText headerTXT = new StiText(new RectangleD(BrandLoc.X + prevX, 0,
                                                               dgvColumn.Width * Wkoef, 0.4));
                headerTXT.Border.Side                = StiBorderSides.All;
                headerTXT.Border.Size                = 1.5;
                headerTXT.Text                       = dgvColumn.HeaderText;
                headerTXT.Font                       = new Font("Arial", 8, FontStyle.Bold);
                headerTXT.HorAlignment               = StiTextHorAlignment.Center;
                headerTXT.ShrinkFontToFit            = true;
                headerTXT.ShrinkFontToFitMinimumSize = 8;

                headerTable.Components.Add(headerTXT);
                StiText dataTXT = new StiText(new RectangleD(BrandLoc.X + prevX, 0,
                                                             dgvColumn.Width * Wkoef, 0.4));
                dataTXT.Border.Side                = StiBorderSides.All;
                dataTXT.ShrinkFontToFit            = true;
                dataTXT.ShrinkFontToFitMinimumSize = 8;
                dataTXT.Font = new Font("Arial", 8, FontStyle.Regular);

                if (column.DataType == typeof(bool))
                {
                    dataTXT.Text = "{IIF(DS." + colName + ", \"+\", \"\")}";
                }
                else
                {
                    dataTXT.Text = "{DS." + colName + "}";
                }

                if (column.DataType == typeof(DateTime))
                {
                    string dateFormat = "dd.MM.yyyy HH:mm";
                    dataTXT.TextFormat = new StiDateFormatService(dateFormat, "");
                }

                if (column.DataType == typeof(double))
                {
                    dataTXT.TextFormat = new StiNumberFormatService(1, ".", 1, ",", 3, true, true, " ");
                }


                switch (dgvColumn.DefaultCellStyle.Alignment)
                {
                case DataGridViewContentAlignment.BottomCenter:
                case DataGridViewContentAlignment.MiddleCenter:
                case DataGridViewContentAlignment.TopCenter:
                    dataTXT.HorAlignment = StiTextHorAlignment.Center;
                    break;

                case DataGridViewContentAlignment.BottomLeft:
                case DataGridViewContentAlignment.MiddleLeft:
                case DataGridViewContentAlignment.TopLeft:
                    dataTXT.HorAlignment = StiTextHorAlignment.Left;
                    break;

                case DataGridViewContentAlignment.BottomRight:
                case DataGridViewContentAlignment.MiddleRight:
                case DataGridViewContentAlignment.TopRight:
                    dataTXT.HorAlignment = StiTextHorAlignment.Right;
                    break;
                }

                BrandData.Components.Add(dataTXT);

                prevX += dgvColumn.Width * Wkoef;
            }

            report.Show();
        }
Ejemplo n.º 6
0
 private void InitializeComponent()
 {
     T_Detail = new T_DetailDataSource();
     Dictionary.Variables.Add(new StiVariable("", "MyCompanyName", "MyCompanyName", "", typeof(string), "", false, false, false));
     Dictionary.Variables.Add(new StiVariable("", "MyCompanyTaxCode", "MyCompanyTaxCode", "", typeof(string), "", false, false, false));
     Dictionary.Variables.Add(new StiVariable("", "MyCompanyDirectorName", "MyCompanyDirectorName", "", typeof(string), "", false, false, false));
     Dictionary.Variables.Add(new StiVariable("", "MyCompanyCountryCode", "MyCompanyCountryCode", "", typeof(string), "", false, false, false));
     Dictionary.Variables.Add(new StiVariable("", "MyCompanyCountryName", "MyCompanyCountryName", "", typeof(string), "", false, false, false));
     Dictionary.Variables.Add(new StiVariable("", "MyCompanyCity", "MyCompanyCity", "", typeof(string), "", false, false, false));
     Dictionary.Variables.Add(new StiVariable("", "MyCompanyPostalCode", "MyCompanyPostalCode", "", typeof(string), "", false, false, false));
     Dictionary.Variables.Add(new StiVariable("", "MyCompanyAddress", "MyCompanyAddress", "", typeof(string), "", false, false, false));
     Dictionary.Variables.Add(new StiVariable("", "MyCompanyPhone", "MyCompanyPhone", "", typeof(string), "", false, false, false));
     Dictionary.Variables.Add(new StiVariable("", "MyCompanyFax", "MyCompanyFax", "", typeof(string), "", false, false, false));
     Dictionary.Variables.Add(new StiVariable("", "MyCompanyBankName", "MyCompanyBankName", "", typeof(string), "", false, false, false));
     Dictionary.Variables.Add(new StiVariable("", "MyCompanyBankCode", "MyCompanyBankCode", "", typeof(string), "", false, false, false));
     Dictionary.Variables.Add(new StiVariable("", "MyCompanyBankAccountNumber", "MyCompanyBankAccountNumber", "", typeof(string), "", false, false, false));
     Dictionary.Variables.Add(new StiVariable("", "MyCompanyVATPayerFlag", "MyCompanyVATPayerFlag", "", typeof(bool), "", false, false, false));
     Dictionary.Variables.Add(new StiVariable("", "MyCompanyConditionalUnitCurrencyCode", "MyCompanyConditionalUnitCurrencyCode", "", typeof(string), "", false, false, false));
     Dictionary.Variables.Add(new StiVariable("", "MyCompanyDefaultTradingCurrencyCode", "MyCompanyDefaultTradingCurrencyCode", "", typeof(string), "", false, false, false));
     Dictionary.Variables.Add(new StiVariable("", "MyCompanyConditionalUnitCurrencyRate", "MyCompanyConditionalUnitCurrencyRate", "", typeof(decimal), "", false, false, false));
     NeedsCompiling = false;
     // Variables init
     // Variables init
     MyCompanyName                        = "";
     MyCompanyTaxCode                     = "";
     MyCompanyDirectorName                = "";
     MyCompanyCountryCode                 = "";
     MyCompanyCountryName                 = "";
     MyCompanyCity                        = "";
     MyCompanyPostalCode                  = "";
     MyCompanyAddress                     = "";
     MyCompanyPhone                       = "";
     MyCompanyFax                         = "";
     MyCompanyBankName                    = "";
     MyCompanyBankCode                    = "";
     MyCompanyBankAccountNumber           = "";
     MyCompanyVATPayerFlag                = false;
     MyCompanyConditionalUnitCurrencyCode = "";
     MyCompanyDefaultTradingCurrencyCode  = "";
     MyCompanyConditionalUnitCurrencyRate = 0m;
     EngineVersion                        = StiEngineVersion.EngineV2;
     ReferencedAssemblies                 = new[] {
         "System.Dll",
         "System.Drawing.Dll",
         "System.Windows.Forms.Dll",
         "System.Data.Dll",
         "System.Xml.Dll",
         "Stimulsoft.Controls.Dll",
         "Stimulsoft.Base.Dll",
         "Stimulsoft.Report.Dll"
     };
     ReportAlias  = "Rpt Produc Location Price";
     ReportAuthor = "Programmer.GE";
     //
     // ReportChanged
     //
     ReportChanged = new DateTime(2011, 6, 12, 21, 55, 48, 0);
     //
     // ReportCreated
     //
     ReportCreated     = new DateTime(2009, 6, 28, 22, 3, 23, 0);
     ReportDescription = "პრაისი";
     ReportFile        = "D:\\User\\Documents\\Projects\\Apothex\\Source\\Class Library\\Apothex.Reporting\\Product" +
                         "ion\\RptProducLocationPrice.mrt";
     ReportGuid     = "e242476ffaeb44b39344532841ed84f0";
     ReportName     = "RptProducLocationPrice";
     ReportUnit     = StiReportUnitType.Centimeters;
     ReportVersion  = "2010.3.900";
     ScriptLanguage = StiReportLanguageType.CSharp;
     //
     // Page1
     //
     Page1            = new StiPage();
     Page1.Columns    = 2;
     Page1.Guid       = "0edad2017ef5402da56612e0faa7a32a";
     Page1.Name       = "Page1";
     Page1.PageHeight = 29.7;
     Page1.PageWidth  = 21;
     Page1.PaperSize  = PaperKind.A4;
     Page1.Border     = new StiBorder(StiBorderSides.None, Color.Black, 2, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
     Page1.Brush      = new StiSolidBrush(Color.Transparent);
     //
     // PageHeaderBand1
     //
     PageHeaderBand1 = new StiPageHeaderBand();
     PageHeaderBand1.ClientRectangle = new RectangleD(0, 0.4, 20, 2.2);
     PageHeaderBand1.Name            = "PageHeaderBand1";
     PageHeaderBand1.PrintOn         = StiPrintOnType.OnlyFirstPage;
     PageHeaderBand1.Border          = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
     PageHeaderBand1.Brush           = new StiSolidBrush(Color.Transparent);
     //
     // Text4
     //
     Text4 = new StiText();
     Text4.ClientRectangle = new RectangleD(2.4, 0, 7.6, 2);
     Text4.Name            = "Text4";
     Text4.GetValue       += new StiGetValueEventHandler(Text4__GetValue);
     Text4.VertAlignment   = StiVertAlignment.Center;
     Text4.Border          = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
     Text4.Brush           = new StiSolidBrush(Color.Transparent);
     Text4.Font            = new Font("BPG Glaho Arial", 7F, FontStyle.Bold);
     Text4.Guid            = null;
     Text4.Interaction     = null;
     Text4.Margins         = new StiMargins(0, 0, 0, 0);
     Text4.TextBrush       = new StiSolidBrush(Color.Black);
     Text4.TextOptions     = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
     //
     // Image1
     //
     Image1                      = new StiImage();
     Image1.AspectRatio          = true;
     Image1.ClientRectangle      = new RectangleD(0, 0, 2, 2);
     Image1.Guid                 = "b4725dd4d92a41f5a0f373916b5b430e";
     Image1.HorAlignment         = StiHorAlignment.Center;
     Image1.Name                 = "Image1";
     Image1.Stretch              = true;
     Image1.VertAlignment        = StiVertAlignment.Center;
     Image1.Border               = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
     Image1.Brush                = new StiSolidBrush(Color.Transparent);
     Image1.Image                = null;
     Image1.Interaction          = null;
     PageHeaderBand1.Guid        = null;
     PageHeaderBand1.Interaction = null;
     //
     // PageFooterBand1
     //
     PageFooterBand1 = new StiPageFooterBand();
     PageFooterBand1.ClientRectangle = new RectangleD(0, 28.1, 20, 0.6);
     PageFooterBand1.Name            = "PageFooterBand1";
     PageFooterBand1.Border          = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
     PageFooterBand1.Brush           = new StiSolidBrush(Color.Transparent);
     //
     // Text3
     //
     Text3 = new StiText();
     Text3.ClientRectangle       = new RectangleD(0, 0, 19, 0.6);
     Text3.HorAlignment          = StiTextHorAlignment.Center;
     Text3.Name                  = "Text3";
     Text3.GetValue             += new StiGetValueEventHandler(Text3__GetValue);
     Text3.VertAlignment         = StiVertAlignment.Center;
     Text3.Border                = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
     Text3.Brush                 = new StiSolidBrush(Color.Transparent);
     Text3.Font                  = new Font("Arial", 8F);
     Text3.Guid                  = null;
     Text3.Interaction           = null;
     Text3.Margins               = new StiMargins(0, 0, 0, 0);
     Text3.TextBrush             = new StiSolidBrush(Color.Black);
     Text3.TextOptions           = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
     PageFooterBand1.Guid        = null;
     PageFooterBand1.Interaction = null;
     //
     // HeaderVW_ProductLocation
     //
     HeaderVW_ProductLocation = new StiHeaderBand();
     HeaderVW_ProductLocation.ClientRectangle = new RectangleD(0, 3.4, 10, 0.6);
     HeaderVW_ProductLocation.Name            = "HeaderVW_ProductLocation";
     HeaderVW_ProductLocation.Border          = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
     HeaderVW_ProductLocation.Brush           = new StiSolidBrush(Color.Transparent);
     //
     // HeaderVW_ProductLocation_MedicamentName
     //
     HeaderVW_ProductLocation_MedicamentName = new StiText();
     HeaderVW_ProductLocation_MedicamentName.ClientRectangle = new RectangleD(0, 0, 5.2, 0.6);
     HeaderVW_ProductLocation_MedicamentName.HorAlignment    = StiTextHorAlignment.Center;
     HeaderVW_ProductLocation_MedicamentName.Name            = "HeaderVW_ProductLocation_MedicamentName";
     HeaderVW_ProductLocation_MedicamentName.GetValue       += new StiGetValueEventHandler(HeaderVW_ProductLocation_MedicamentName__GetValue);
     HeaderVW_ProductLocation_MedicamentName.VertAlignment   = StiVertAlignment.Center;
     HeaderVW_ProductLocation_MedicamentName.Border          = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
     HeaderVW_ProductLocation_MedicamentName.Brush           = new StiSolidBrush(Color.Gainsboro);
     HeaderVW_ProductLocation_MedicamentName.Font            = new Font("BPG Glaho Arial", 7F, FontStyle.Bold);
     HeaderVW_ProductLocation_MedicamentName.Guid            = null;
     HeaderVW_ProductLocation_MedicamentName.Interaction     = null;
     HeaderVW_ProductLocation_MedicamentName.Margins         = new StiMargins(0, 0, 0, 0);
     HeaderVW_ProductLocation_MedicamentName.TextBrush       = new StiSolidBrush(Color.Black);
     HeaderVW_ProductLocation_MedicamentName.TextOptions     = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
     //
     // HeaderVW_ProductLocation_CountryName
     //
     HeaderVW_ProductLocation_CountryName = new StiText();
     HeaderVW_ProductLocation_CountryName.ClientRectangle = new RectangleD(5.2, 0, 2.2, 0.6);
     HeaderVW_ProductLocation_CountryName.HorAlignment    = StiTextHorAlignment.Center;
     HeaderVW_ProductLocation_CountryName.Name            = "HeaderVW_ProductLocation_CountryName";
     HeaderVW_ProductLocation_CountryName.GetValue       += new StiGetValueEventHandler(HeaderVW_ProductLocation_CountryName__GetValue);
     HeaderVW_ProductLocation_CountryName.VertAlignment   = StiVertAlignment.Center;
     HeaderVW_ProductLocation_CountryName.Border          = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
     HeaderVW_ProductLocation_CountryName.Brush           = new StiSolidBrush(Color.Gainsboro);
     HeaderVW_ProductLocation_CountryName.Font            = new Font("BPG Glaho Arial", 7F, FontStyle.Bold);
     HeaderVW_ProductLocation_CountryName.Guid            = null;
     HeaderVW_ProductLocation_CountryName.Interaction     = null;
     HeaderVW_ProductLocation_CountryName.Margins         = new StiMargins(0, 0, 0, 0);
     HeaderVW_ProductLocation_CountryName.TextBrush       = new StiSolidBrush(Color.Black);
     HeaderVW_ProductLocation_CountryName.TextOptions     = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
     //
     // HeaderVW_ProductLocation_ListPrice
     //
     HeaderVW_ProductLocation_ListPrice = new StiText();
     HeaderVW_ProductLocation_ListPrice.ClientRectangle = new RectangleD(9, 0, 1, 0.6);
     HeaderVW_ProductLocation_ListPrice.HorAlignment    = StiTextHorAlignment.Center;
     HeaderVW_ProductLocation_ListPrice.Name            = "HeaderVW_ProductLocation_ListPrice";
     HeaderVW_ProductLocation_ListPrice.GetValue       += new StiGetValueEventHandler(HeaderVW_ProductLocation_ListPrice__GetValue);
     HeaderVW_ProductLocation_ListPrice.VertAlignment   = StiVertAlignment.Center;
     HeaderVW_ProductLocation_ListPrice.Border          = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
     HeaderVW_ProductLocation_ListPrice.Brush           = new StiSolidBrush(Color.Gainsboro);
     HeaderVW_ProductLocation_ListPrice.Font            = new Font("BPG Glaho Arial", 7F, FontStyle.Bold);
     HeaderVW_ProductLocation_ListPrice.Guid            = null;
     HeaderVW_ProductLocation_ListPrice.Interaction     = null;
     HeaderVW_ProductLocation_ListPrice.Margins         = new StiMargins(0, 0, 0, 0);
     HeaderVW_ProductLocation_ListPrice.TextBrush       = new StiSolidBrush(Color.Black);
     HeaderVW_ProductLocation_ListPrice.TextOptions     = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
     //
     // Text2
     //
     Text2 = new StiText();
     Text2.ClientRectangle                = new RectangleD(7.4, 0, 1.6, 0.6);
     Text2.Guid                           = "b2ee6a7204874db4bc1e2bae90edc3a9";
     Text2.HorAlignment                   = StiTextHorAlignment.Center;
     Text2.Name                           = "Text2";
     Text2.GetValue                      += new StiGetValueEventHandler(Text2__GetValue);
     Text2.Type                           = StiSystemTextType.Expression;
     Text2.VertAlignment                  = StiVertAlignment.Center;
     Text2.Border                         = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
     Text2.Brush                          = new StiSolidBrush(Color.Gainsboro);
     Text2.Font                           = new Font("BPG Glaho Arial", 7F, FontStyle.Bold);
     Text2.Interaction                    = null;
     Text2.Margins                        = new StiMargins(0, 0, 0, 0);
     Text2.TextBrush                      = new StiSolidBrush(Color.Black);
     Text2.TextOptions                    = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
     HeaderVW_ProductLocation.Guid        = null;
     HeaderVW_ProductLocation.Interaction = null;
     //
     // DataVW_ProductLocation
     //
     DataVW_ProductLocation = new StiDataBand();
     DataVW_ProductLocation.ClientRectangle = new RectangleD(0, 4.8, 10, 0.6);
     DataVW_ProductLocation.DataSourceName  = "T_Detail";
     DataVW_ProductLocation.Name            = "DataVW_ProductLocation";
     DataVW_ProductLocation.Sort            = new[] {
         "ASC",
         "ProductName"
     };
     DataVW_ProductLocation.Border             = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
     DataVW_ProductLocation.Brush              = new StiSolidBrush(Color.Transparent);
     DataVW_ProductLocation.BusinessObjectGuid = null;
     //
     // DataVW_ProductLocation_MedicamentName
     //
     DataVW_ProductLocation_MedicamentName                 = new StiText();
     DataVW_ProductLocation_MedicamentName.CanGrow         = true;
     DataVW_ProductLocation_MedicamentName.ClientRectangle = new RectangleD(0, 0, 5.2, 0.6);
     DataVW_ProductLocation_MedicamentName.Name            = "DataVW_ProductLocation_MedicamentName";
     DataVW_ProductLocation_MedicamentName.GetValue       += new StiGetValueEventHandler(DataVW_ProductLocation_MedicamentName__GetValue);
     DataVW_ProductLocation_MedicamentName.VertAlignment   = StiVertAlignment.Center;
     DataVW_ProductLocation_MedicamentName.Border          = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
     DataVW_ProductLocation_MedicamentName.Brush           = new StiSolidBrush(Color.Transparent);
     DataVW_ProductLocation_MedicamentName.Font            = new Font("BPG Glaho Arial", 6F);
     DataVW_ProductLocation_MedicamentName.Guid            = null;
     DataVW_ProductLocation_MedicamentName.Interaction     = null;
     DataVW_ProductLocation_MedicamentName.Margins         = new StiMargins(0, 0, 0, 0);
     DataVW_ProductLocation_MedicamentName.TextBrush       = new StiSolidBrush(Color.Black);
     DataVW_ProductLocation_MedicamentName.TextOptions     = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
     //
     // DataVW_ProductLocation_CountryName
     //
     DataVW_ProductLocation_CountryName                 = new StiText();
     DataVW_ProductLocation_CountryName.CanGrow         = true;
     DataVW_ProductLocation_CountryName.ClientRectangle = new RectangleD(5.2, 0, 2.2, 0.6);
     DataVW_ProductLocation_CountryName.HorAlignment    = StiTextHorAlignment.Right;
     DataVW_ProductLocation_CountryName.Name            = "DataVW_ProductLocation_CountryName";
     DataVW_ProductLocation_CountryName.GetValue       += new StiGetValueEventHandler(DataVW_ProductLocation_CountryName__GetValue);
     DataVW_ProductLocation_CountryName.VertAlignment   = StiVertAlignment.Center;
     DataVW_ProductLocation_CountryName.Border          = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
     DataVW_ProductLocation_CountryName.Brush           = new StiSolidBrush(Color.Transparent);
     DataVW_ProductLocation_CountryName.Font            = new Font("BPG Glaho Arial", 6F);
     DataVW_ProductLocation_CountryName.Guid            = null;
     DataVW_ProductLocation_CountryName.Interaction     = null;
     DataVW_ProductLocation_CountryName.Margins         = new StiMargins(0, 0, 0, 0);
     DataVW_ProductLocation_CountryName.TextBrush       = new StiSolidBrush(Color.Black);
     DataVW_ProductLocation_CountryName.TextFormat      = new StiPercentageFormatService(0, 0, ",", 4, " ", 3, "%", true, false, " ");
     DataVW_ProductLocation_CountryName.TextOptions     = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
     //
     // DataVW_ProductLocation_ListPrice
     //
     DataVW_ProductLocation_ListPrice                 = new StiText();
     DataVW_ProductLocation_ListPrice.CanGrow         = true;
     DataVW_ProductLocation_ListPrice.ClientRectangle = new RectangleD(9, 0, 1, 0.6);
     DataVW_ProductLocation_ListPrice.HorAlignment    = StiTextHorAlignment.Right;
     DataVW_ProductLocation_ListPrice.Name            = "DataVW_ProductLocation_ListPrice";
     DataVW_ProductLocation_ListPrice.GetValue       += new StiGetValueEventHandler(DataVW_ProductLocation_ListPrice__GetValue);
     DataVW_ProductLocation_ListPrice.VertAlignment   = StiVertAlignment.Center;
     DataVW_ProductLocation_ListPrice.Border          = new StiBorder(StiBorderSides.Right, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
     DataVW_ProductLocation_ListPrice.Brush           = new StiSolidBrush(Color.Transparent);
     DataVW_ProductLocation_ListPrice.Font            = new Font("BPG Glaho Arial", 6F);
     DataVW_ProductLocation_ListPrice.Guid            = null;
     DataVW_ProductLocation_ListPrice.Interaction     = null;
     DataVW_ProductLocation_ListPrice.Margins         = new StiMargins(0, 0, 0, 0);
     DataVW_ProductLocation_ListPrice.TextBrush       = new StiSolidBrush(Color.Black);
     DataVW_ProductLocation_ListPrice.TextFormat      = new StiNumberFormatService(1, ",", 2, " ", 3, true, false, " ");
     DataVW_ProductLocation_ListPrice.TextOptions     = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
     //
     // Text1
     //
     Text1                 = new StiText();
     Text1.CanGrow         = true;
     Text1.ClientRectangle = new RectangleD(7.4, 0, 1.6, 0.6);
     Text1.Guid            = "5cfcbb441d534f4ba95c949ddd2c6da5";
     Text1.HorAlignment    = StiTextHorAlignment.Right;
     Text1.Name            = "Text1";
     Text1.GetValue       += new StiGetValueEventHandler(Text1__GetValue);
     Text1.Type            = StiSystemTextType.DataColumn;
     Text1.VertAlignment   = StiVertAlignment.Center;
     Text1.Border          = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
     Text1.Brush           = new StiSolidBrush(Color.Transparent);
     Text1.Font            = new Font("BPG Glaho Arial", 6F);
     Text1.Interaction     = null;
     Text1.Margins         = new StiMargins(0, 0, 0, 0);
     Text1.TextBrush       = new StiSolidBrush(Color.Black);
     Text1.TextFormat      = new StiPercentageFormatService(0, 0, ",", 2, " ", 3, "%", true, true, " ");
     Text1.TextOptions     = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
     DataVW_ProductLocation.DataRelationName = null;
     DataVW_ProductLocation.Guid             = null;
     DataVW_ProductLocation.Interaction      = null;
     DataVW_ProductLocation.MasterComponent  = null;
     Page1.ExcelSheetValue     = null;
     Page1.Interaction         = null;
     Page1.Margins             = new StiMargins(0.5, 0.5, 0.5, 0.5);
     Page1_Watermark           = new StiWatermark();
     Page1_Watermark.Font      = new Font("Arial", 100F);
     Page1_Watermark.Image     = null;
     Page1_Watermark.TextBrush = new StiSolidBrush(Color.FromArgb(50, 0, 0, 0));
     Page1.Rendering          += new EventHandler(Page1_Rendering);
     RptProducLocationPrice_PrinterSettings = new StiPrinterSettings();
     PrinterSettings                 = RptProducLocationPrice_PrinterSettings;
     Page1.Report                    = this;
     Page1.Watermark                 = Page1_Watermark;
     PageHeaderBand1.Page            = Page1;
     PageHeaderBand1.Parent          = Page1;
     Text4.Page                      = Page1;
     Text4.Parent                    = PageHeaderBand1;
     Image1.Page                     = Page1;
     Image1.Parent                   = PageHeaderBand1;
     PageFooterBand1.Page            = Page1;
     PageFooterBand1.Parent          = Page1;
     Text3.Page                      = Page1;
     Text3.Parent                    = PageFooterBand1;
     HeaderVW_ProductLocation.Page   = Page1;
     HeaderVW_ProductLocation.Parent = Page1;
     HeaderVW_ProductLocation_MedicamentName.Page   = Page1;
     HeaderVW_ProductLocation_MedicamentName.Parent = HeaderVW_ProductLocation;
     HeaderVW_ProductLocation_CountryName.Page      = Page1;
     HeaderVW_ProductLocation_CountryName.Parent    = HeaderVW_ProductLocation;
     HeaderVW_ProductLocation_ListPrice.Page        = Page1;
     HeaderVW_ProductLocation_ListPrice.Parent      = HeaderVW_ProductLocation;
     Text2.Page   = Page1;
     Text2.Parent = HeaderVW_ProductLocation;
     DataVW_ProductLocation.Page   = Page1;
     DataVW_ProductLocation.Parent = Page1;
     DataVW_ProductLocation_MedicamentName.Page   = Page1;
     DataVW_ProductLocation_MedicamentName.Parent = DataVW_ProductLocation;
     DataVW_ProductLocation_CountryName.Page      = Page1;
     DataVW_ProductLocation_CountryName.Parent    = DataVW_ProductLocation;
     DataVW_ProductLocation_ListPrice.Page        = Page1;
     DataVW_ProductLocation_ListPrice.Parent      = DataVW_ProductLocation;
     Text1.Page   = Page1;
     Text1.Parent = DataVW_ProductLocation;
     EndRender   += new EventHandler(RptProducLocationPriceWordsToEnd__EndRender);
     //
     // Add to PageHeaderBand1.Components
     //
     PageHeaderBand1.Components.Clear();
     PageHeaderBand1.Components.AddRange(new StiComponent[] {
         Text4,
         Image1
     });
     //
     // Add to PageFooterBand1.Components
     //
     PageFooterBand1.Components.Clear();
     PageFooterBand1.Components.AddRange(new StiComponent[] {
         Text3
     });
     //
     // Add to HeaderVW_ProductLocation.Components
     //
     HeaderVW_ProductLocation.Components.Clear();
     HeaderVW_ProductLocation.Components.AddRange(new StiComponent[] {
         HeaderVW_ProductLocation_MedicamentName,
         HeaderVW_ProductLocation_CountryName,
         HeaderVW_ProductLocation_ListPrice,
         Text2
     });
     //
     // Add to DataVW_ProductLocation.Components
     //
     DataVW_ProductLocation.Components.Clear();
     DataVW_ProductLocation.Components.AddRange(new StiComponent[] {
         DataVW_ProductLocation_MedicamentName,
         DataVW_ProductLocation_CountryName,
         DataVW_ProductLocation_ListPrice,
         Text1
     });
     //
     // Add to Page1.Components
     //
     Page1.Components.Clear();
     Page1.Components.AddRange(new StiComponent[] {
         PageHeaderBand1,
         PageFooterBand1,
         HeaderVW_ProductLocation,
         DataVW_ProductLocation
     });
     //
     // Add to Pages
     //
     Pages.Clear();
     Pages.AddRange(new[] {
         Page1
     });
     T_Detail.Columns.AddRange(new[] {
         new StiDataColumn("ProductID", "ProductID", "ProductID", typeof(int)),
         new StiDataColumn("ProductName", "ProductName", "ProductName", typeof(string)),
         new StiDataColumn("CountryName", "CountryName", "CountryName", typeof(string)),
         new StiDataColumn("Serie", "Serie", "Serie", typeof(string)),
         new StiDataColumn("UnitPrice", "UnitPrice", "UnitPrice", typeof(decimal)),
         new StiDataColumn("Discount", "Discount", "Discount", typeof(decimal))
     });
     DataSources.Add(T_Detail);
 }