I have a report that has 3 grouping levels:
1- Carton #
2- Employee #
3- Error Code
For each carton there can be multilple employees that made errors and multiple errors (separate error codes) for each employee. Sometimes it is just one empl with one error code.
Well in the footer of the Error Code I am trying to get the
Carton #, Empl #, Sum of units for the error code, and then one more textbox.
This is an auditor's report and the auditor only gets credit for the carton once no matter how many errors are inside. So in the fourth textbox referred to earlier I am trying to get a 1 to show up in the Error Code footer the first time it prints per carton number, and a 0 to show in the footer if there are multiple errors or employeess.
Like this:
Carton# 999999
error code A footer w/ [empl#] and [error code] 1
error code B footer w/ [empl#] and [error code] 0
error code C footer w/ [empl#] and [error code] 0
Carton# 222222
error code X footer w/ [empl#] and [error code] 1
error code Y footer w/ [empl#] and [error code] 0
Carton# 666666
etc. etc.
Have tried many counts and counting different counts and can't get anything. Is there some code and if so what is syntax like if you want to say 'Print a 1 if this is the first time the error code footer shows/ per carton. Otherwise a zero'? Driving me crazy!!
1- Carton #
2- Employee #
3- Error Code
For each carton there can be multilple employees that made errors and multiple errors (separate error codes) for each employee. Sometimes it is just one empl with one error code.
Well in the footer of the Error Code I am trying to get the
Carton #, Empl #, Sum of units for the error code, and then one more textbox.
This is an auditor's report and the auditor only gets credit for the carton once no matter how many errors are inside. So in the fourth textbox referred to earlier I am trying to get a 1 to show up in the Error Code footer the first time it prints per carton number, and a 0 to show in the footer if there are multiple errors or employeess.
Like this:
Carton# 999999
error code A footer w/ [empl#] and [error code] 1
error code B footer w/ [empl#] and [error code] 0
error code C footer w/ [empl#] and [error code] 0
Carton# 222222
error code X footer w/ [empl#] and [error code] 1
error code Y footer w/ [empl#] and [error code] 0
Carton# 666666
etc. etc.
Have tried many counts and counting different counts and can't get anything. Is there some code and if so what is syntax like if you want to say 'Print a 1 if this is the first time the error code footer shows/ per carton. Otherwise a zero'? Driving me crazy!!