[xsl] Subtotals by page

Subject: [xsl] Subtotals by page
From: Jaine_e <sair777@xxxxxxxxx>
Date: Mon, 14 Mar 2005 05:40:43 -0800 (PST)
Hi 

I want to display subtotals by page so that each page
reflects a subtotal of all the values on that page.

The problem is that I don't know the number of
elements in each page as the page is populated until
there is no more space, then in the footer the total
for that page will be shown. 

I therefore need to group the values according to the
page? 

The output should look like this.


Price1: 181.38
Price2: 139.85
Price3: 181.38
Price4: 181.38
Price5: 181.38

Footer:
Total page value: 869.37

-------------- Page Break ------------------------
Price1: 181.38
Price2: 181.38
Price3: 181.38
Price4: 181.38
Price5: 181.38

Footer:
Total page value: 906.9

------------- Page Break -------------------------

Price1: 181.38
Price2: 181.38
Price3: 181.38
Price4: 181.38
Price5: 181.38

Footer:
Total page value: 869.37
---------- Page Break ----------------------------

Thanks,
S

<?xml version="1.0"?>
<order>
	<orderheader>
		<orderno>04</orderno>
		<delcomment></delcomment>
		<iac></iac>
		<uin>SLDKFJ</uin>
		<date>27 September 2004</date>
		<userrank></userrank>
		<username>Administrator</username>
		<userpost></userpost>
		<userdept>All</userdept>
		<usertel></usertel>
		<userext></userext>
		<orderconsignee></orderconsignee>
		<orderconsigneeadd1></orderconsigneeadd1>
		<orderconsigneeadd2></orderconsigneeadd2>
		<orderconsigneeadd3></orderconsigneeadd3>
		<orderconsigneeadd4></orderconsigneeadd4>
		<orderconsigneeadd5></orderconsigneeadd5>
		<ordernote></ordernote>
	</orderheader>
	<orderitems>
		<contractno>ME-001</contractno>
		<itemno>1A-005</itemno>
		<itemnsn>7105</itemnsn>
		<itemdesc>LOTS OF LOVELY, USELESS, MEANINGLESS
FURNITURE JUST for you 2 buy!  [H=400  W=710  D=710 -
Delivered Form = (FP/KD/SA)] [Deliver Only]
[-]</itemdesc>
		<itemunit>EA</itemunit>
		<itemqty>2</itemqty>
		<itemprice>181.3800</itemprice>
	</orderitems>
	<orderitems>
		<contractno>ME-001</contractno>
		<itemno>1A-004</itemno>
		<itemnsn>7105</itemnsn>
		<itemdesc>LOTS OF LOVELY, USELESS, MEANINGLESS
FURNITURE JUST for you 2 buy! [H=618  W=428  D=549 -
Delivered Form = (RA)] [Deliver Only] [-]</itemdesc>
		<itemunit>EA</itemunit>
		<itemqty>1</itemqty>
		<itemprice>139.8500</itemprice>
	</orderitems>
	<orderitems>
			<contractno>ME-001</contractno>
			<itemno>1A-005</itemno>
			<itemnsn>7105</itemnsn>
			<itemdesc>LOTS OF LOVELY, USELESS, MEANINGLESS
FURNITURE JUST for you 2 buy! [H=400  W=710  D=710 -
Delivered Form = (FP/KD/SA)] [Deliver Only]
[-]</itemdesc>
			<itemunit>EA</itemunit>
			<itemqty>2</itemqty>
			<itemprice>181.3800</itemprice>
	</orderitems>
	<orderitems>
			<contractno>ME-001</contractno>
			<itemno>1A-005</itemno>
			<itemnsn>7105</itemnsn>
			<itemdesc>LOTS OF LOVELY, USELESS, MEANINGLESS
FURNITURE JUST for you 2 buy! [H=400  W=710  D=710 -
Delivered Form = (FP/KD/SA)] [Deliver Only]
[-]</itemdesc>
			<itemunit>EA</itemunit>
			<itemqty>2</itemqty>
			<itemprice>181.3800</itemprice>
	</orderitems>
	<orderitems>
			<contractno>ME-001</contractno>
			<itemno>1A-005</itemno>
			<itemnsn>7105</itemnsn>
			<itemdesc>LOTS OF LOVELY, USELESS, MEANINGLESS
FURNITURE JUST for you 2 buy!p [H=400  W=710  D=710 -
Delivered Form = (FP/KD/SA)] [Deliver Only]
[-]</itemdesc>
			<itemunit>EA</itemunit>
			<itemqty>2</itemqty>
			<itemprice>181.3800</itemprice>
	</orderitems>
	<orderitems>
			<contractno>ME-001</contractno>
			<itemno>1A-005</itemno>
			<itemnsn>7105</itemnsn>
			<itemdesc>LOTS OF LOVELY, USELESS, MEANINGLESS
FURNITURE JUST for you 2 buy! [H=400  W=710  D=710 -
Delivered Form = (FP/KD/SA)] [Deliver Only]
[-]</itemdesc>
			<itemunit>EA</itemunit>
			<itemqty>2</itemqty>
			<itemprice>181.3800</itemprice>
	</orderitems>
	<orderitems>
			<contractno>ME-001</contractno>
			<itemno>1A-005</itemno>
			<itemnsn>7105</itemnsn>
			<itemdesc>LOTS OF LOVELY, USELESS, MEANINGLESS
FURNITURE JUST for you 2 buy! [H=400  W=710  D=710 -
Delivered Form = (FP/KD/SA)] [Deliver Only]
[-]</itemdesc>
			<itemunit>EA</itemunit>
			<itemqty>2</itemqty>
			<itemprice>181.3800</itemprice>
	</orderitems>
	<orderitems>
			<contractno>ME-001</contractno>
			<itemno>1A-005</itemno>
			<itemnsn>7105</itemnsn>
			<itemdesc>LOTS OF LOVELY, USELESS, MEANINGLESS
FURNITURE JUST for you 2 buy! [H=400  W=710  D=710 -
Delivered Form = (FP/KD/SA)] [Deliver Only]
[-]</itemdesc>
			<itemunit>EA</itemunit>
			<itemqty>2</itemqty>
			<itemprice>181.3800</itemprice>
	</orderitems>
	<orderitems>
			<contractno>ME-001</contractno>
			<itemno>1A-005</itemno>
			<itemnsn>7105</itemnsn>
			<itemdesc>LOTS OF LOVELY, USELESS, MEANINGLESS
FURNITURE JUST for you 2 buy![H=400  W=710  D=710 -
Delivered Form = (FP/KD/SA)] [Deliver Only]
[-]</itemdesc>
			<itemunit>EA</itemunit>
			<itemqty>2</itemqty>
			<itemprice>181.3800</itemprice>
	</orderitems>
	<orderitems>
			<contractno>ME-001</contractno>
			<itemno>1A-005</itemno>
			<itemnsn>7105</itemnsn>
			<itemdesc>LOTS OF LOVELY, USELESS, MEANINGLESS
FURNITURE JUST for you 2 buy! [H=400  W=710  D=710 -
Delivered Form = (FP/KD/SA)] [Deliver Only]
[-]</itemdesc>
			<itemunit>EA</itemunit>
			<itemqty>2</itemqty>
			<itemprice>181.3800</itemprice>
	</orderitems>
	<orderitems>
			<contractno>ME-001</contractno>
			<itemno>1A-005</itemno>
			<itemnsn>7105</itemnsn>
			<itemdesc>LOTS OF LOVELY, USELESS, MEANINGLESS
FURNITURE JUST for you 2 buy! [H=400  W=710  D=710 -
Delivered Form = (FP/KD/SA)] [Deliver Only]
[-]</itemdesc>
			<itemunit>EA</itemunit>
			<itemqty>2</itemqty>
			<itemprice>181.3800</itemprice>
	</orderitems>
	<orderitems>
			<contractno>ME-001</contractno>
			<itemno>1A-005</itemno>
			<itemnsn>7105</itemnsn>
			<itemdesc>LOTS OF LOVELY, USELESS, MEANINGLESS
FURNITURE JUST for you 2 buy! [H=400  W=710  D=710 -
Delivered Form = (FP/KD/SA)] [Deliver Only]
[-]</itemdesc>
			<itemunit>EA</itemunit>
			<itemqty>2</itemqty>
			<itemprice>181.3800</itemprice>
	</orderitems>
	<orderitems>
			<contractno>ME-001</contractno>
			<itemno>1A-005</itemno>
			<itemnsn>7105</itemnsn>
			<itemdesc>LOTS OF LOVELY, USELESS, MEANINGLESS
FURNITURE JUST for you 2 buy! [H=400  W=710  D=710 -
Delivered Form = (FP/KD/SA)] [Deliver Only]
[-]</itemdesc>
			<itemunit>EA</itemunit>
			<itemqty>2</itemqty>
			<itemprice>181.3800</itemprice>
	</orderitems>
	<orderitems>
			<contractno>ME-001</contractno>
			<itemno>1A-005</itemno>
			<itemnsn>7105</itemnsn>
			<itemdesc>Table Occasional (Officers) (Mess) - LOTS
OF LOVELY, USELESS, MEANINGLESS FURNITURE JUST for you
2 buy! [H=400  W=710  D=710 - Delivered Form =
(FP/KD/SA)] [Deliver Only] [-]</itemdesc>
			<itemunit>EA</itemunit>
			<itemqty>2</itemqty>
			<itemprice>181.3800</itemprice>
	</orderitems>
	<orderitems>
			<contractno>ME-001</contractno>
			<itemno>1A-005</itemno>
			<itemnsn>7105</itemnsn>
			<itemdesc>Table Occasional (Officers) (Mess) - LOTS
OF LOVELY, USELESS, MEANINGLESS FURNITURE JUST for you
2 buy! [H=400  W=710  D=710 - Delivered Form =
(FP/KD/SA)] [Deliver Only] [-]</itemdesc>
			<itemunit>EA</itemunit>
			<itemqty>2</itemqty>
			<itemprice>181.3800</itemprice>
	</orderitems>
	
	
</order>


		
__________________________________ 
Do you Yahoo!? 
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/ 

Current Thread