Creating reports and dashboards | Stimulsoft community forum

Code: Select all

StiReport report = new StiReport();

            report.Dictionary.Clear();
            report.Dictionary.Databases.Clear();
            report.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("SQLConnection", SqldBConnectString));

            DataSet dsBSReport = null;

            StiPage LiabRep = report.Pages[0];
            
            dsBSReport = objBSReport.m_BalanceSheetReport(11, "1/5/2013", "GL", true, "ABC");

            DataTable dtRepDet = dsBSReport.Tables[0];
            DataTable dtUserPC = dsBSReport.Tables[1];
            DataTable dtRepLiab = dsBSReport.Tables[2];
            DataTable dtRepAsst = dsBSReport.Tables[3];

            report.RegData(dsBSReport);

            report.Dictionary.Synchronize();

           
            //Create header group for headers

            StiHeaderBand LiabRepHeader = new StiHeaderBand();
            LiabRepHeader.Height = 0.7;
            LiabRepHeader.Name = "LiabReportHeader";

            LiabRep.Components.Add(LiabRepHeader);

            double columnWidth = LiabRep.Width / ((dtUserPC.Rows.Count + 1) * 2);
            double pos = 0;

            // Add databand in the header text

            StiDataBand dbLiabRepHeader = new StiDataBand();
            dbLiabRepHeader.Height = 0.7;
            dbLiabRepHeader.Name = "dbLiabRepHeader";

            LiabRepHeader.Components.Add(dbLiabRepHeader);

            // Add 'Liabilities' header text

            StiText stitxtLiab = new StiText(new RectangleD(pos, 0, (columnWidth * 2), 0.7));
            stitxtLiab.Text = "Liabilities";
            stitxtLiab.HorAlignment = StiTextHorAlignment.Center;
            stitxtLiab.VertAlignment = StiVertAlignment.Center;
            stitxtLiab.Border.Side = StiBorderSides.All;

            dbLiabRepHeader.Components.Add(stitxtLiab);

            // Add header text for each of the PCs
            int nameIndex = 1;
            foreach (DataRow drUserPC in dtUserPC.Rows)
            {
                pos = pos + (columnWidth * 2);
                StiText hText = new StiText(new RectangleD(pos, 0, (columnWidth * 2), 0.7));
                hText = new StiText(new RectangleD(pos, 0, columnWidth, 0.5));

                hText.Text.Value = drUserPC["ProfitCenter"].ToString() + "/n Amount in Rs.";
                hText.HorAlignment = StiTextHorAlignment.Center;
                hText.Name = "HeaderText" + nameIndex.ToString();
                hText.Border.Side = StiBorderSides.All;
                dbLiabRepHeader.Components.Add(hText);
                nameIndex++;
            }

            report.Compile();

           
            report.Show();