>At the end of the report, I want to print a label if a field in the report has ever been 0.
>
>Any ideas?
>
>Thanks,
>
>Michelle

Hey Michelle,

Create a variable in the program calling the report (or possibly a report variable). Make the variable LOGICAL, and set it to .F. Then add a small function and drop it on the report to set the variable to .T. if the value goes zero. Don't do anything if it is non-zero. Then place the end-of-report label in the summary band with the "Print When" set to the variable you created. If you haven't used a procedure in a detail band of a report before, just put it on there like any other variable followed by the parenthesis [i.e. MYFUNC()]

This is all very easy to do if your calling program in a .prg. If it is a VFP form you will have to create your function in a procedure file of some kind.

There may be a better approach, but this will work fine.