Hi:
I need to create a simple query whose output is XML. It needs to print invoices with amounts for each customer but also needs to pass the total invoice amount for each customer. (I am using InfoPath to create the XSL which is then used by an end-user product which apparently does not support any totals created witin InfoPath.)
XML does not allow COMPUTE SUM but that is what I am trying to emulate.
The output of the query would ideally be:
cust A
invoice 1 xxx.xx custA total
invoice 2 yyy.yy custA total
cust b
inv 1 aaa.aa custb total
etc.
where custA total is essentially the same number on each line. Possible?
thanks in advance
I need to create a simple query whose output is XML. It needs to print invoices with amounts for each customer but also needs to pass the total invoice amount for each customer. (I am using InfoPath to create the XSL which is then used by an end-user product which apparently does not support any totals created witin InfoPath.)
XML does not allow COMPUTE SUM but that is what I am trying to emulate.
The output of the query would ideally be:
cust A
invoice 1 xxx.xx custA total
invoice 2 yyy.yy custA total
cust b
inv 1 aaa.aa custb total
etc.
where custA total is essentially the same number on each line. Possible?
thanks in advance
