>>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.

I'll try that if Nick's suggestion doesn't work.

Thanks,

Michelle