在cryatal报告中显示具有null date vlaue的所有字段 [英] to display all fields with null date vlaue in cryatal report

问题描述

hi，
iam使用vb.net和内置水晶报告。使用数据集填充水晶报告。数据库中的某些日期值为空。
如何在报告中显示它？
不显示包含空日期值的特定记录。
我希望所有其他字段显示为日期字符为空或其他一些字符串值。


非常感谢您的帮助。


谢谢。

解决方案

检查数据集 - 如果是存储过程，请确保日期字段中没有表达条件（例如：非空）或者日期字段未链接到另一张桌子。如果要将任何类型的日期参数传递给此字段，则它不会包含带有"null"的记录。值。如果您传递的是日期参数，则可能需要告诉它"myDate< = 01/12/006或myDate IS NULL"。这样它将拉出满足日期参数的记录以及那些没有日期的记录。

hi,
iam using vb.net and inbuilt crystal report.
using dataset to populate crystal report. some date value is null in database .
how to show it in report ?
that particular record which contains Null date value is not displayed.
i want all other fields to be displayed with date fiels as empty  or some other string value.


your help is very much appreciated.


thanks.

解决方案

Check your dataset-if it's a stored procedure make sure that there are no conditions expressed on the date field (ex: not null) or that the date field is not linked to another table.  If you are passing any kind of date parameter to this field then it will not include the records with a "null" value.  If you are passing a date parameter, you might want to tell it "myDate <= 01/12/006 OR myDate IS NULL"  This way it will pull the records that satisfy your date parameter as well as those records that do not have a date.

 

 

这篇关于在cryatal报告中显示具有null date vlaue的所有字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！