Crystal Reports 10 record selection issue with a parameter.

[agreen10]

The following is the record selection formula:
{students.application_status} in ["Active", "Approved", "Withdrawn"] and
{students.year} = 2005 and
{students.semester} = "School Year" and
(
{?CheckNo} in [{bssp_tuition.apr_check}, {bssp_tuition.aug_check},
{bssp_tuition.dec_check},{bssp_tuition.feb_check},
{bssp_tuition.jan_check},{bssp_tuition.mar_check},
{bssp_tuition.may_check},{bssp_tuition.nov_check},
{bssp_tuition.oct_check},{bssp_tuition.sep_check}]
) and
{sites.program_id} = "1" and
{students.program_id} = 1


I have a report in crystal 10 that I need to only display records based on a certain check number. the check number has to look up all the fields above and if it finds a match, then it will print the details for that record. However, when I enter a check number in the parameter field, I get the check number and others. What am I doing wrong. for example, if I enter check number 6855, it gaves records for 6855 6855 and 9999. which is not correct.

Thanks for your help in advance.

 

[cluelessAnyAdvise]

Is it possible that any of the columns mentioned in the "IN" columns might have null values if so this condition would not work.
I tried the same example and it gives me only those records which meet the selection criteria in any of the columns mentioned in "IN" clause. But when i changed the IN clause to look at the column that might have nulls in it the output was wrong.

If thats not the case check all columns mentioned in "IN" clause of record selection formula (ie aug_check,dec_check etc) for that perticular record. I think 6855 must be in there somewhere.

Hope this helps