Andrew:

The solution I propose is already possible in the Adagio FR, it's just not easy to accomplish. So if there is some demand for this type of reporting, an easier way to accomplish it might be useful.

Where we have done this we have turned a 180 page f/s into 30 pages. Though our client doesn't send this f/s to Excel, I don't imagine that 180 worksheets would be very manageable but 30 would be.

I cannot imagine any method of satisfying 5 without resorting to user edits or a very complex VB macro in Excel.

Andrew:

Just an equally (to VB in Excel) complex formula in Adagio FR.