Sub Summary reporting
I have added a sub-summary section to a list of information split be VAT rate. I have also added a field that calculates the total amount of VAT;
Total VAT 1957.12
VAT @ 4% VAT 2.90
VAT @ 21% VAT 1,954.22
From the above figures there are some 941 records.
I now need to find a way of getting the information that is stored in the sub-summary to another layout (the layout is showing the same records, I just need to drill down and show key information). I need a breakdown of the rate that was applied and the total of VAT.
Any guidance would be appreciated,