Creating reports and dashboards | Stimulsoft community forum

Code: Select all

 private List<BalancesItem> _balancesItems = new List<BalancesItem>();
        public List<BalancesItem> Balances
        {
            get { return _balancesItems; }
            set { _balancesItems = value; }
        }


private void GenerateReport()
        {
            var stream = System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream("Budgeting.BalanceSheetReport.mrt");
            var report = new StiReport();
            report.Load(stream);
            stream.Close();
            stream.Dispose();
            StiPage page = (StiPage)report.GetComponentByName("Page1");
            page.UnlimitedWidth = true;
            page.SegmentPerWidth = 3;


            foreach (var combinedScenarioTime in InteractiveDataContext.CombinedScenarioTimes)
            {
                var balancesItem = new BalancesItem();
                try
                {
                    balancesItem.HorizonMonth = string.Format("{0}{1}{2}", combinedScenarioTime.Month,Environment.NewLine, combinedScenarioTime.TimeType);
                    balancesItem.AverageBalanceACT = 11111;
                    balancesItem.AverageBalanceCP = 22222;
                    balancesItem.AverageBalanceNB = 33333;
                    balancesItem.BalanceTypeId = 1;
                    balancesItem.EndingBalance = 99999;
              

             
                }
                catch (Exception)
                {
                    
                }
                finally
                {
                    Balances.Add(balancesItem);
                }
               
            }
          
            report.RegBusinessObject("StimulsoftBalanceSheetViewModel", "StimulsoftBalanceSheetViewModel",this);
            report.Render();
            StimulsoftReport = report;
           
        }

 public class BalancesItem
    {
        public double? AverageBalanceACT { get; set; }
        public double? AverageBalanceCP { get; set; }
        public double? AverageBalanceNB { get; set; }
        public double? EndingBalance { get; set; }
        public string HorizonMonth {get;set;}
        public int BalanceTypeId { get; set; }
    }