Creating reports and dashboards | Stimulsoft community forum

Code: Select all

        public Report(string Host, string User, string Password, string Database, string XMLReportParams, string SiteID, string ReportName)
        {

            ///////////
            //  Data
            ///////////
            #region Data
            #endregion
		
            ///////////
            //  Code
            ///////////
            #region Code
            this.ReportName = ReportName;
            this.XMLParameters = XMLReportParams;
            this.Host = Host;
            this.User = User;
            this.Password = Password;
            this.Database = Database;
            this.SiteID = SiteID;
            _ConnectString = BuildConnectString(_Host, _User, _Password, _Database);
            #endregion
		
        }

        private string BuildConnectString(string Host, string User, string Password, string Database)
        {

            ///////////
            //  Data
            ///////////
            #region Data
            StringBuilder strConnection;
            #endregion
		
            ///////////
            //  Code
            ///////////
            #region Code
            strConnection = new StringBuilder();
            strConnection.AppendFormat("Data Source={0}; User Id={1}; Password={2}; Initial Catalog={3};", Host, User, Password, Database);

            return strConnection.ToString();

            #endregion

		
        }

        private StiReport PrepReport()
        {
            ///////////
            //  Data
            ///////////
            #region Data
            StiReport TheReport;
            SqlConnection TheConnection;

            StiServiceContainer RegisteredDataAdapters;
            #endregion

            ///////////
            //  Code
            ///////////
            #region Code
            //Init Report
            
            
            TheReport = LoadReport();            

            //Init Data Connection                        
            TheConnection = new SqlConnection(_ConnectString);


            RegisteredDataAdapters = StiConfig.Services.GetServices(typeof(StiDataAdapterService));
            foreach (StiDataAdapterService dataAdapter in RegisteredDataAdapters)
            {
                if (dataAdapter.GetDataSourceType() != typeof(StiSqlSource))
                {
                    dataAdapter.ServiceEnabled = false;
                }
            }

            //Register Data                                   
            TheReport.RegData("POSitive Retail Manager", TheConnection);

            //Register Parameters
            MakeParameters(_ReportParams, TheReport);

            //Register Custom Functions
            RegisterCustomFunctions();

            return TheReport;
            #endregion
        }