Hi all,
I'm wondering if anyone has any solutions to this question that I haven't thought of.
Quite often when creating XRL reports the question arises over how to extract a header field when the report base is a transaction table. The end user only wants the header field to print once, not to print for each row of transaction data extracted.
For example, if you create a summary report (or detail report) based on sales transactions and also add the customer name field to the report. The end user only wants the customer name to print once at the start of that customers transactions, rather than printing on every row.
I know I can work around this within a report design. Does anyone have any methods for achieving this without a report design?
This is an example report

This is how it extracts into Excel

This is what the customer actually wants

Thanks,
Alex