DrewAllen;9047 wrote:
I can't tell from your formula what you are trying to do. How is a shared record coded in the database?
Drew
Drew,
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
slow down our DE person tremendously.
I'm going to try the 2 sub-report scenario that you mentioned - I think it will work!
Thanks!!!!
