时间戳

首页 > 解决方案 > Crystal Report Crosstab 专家行着色

c# - Crystal Report Crosstab 专家行着色

问题描述

我可以突出显示这个吗？

我的数据库表就业状态中有 3 个状态

正规、非正规和代理

在此处输入图像描述

你能建议其他选项吗？ Higlighting 专家只读取 EmployeeName 的值 在此处输入图像描述

字体颜色没有输入我也尝试了格式对象然后编辑颜色但是在那里但是当我运行数据时没有加载

在此处输入图像描述

在此处输入图像描述

MySqlConnection conn = new MySqlConnection("Data Source=" + clsSQLcon.sqlServerName + ";port=" + clsSQLcon.sqlPort + ";Initial Catalog =" + clsSQLcon.sqlDatabaseName + ";user id =" + clsSQLcon.sqlUserName + ";password =" + clsSQLcon.sqlPassword + "");
                MySqlCommand cmd = new MySqlCommand("SELECT CASE tblschedule.TimeSchedule " +
                    "When '6:00am - 3:00pm' THEN '1s'" +
                    "When '1:00pm - 10:00pm' THEN '2s'" +
                    "When '9:00pm - 6:00am' THEN '3s'" +
                    "When '6:00am - 6:00pm' THEN 'D'" +
                    "When '6:00pm - 6:00am' THEN 'N'" +
                    "When '8:00am - 5:00pm' THEN 'R'" +
                    "END as TimeSchedule, tblschedule.EmployeeName,tblschedule.AssignedArea,tblschedule.SectionName,STR_TO_DATE(CONCAT(YEARWEEK((tblschedule.ScheduleFrom)),' Monday'), '%X%V %W') as ScheduleFrom    from tblschedule WHERE ScheduleFrom BETWEEN '" + clsSQLcon.DateFrom1 + "' AND '" + clsSQLcon.DateTo1 + "' and SectionName like '%" + clsSQLcon.Section1 + "%' ORDER BY EmployeeName DESC ", conn);

                MySqlDataAdapter da = new MySqlDataAdapter(cmd);
                DataSet ds = new DataSet();
                da.Fill(ds, "tblschedule");

                ReportDocument crypRpt = new ReportDocument();
                string CurrentDirectory = System.IO.Directory.GetCurrentDirectory();
                crypRpt.Load(CurrentDirectory + @"\Crystal Report\ScheduleSystem\crystalMonthlyReport.rpt");
                crypRpt.SetDataSource(ds.Tables["tblschedule"]);
                crystalReportViewer1.ReportSource = crypRpt;

标签： c#mysqlvisual-studiocrystal-reports

解决方案

推荐阅读