I am working on a report that was written by someone else. This stored procedure for the report puts a pretty heavy load on the server, which I am going to rewrite, but is also puts all the data for the report in one record with many many columns. Because the data really does need to be output this way it is all printing at detail so when there is a break in a section of the detail the headings for that section do not reprint, there is no grouping or any way to create grouping since it is just one row.
My thought is to create subreports for all the different sections but I do not want to go back out to the database and have it run a new stored procedure for the subreports, I would just like to be able to use the data that gets created when the report is requested. Is there anyway to do this?
Thanks in advance for any and all input.