水晶报表日期迄今仅检索列名称 [英] crystal report date to date retrivte only columns name

问题描述

我制作了一个水晶报表来检索两个日期之间的数据，但它仅显示列名称

I made a crystal report to retrieve data between two dates, but it shows only the column names

SqlConnection con = new SqlConnection("Data Source=server;Initial Catalog=f_library;User ID=sa;Password=ahmed");
            con.Open();
            SqlDataAdapter dad = new SqlDataAdapter("Select * from absence  where absent_b_date between @start and @end", con);
            dad.SelectCommand.Parameters.AddWithValue("@start", dateTimePicker1.Value);
            dad.SelectCommand.Parameters.AddWithValue("@end", dateTimePicker2.Value);
            DataTable mDT_Report = new DataTable();
            ReportDocument cryRpt = new ReportDocument();
            cryRpt.Load("G:\\WindowsApplication2\\WindowsApplication2\\CrystalReport6.rpt");
         
            ParameterFieldDefinitions crParameterFieldDefinitions ;
            ParameterFieldDefinition crParameterFieldDefinition ;
            ParameterValues crParameterValues = new ParameterValues();
            ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();

            crParameterDiscreteValue.Value = dateTimePicker1.Value;
            crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
            crParameterFieldDefinition = crParameterFieldDefinitions["hireto"];
            crParameterValues = crParameterFieldDefinition.CurrentValues;

            crParameterValues.Clear();
            crParameterValues.Add(crParameterDiscreteValue);
            crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);

            crParameterDiscreteValue.Value = dateTimePicker2.Value;
            crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
            crParameterFieldDefinition = crParameterFieldDefinitions["hirefrom"];
            crParameterValues = crParameterFieldDefinition.CurrentValues;

            crParameterValues.Add(crParameterDiscreteValue);
            crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);

            dad.Fill(mDT_Report);
            cryRpt.Database.Tables[0].SetDataSource(mDT_Report);
            MessageBox.Show("Generating Report", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
            crystalReportViewer1.ReportSource = cryRpt;

推荐答案

检查本文
C#Crystal Reports-日期至今 [ ^ ]

Check this article
C# Crystal Reports - Date to Date[^]

这篇关于水晶报表日期迄今仅检索列名称的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！