Revision history  [back]

Not a perfect solution but if you put all the summary reports in a single file by doing this:

OutputControl:Table:Style, Comma;

or

OutputControl:Table:Style, CommaAndHTML;

then link the entire CSV file into an Excel spreadsheet. You can do some creative things with MATCH or VLOOKUP to find a specific row containing a report name and then INDEX to pull the lines following that into a new part of the spreadsheet. Painful to set up the first time, but at least is is reusable.

Not a perfect solution but if you put all the summary reports in a single file by doing this:

OutputControl:Table:Style, Comma;

Comma;

or

OutputControl:Table:Style, CommaAndHTML;

CommaAndHTML;

then link the entire CSV file into an Excel spreadsheet. You can do some creative things with MATCH or VLOOKUP to find a specific row containing a report name and then INDEX to pull the lines following that into a new part of the spreadsheet. Painful to set up the first time, but at least is is reusable.