Skip to Content
0
Former Member
Mar 05, 2009 at 04:02 AM

SubTotal/output format in QPLD

24 Views

Good day,

Currently having problems with regards to SubTotals/output format in QPLD.

My desired output is this:

_____________________________________________________________

SlpCode1 SlpName1

CardName1

DocDate1 DocNum1 DocTotal1

DocDate2 DocNum2 DocTotal2

DocDate3 DocNum3 DocTotal3

DocDate3 DocNum4 DocTotal4

ColSum("DocTotal")1

CardName2

DocDate1 DocNum1 DocTotal1

DocDate2 DocNum2 DocTotal2

DocDate3 DocNum3 DocTotal3

DocDate4 DocNum4 DocTotal4

ColSum("DocTotal")1

But the output I get is :

_____________________________________________________________

SlpCode1 SlpName1

CardName1

DocDate1 DocNum1 DocTotal1

DocDate2 DocNum2 DocTotal2

DocDate3 DocNum3 DocTotal3

DocDate3 DocNum4 DocTotal4

ColSum("DocTotal")1

SlpCode1 SlpName1

CardName2

DocDate1 DocNum1 DocTotal1

DocDate2 DocNum2 DocTotal2

DocDate3 DocNum3 DocTotal3

DocDate4 DocNum4 DocTotal4

ColSum("DocTotal")1

It keeps repeating SlpCode and SlpName.

Repetitive Area Header1 contains these Sorts(in order)

Sort 1: SlpCode

Sort 2: SlpName

Sort 3: CardName

*the 3 corresponding Formula Fields w/ SortValue() are also in place already

Am I missing something that's why I am getting the wrong output?

Thanks in advance for the help,

Sean