What app are you using, iit sounds like access?
You could use a create table query and then link the report to the newly created table