I have a procedure that I have working and have verified. It took me several painful tries and steps to get this procedure to work the way I need it to. Now I have to do a related report where I need one of the columns that is generated in my previous report. Is there a way to get my new report to run the previous one so then I can use that column in my new report?

This message has been edited. Last edited by: Kerry,

You'd be better off taking your old report and splitting it into 2 big pieces: data preparation where you'll retrieve, sort, aggregate and HOLD your results, and data presentation where you'll take data from the resulting HOLD and display it in any format you need (that's how I do it anyway).

You could then put the data preparation piece in a .fex on its own and "invoke" it from the old report via -INCLUDE.

Once that works, just take the new report code you are developing and -INCLUDE the same piece data preparation there. All that's left is perhaps performing some additional data manipulation (if needed) and finally creating the actual report.

It should be relatively easy to do depending on how structured your code is. Of course, make a good backup before