Wrong Results reported by CR

[mjbhopal]

In Crystal Reports,in record selection formula i have entered following formula
({Trans.ReceiptDate} in Date(2001,12,09) to Date(2001,12,09)) or ({Trans.IssueDate} in Date(2001,12,09) to Date(2001,12,09))

Following is Trans table records:
IDNo ReceiptDate IssueDate
---- ----------- ---------
1 9/12/2001
2 9/12/2001
3 9/12/2001
4 9/12/2001
5 9/12/2001
--------------------------------

This gives only 3 records. Where as Trans table contains 2 records of same date in IssueDate field and 3 records of same date in ReceiptDate field. When I give IssueDate condition first and then gives ReceiptDate condition second I get 2 records.

I have received some Mr. John43's response, thanks for it, but it is not clear. Mr. John43 can you explain it.

Instead of this all 5 records should be reported in this condition. Can some body explain it?

-Mahesh Joshi, Bhopal (INDIA)

 

[dgillz]

Try this formula instead:

{Trans.ReceiptDate} = Date(2001,12,09) or
{Trans.IssueDate} = Date(2001,12,09)

Although I see nothing wrong with your formula, there is no range needed for this formula, and I got rid of some unneeded parentheses.

Also does 9/12/2001 represent September 12th or December 9th? I know this is expressed differently in different parts of the world.

If that doesn't work, go to file, options, reporting tab and click on the option "convert null field values to default". Your report may be having problems handling null field values.


Software Support for Macola, Crystal Reports and Goldmine
dgillz@juno.com