>>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.
If it's not broken, fix it until it is.
My Blog