Record Selection

[tweetyng]

Please help
I have 4 fields like this in the table

1stField 2ndField 3rdField 4thField
Y N Y
N N
N Y
Y N Y
N N
Y Y Y N
N N Y

In my record selection I wrote:

(table.1stField) = “Y” or
(table.2ndField) = “Y” or
(table.3rdField) = “Y” or
(table.4thField) = “Y”

This mean either Field had “Y” will show on the report.

Then the result should show all 5 records
whichever had “Y” such as:

1stField 2ndField 3rdField 4thField
Y N Y
N Y
Y N Y
Y Y Y N
N N Y

However, it showed only 3 records, contained “Y”
in 1stField only such as:

1stField 2ndField 3rdField 4thField
Y N Y
Y N Y
Y Y Y N


Please help, thanks

TN (USA). I'm using Windows XP, Crystal Reports 10 and SQL Server

 

[lbass]

I think you should go to file->report options and check "convert nulls to default values". Then your formula should work fine. The nulls are what are causing the problem.

-LB

 

[tweetyng]

Thanks lbass, it works

TN (USA). I'm using Windows XP, Crystal Reports 10 and SQL Server