使用Date创建过滤晶体报告时出错 [英] Error while creating filtering crystal report with Date

问题描述

我从文本框传递日期时间（点击按钮）并将其传递给水晶报告：



代码：

 ReportDocument cryRpt =  new  ReportDocument（）; 
 cryRpt.Load（  E：\\Developing\\ReportsDB\\CrystalReport4的.rpt）; 
 DateTime datefilter = Convert.ToDateTime（TextBox1.Text）; 
 cryRpt.SetParameterValue（  orderdated，datefilter）; 
 CrystalReportViewer1.ReportSource = cryRpt; 
 

错误：

 A 字符串  。详细信息：errorKind错误 文件CrystalReport4 {AA07EFE4-73A5-4C0A-9198-1AEFCD0CB55F} .rpt：错误 in 公式Record_Selection：'  {Command.date} = {？orderdated}' A 字符串  。详细信息：errorKind 

我按名称（String）过滤但是对于Date，它给出了此错误。

解决方案

我认为你需要传递一个字符串，而不是一个DateTime对象。



试试这个，

  //  将其作为字符串， 
  string  datefilter = TextBox1.Text; 
  //  传递它， 
 cryRpt.SetParameterValue（  orderdated，datefilter）; 

我有解决了它，我在水晶报告中编写公式时犯了错误：

现在是：

 {Command.date} = {？Orderdate} 

和正确的。

I am passing datetime from textbox (on button click) and passing it to the crystal report:

Code:

ReportDocument cryRpt = new ReportDocument();
      cryRpt.Load("E:\\Developing\\ReportsDB\\CrystalReport4.rpt");
      DateTime datefilter = Convert.ToDateTime(TextBox1.Text);
      cryRpt.SetParameterValue("orderdated", datefilter);
      CrystalReportViewer1.ReportSource = cryRpt;

Error:

A string is required here. Details: errorKind Error in File CrystalReport4 {AA07EFE4-73A5-4C0A-9198-1AEFCD0CB55F}.rpt: Error in formula Record_Selection: '{Command.date} = {?orderdated}' A string is required here. Details: errorKind  

I have filtered by Name(String) but for Date it is giving this Error.

解决方案

I think you need to pass a string, and not a DateTime object.

Try this,

// take it as a string, 
string datefilter = TextBox1.Text;
// pass it, 
cryRpt.SetParameterValue("orderdated", datefilter);

I have solved it, i was making mistake while writing formula in crystal report:
it is now :

{Command.date} = {?Orderdate}

and correct.

这篇关于使用Date创建过滤晶体报告时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！