I can't tell from your formula what you are trying to do. How is a shared record coded in the database?
The shared or single variable is NOT part of the record in RE it is only evaluated in Crystal.
For every $100 gift that a grandparent gives, they are "eligible" for a bookplate for each grandson - so basically the formula is checking for the # of grandsons, comparing it to the $ given and then determining if the bookplate is "single or shared"; I grouped on the grandparent sort key and then counted the # of occurances of the gp sort key...to derive my formula. I realize that it is cumbersome (and there is probably a cleaner way to write it).
2nd-ly - Since this scenario is available for ALL grandparents and ALL of their grandsons we've chosen NOT to use the tribute module (even though we have it) - as that would slowdown our DE person tremendously.
I'm going to try the 2 sub-report scenario that you mentioned - I think it will work!
Elaine Tucker Director Member Services World Affairs Council of Dallas/Ft. Worth www.dfwworld.org etucker at dfw world dot org