Amber, You made me hungry.
We do understand what you need.
I am afraid there is no such an option in SQL Profiler for capture.
If the table(s) is not that dynamic, Andy's suggestion can be followed. Just take the input query (textdata column) and rerun it manually for the result generation.
Naturally if the data changed in between, you will not get the same result.
In SQL Server 2005 you can take snapshots e.g. end of the day, and run it in the snapshot to get as close as possible to the actual results.
How dynamic is your data?
Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
The Best SQL Server 2005 Training in the World!