XRL reporting - how to pull out a header field on a transaction based report

alex

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

james-docherty

i cant think of an easy way that this can be done. The only way I can see this being "sort of automated"....Is if they output the report as you have done, then add an if statement in, copy it down & then hide column E......but that still sounds a bit long winded!!! 

Cant see any other way Im afraid, sorry!