Skip to Content
0
Former Member
Jun 01, 2016 at 09:45 AM

Correct totals in breaks or suppressing breaks in "display first" when exporting to text

17 Views

I need to produce something like this. It's a conversion from a Deski report.

LineType|SupplierName|SupplierNo|PaymentAddr1|PaymentAddr2|PaymentAddr3|PaymentState|PaymentPostcode|PaymentContact|PaymentFax|PaymentPhone|BranchCode|BankAcctNo|PaymentTotalAmt|RunDate|EmailAddress|SendMediumInd

LineType|InvoiceNo|InvoiceDate|InvoiceAmt|DiscountAmt|NetAmt

H|Supplier X|11111|GPO BOX XX||Some City|Some State|XXXX|Something1|Something2|Something3|SomethingX|11111|547965.76|02/06/2016||F

L|12966763 JUNE16|07/05/2016|547965.76|0.00|547965.76

H|Supplier Y|11111|GPO BOX YY||Some City|Some State|XXXX|Something1|Something2|Something3|SomethingX|11111|27200.44|02/06/2016||F

L|1331075|28/04/2016|2552.00|0.00|2552.00

L|1331083|28/04/2016|1639.00|0.00|1639.00

L|1333108|20/04/2016|4422.00|0.00|4422.00

L|1334780|28/04/2016|1639.00|0.00|1639.00

L|1335810|29/04/2016|16948.44|0.00|16948.44

H|Supplier Z|11111|GPO BOX YY||Some City|Some State|XXXX|Something1|Something2|Something3|SomethingX|11111|13200.00|02/06/2016||F

L|IV16012|30/04/2016|13200.00|0.00|13200.00

The structure:


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.

Attachments