Report builder grouping

I have a report that prints out vendor information. The first grouping is the vendor ID and the page resets after each group.

I have some comment text that I need to add at the end of the vendor group. However, if I put it in the Vendor group footer, depending on how much information is on the last page of each group, the comment might show up anywhere on that page. I want it to show up only on the bottom of the vendor group page.

If I put the comment text on the page foot, then it shows up on every page.

Any ideas on how I can have the comment text show up in the footer section without printing on every page. I only want it to print on the last page of the vendor group.

Thanks,
Jasper




[Non-text portions of this message have been removed]