Creating reports and dashboards | Stimulsoft community forum

Code: Select all

           
string sql = "Select ID As F_EmployeeMaster,EmpName,FatherName,Department,Designation,ShiftInTime,F_CompanyMaster,ShiftOutTime From vEmployeeDetails Where F_CompanyMaster = " + Options.F_CompanyMaster + " AND ID = " + GetSqlParameterValueByName("@F_EmployeeMaster", param);
            DataSet Emp = SqlClientUtility.ExecuteDataSet("eVartikaConnectionString", CommandType.Text, sql, null);


            SqlParameter[] rparams = new SqlParameter[]
            {
                new SqlParameter("@F_CompanyMaster", Options.F_CompanyMaster),
                new SqlParameter("@F_EmployeeMaster", GetSqlParameterValueByName("@F_EmployeeMaster",param )),
                new SqlParameter("@F_DepartmentMaster", GetSqlParameterValueByName("@F_DepartmentMaster",param)),
                new SqlParameter("@FromDate", GetSqlParameterValueByName("@FromDate",param)),
                new SqlParameter("@ToDate", GetSqlParameterValueByName("@ToDate",param)),
                new SqlParameter("@UserId", Options.UserId)
            };

            DataSet EA = SqlClientUtility.ExecuteDataSet("eVartikaConnectionString", CommandType.StoredProcedure, "EmployeeWiseAttendanceReport", rparams);
            string appDirectory = HttpContext.Current.Server.MapPath(string.Empty);
            // Load report
            StiReport report = new StiReport();
            report.Load(appDirectory + "\\Attendance\\EmployeeWiseAttendance.mrt");

            report.RegData(Emp);

            report.RegData(EA);

            report.Compile();

            // View report
            
            StiWebViewer1.Report = report;