Subtotals by page

Play the video

Subject: 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
Subtotals by page Jaine_e - 14 Mar 2005 13:41:06 -0000 <= David Carlisle - 14 Mar 2005 13:58:46 -0000 <Possible follow-ups> Jaine_e - 14 Mar 2005 14:16:22 -0000 Eliot Kimber - 14 Mar 2005 15:50:37 -0000 Jaine_e - 15 Mar 2005 06:30:59 -0000

<- Previous	Index	Next ->
Re: recursive call-template p, omprakash . v	Thread	Re: Subtotals by page, David Carlisle
Re: recursive call-template p, David Carlisle	Date	Re: Subtotals by page, David Carlisle
	Month

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Subscribe in XML format

RSS 2.0
Atom 0.3

XML Editor - Download a 15 Day Free Trial Now >

See What's New in Stylus Studio >

Buy Stylus Studio - XML Editor - Now >