I need to produce something like this. It's a conversion from a Deski report.
H|Supplier X|11111|GPO BOX XX||Some City|Some State|XXXX|Something1|Something2|Something3|SomethingX|11111|547965.76|02/06/2016||F
H|Supplier Y|11111|GPO BOX YY||Some City|Some State|XXXX|Something1|Something2|Something3|SomethingX|11111|27200.44|02/06/2016||F
H|Supplier Z|11111|GPO BOX YY||Some City|Some State|XXXX|Something1|Something2|Something3|SomethingX|11111|13200.00|02/06/2016||F
The first two lines are HeaderH, then HeaderL. They only appear at the top of the table.
Then is FullDataH (lines starting with an H), on which there is a break. PaymentTotalAmt is a measure and it should be the total for a SupplierNo.
FullDataL3, lines starting with an L are details.
I can't get the PaymentTotalAmt to be just for one vendor - in or foreach don't work. I get a huge total report figure insteadThe FullDataH is in the break header.
In another version, I used FullDataH in the table cell with no break headers or footers and "display first" on the break, which is also FullDataH .
The PaymentTotalAmt is shown correctly but I get empty lines before each FullDataL3 (details) and when exporting to text, the empty lines are not empty, they repeat FullDataH.
I can also provide any details on the Deski report, which we still have to use.