我想在c#.net(窗口应用程序)中使用Crystal Report Viewer显示报告 [英] i want to display a report by using crystal report viewer in c#.net(window application)

问题描述

有两个表

1. mfpopulation
2. vvmaster

1.表包含-> a.vid作为主键
b. vname

2.表格包含-> ppl_id作为主键
b. tlplf
C. tlplm
d. tlpl
e. vdate作为日期时间

来自Crystal报表的数据是vname，tltpl，tlplm，tlplf和vdate

我正在使用Crystal Report用于通过两个日期时间选择器选择的两个日期之间的数据进行制作报告，即datetimepicker1和datetimepickr2

我在水晶报表中设置了两个参数fromdate和todate
代码是

there are two tables

1. mfpopulation
2. vvmaster

1. table contain->a.vid as primary key
b. vname

2. table contain-> ppl_id as primary key
b. tlplf
c. tlplm
d. tlpl
e. vdate as date time

Ihe data from crystal report is vname ,tltpl,tlplm,tlplf and vdate

I am using crystal report for make report using data betwwen two date selected by two datetime pickrs i.e datetimepicker1 and datetimepickr2

I make two parameters fromdate and todate in crystal report
the code is

private void button1_Click_1(object sender, EventArgs e)
{
   // CrystalReport3 cr = new CrystalReport3();
    ReportDocument cryRpt = new ReportDocument();
    //crystalReportViewer1.ReportSource = cr;
    cryRpt.Load(@"E:\\grabone1\\grabone1\\CrystalReport3.rpt");
   TableLogOnInfos crtableLogoninfos = new TableLogOnInfos();
    TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();
    ConnectionInfo crConnectionInfo = new ConnectionInfo();

    Tables CrTables;
    ParameterFieldDefinitions crParameterFieldDefinitions;
    ParameterFieldDefinition crParameterFieldDefinition;
    ParameterValues crParameterValues = new ParameterValues();
    ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();

    crParameterDiscreteValue.Value = dateTimePicker1.Text;
    crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
    crParameterFieldDefinition = crParameterFieldDefinitions["fromDate"];
    crParameterValues = crParameterFieldDefinition.CurrentValues;
    crParameterValues.Clear();
    crParameterValues.Add(crParameterDiscreteValue);
    crParameterFieldDefinition.ApplyDefaultValues(crParameterValues);
    crParameterDiscreteValue.Value = dateTimePicker2.Text;
    crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
    crParameterFieldDefinition = crParameterFieldDefinitions["toDate"];
    crParameterValues = crParameterFieldDefinition.CurrentValues;
    crParameterValues.Add(crParameterDiscreteValue);
    crParameterFieldDefinition.ApplyDefaultValues(crParameterValues);
    crConnectionInfo.ServerName = "localhost";
    crConnectionInfo.DatabaseName = "childbelfare";
    crConnectionInfo.UserID = "sa";
    crConnectionInfo.Password = "sa";

    CrTables = cryRpt.Database.Tables;
    foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
    {
        crtableLogoninfo = CrTable.LogOnInfo;
        crtableLogoninfo.ConnectionInfo = crConnectionInfo;
        CrTable.ApplyLogOnInfo(crtableLogoninfo);
    }
    crystalReportViewer1.ReportSource = cryRpt;
   crystalReportViewer1.Refresh();
}

问题是运行程序后，囊状查看器显示消息未加载任何数据".

Problem is after running the programe the cystal viewer show message "no data is loaded"

推荐答案

您是否可以验证用于提取数据的查询?报告真的可以给您任何数据吗?

Are you able to verify that the query you are using to extract data into the report really gives you any data?

这篇关于我想在c#.net(窗口应用程序)中使用Crystal Report Viewer显示报告的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！