Take certain values from report details into report page footer

[emik]

Hi,

I have a dynamic report report and based on a certain criteria I want to put records into the page footer.

For example, if my table looks like this:

Item Cost Use
-----
comp $1,000 my computer
car $2,000
house $3,000 where I live

I want the page footer to only show records that have a value in use, so in this case, the report page footer would have "comp" and "house". I need to do this by page, so when the report is printed, each page footer will have only the records on that page that have a use.

Any ideas?
Thanks.