Help with data report

Hi all!!!

I would like to know...

Is there a way, in a datareport, bound to a query, to get some of the fields to only show once, instead of for every record the query is returning? I am trying to create invoicing for a company, and I only need the company and billing information to come up once, but you can't put a bound field in the header section of a datareport... here is my query, I would love some input or suggestions.

SELECT company.company, company.billingcontact,
company.billingaddress, company.billingaddress2,
company.billingcity, company.billingstate, company.billingzip,
records.lastn, records.firstn, records.donorid,
records.collecteddate, records.cost, records.invoicenum
FROM records INNER JOIN
company ON records.mrocomid = company.mrocomid
WHERE (records.invoicenum = ?)

- all the fields from the company table I would like to be in sort of a header section.

any ideas??

thanks
kristin

You may wish to try a group by clause in your SQL statement by company name. This should hopefully help.