Right, and sometimes when I need to change something in the cursor before printing I just REPLACE FOR ISNULL(somefield) WITH 0 (first of all, of course the cursor needs to be made uptatable).
Nick
>And, of course, you'll need to check the values with isnull() to handle them.
>
>>I have the Statement report which works the way similar to what Barbara says.
>>It is based on the SQL cursor made of 4 JOINed tables. It is grouped by company key, and invoice key. The invoice information is in the group header, the multiple payments info (for this invoice) goes into the Detail band.
>>BTW, after the join many fields in the cursor may have NULL values.
>>
>>HTH,
>>
>>Nick
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison