Yes. Do this with a query then. Put all of your results either in a query, or in a temporary table, and base the report on the source you use.
For example, you could create a query that is:
SELECT tblMyTable.3000, tblMyTable.5000, tblMyTable.7000, Sum(-[5000) AS 6000, Sum((-)-) AS 9000 FROM tblMyTable
Then make this an append query and post it to a table where you are accumulating other data for you report. It would be flat with one record to source the report, but it is only a temp.
Anyway, there are lots of ways around this.