Help with record selection of a payroll report

[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
({bssp_tuition.apr_check}= {?CheckNo.};
{bssp_tuition.aug_check} = {?CheckNo.};
{bssp_tuition.dec_check} = {?CheckNo.};
{bssp_tuition.feb_check} = {?CheckNo.};
{bssp_tuition.jan_check} = {?CheckNo.};
{bssp_tuition.mar_check} = {?CheckNo.};
{bssp_tuition.may_check} = {?CheckNo.};
{bssp_tuition.nov_check} = {?CheckNo.};
{bssp_tuition.oct_check} = {?CheckNo.};
{bssp_tuition.sep_check} = {?CheckNo.}) and
{@join two fields} 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.

 

[lbass]

Sorry, I don't really see how these could be the results of the fields you have shown us earlier. If the check number is one of the month fields, then if you laid your fields on the report like this:

{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}

...all going across, you wouldn't see the check numbers in one column. What field is giving you the monthname, and what field is giving you the amount? Also you did not answer the question in my last post.

-LB

 

[synapsevampire]

This doesn't look like example data, this looks like a report output.

What fields are used to create this output?

-k

 

[agreen10]

Okay, let me try this again. Here is sample data of just the fields that LB wanted across.

5962 5819 6146 6134
5971 5777 5002
5777 6130

these are the check numbers. The month field that you ses is actually the field label.

Why is it that multiple students are associated with the same check number? To answer this question. one check is used to pay many students tuition. The way the database was designed is that each check number is entered into a student's record and for each month. May be a bit confusing but I did not design the database. IF it was designed differently, perhaps this would be fairly easy.

HOpe this information helps.

 

[agreen10]

I am still in need of some advice on this subject. Take a look at the following and let me know how I can get crystal reports 10 to not give me the check numbers 9999. I specified 6353 but it provides that and the 9999.


13-March-

aug_chsep_choct_chnov_chdec_chjan_chfeb_chmar_chapr_chmay_chjun_chjul_ch
6353 6353 6353
6353 6353 9999
6353 6353 6353 9999
6353 6353 6353 9999
6353 6353 6353 9999
6353 6353 6353 9999
6353 6353 6353 9999
6353 6353 6353 9999
6353 6353 6353 9999
6353 6353 6353 9999
6353 6353 6353 9999
6353 6353 6353 9999
6353 6353 6353 9999
6353 6353 6353 9999
6353 6353 6353 99999
6353 6353 6353 9999
6353 6353 9999
6353 6353 9999
6353 6353 6353 9999
6353 6353 6353 9999
6353 6353 6353 9999
6353 6353 6353 9999
6353 6353 6353 9999
6353 6353 6353 9999
6353 6353 6353 9999
6353 6353 6353 9999
6353 6353 6353 9999
63553 6353 6353 9999
6353 6353
6353 6353 6353 99999
6353 6353 6353 9999
6353 6353 6353 9999
6353 6353 6353 9999
6353 6353 9999
6353 6353 6353
6353 6353 6353 9999
6353 9999
6353 6353 6353 9999
6353 6353 9999
6353 6353 6353 9999
6353 6353 6353 9999
6353 6353 6353 9999
6353 9999
6353 6353 6353 9999
6353 6353 6353 9999
6353 6353 6353 9999
6353 6353 6353 999
6353 6353 6353
6353 6353 6353 9999
6353 6353 6353 9999
6353 6353
6353 6353 6353 9999
6353 6353 6353 9999
6353 6353 6353 9999
6353 6353 9999

thanks.