Crystal Reports 8.5 date range parameter field - record selection that includes null date range 
Author Message
 Crystal Reports 8.5 date range parameter field - record selection that includes null date range

I use a parameter field in my report to select records based on a date
range. This date field, however, can be null.

When entering parameter values, if I specify "no lower bound", Crystal
does not return records with that date field = null. What do I need to
do to include records with null date field upon specifying so by the
users.

Any help is much appreciated.

TIA,

Dzung.



Tue, 19 Jul 2005 15:08:04 GMT  
 Crystal Reports 8.5 date range parameter field - record selection that includes null date range
Try assigning "Null" to the value.


Quote:
> I use a parameter field in my report to select records based on a date
> range. This date field, however, can be null.

> When entering parameter values, if I specify "no lower bound", Crystal
> does not return records with that date field = null. What do I need to
> do to include records with null date field upon specifying so by the
> users.

> Any help is much appreciated.

> TIA,

> Dzung.



Tue, 19 Jul 2005 17:23:24 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Including a Parameter Field (Date Range) in a report

2. Crystal Reports 8.5 Parameter Fields

3. Using Crystal Reports 8.5 to Report Fields From Public Contacts Folder on Exchange 5.5 Server

4. Stored procedure parameter with Crystal Report 8.5

5. help:crystal report 8.5 error out date export dll

6. Crystal Reports 8.5 (VB6) to Crystal Reports NET (VB.NET) conversion

7. vb .net crystal reports not compatible with Crystal Reports 8.5

8. Using Crystal 8.5 and VB6 -- need to get a list of fields available to the report

9. Diary field is truncated when previewing a Crystal Reports 8.5

10. Crystal Reports 8.5 Truncates Varchar fields larger then 255 characters

11. SQL Server image fields and Crystal Reports 8.5

12. Passing date range selection parameter via URL

 

 
Powered by phpBB® Forum Software