>>>I have two groups:
>>>ProjectName
>>> Caption
>>>
>>>I want to print totals in Caption group footer and in Project group footer. However, if I only have one Caption, I don't want to print Caption Footer.
>>>
>>>I'm thinking, can I use your/mine idea or I better try Cetin's idea with array or a modification of it with an extra cursor.
>>
>>If you print from cursor and the latter is small enough then you can just add a field 'prtcapfoot' and fill it by SQL (having count(*)=1).
>
>Thank you, Edward. In fact, I'm considering this idea, since the cursor for the report is produced after select sql with scan insert endscan. I think, I'm going to follow this idea rather than doing it in the report designer.
>
>Thanks a lot.
Report variable will do the same thing. Personally, I prefer to play with cursor, it will be just one place to look for later.
Edward Pikman
Independent Consultant