>It looks like complicated variation on cross-tab report. I don't think it can be done with a static query. You can build a query for each set of three dynamicaly but it'll be more coding than creating reporting records.
Thanks Sergey. Okay, thanks I will think of something, or find a way to convince the user differently :)
Just a thought. Can I cross tab individually on this InvoiceFooter based on the iAccountID, once for nPerc and another time for bAmt and maybe even for the cCode (JOINed). They will be one record each so there is no reason to co-ordinate the record pointer. That, if, done, I think I can do some manipulation in Report Manager for reporting.