How to group dynamic row table by column and calculate subtotal for each group?

[sgurung88]

Hello,

In Adobe livecycle - How can we group dynamic row table by column and calculate subtotal for each group?

Hoping someone here can direct me right direction.

I've a source a XML data source: screenshot below, which is linked in the livecycle form.

I can display the data in following format based on the data source below: via data binding the table row to $.CustomerInvoice.Item[*]

Line#	ItemDescription	Quantity	Cost	ChargeSummaryType
1	Office License	1	5000	Office
2	Office License2	1	1000	Office
3	Parking	1	500	Parking
4	Boardroom	2	100	RoomHire
5	Fine	1	20	Parking
6	Office2	1	1000	Office
7	Room1	1	200	RoomHire

But I want to group the table by column, in this example by ChargeSummaryType, and display in the following format:

Line#	ChargeSummaryType		Office	Qty	Cost$
1		Office License		1	5000
2		Office License2		1	1000
6		Office2		1	1000
Subtotal					7000
	ChargeSummaryType		Parking
3		Parking		1	500
5		Fine		1	20
Subtotal					520
	ChargeSummaryType		RoomHire
4		Boardroom		2	100
7		Room1		1	200
Subtotal					300

In this forum, I did find similar question asked but no solution shared. Wonder if this is even possible in adobe livecycle, in other tools like sql and crystalreport its easy as built in function is available.

Would appreciate if anyone here can share their expertise.

Thanks,

Sujit Gurung

[_Bruce_Robertson · Accepted solution]

Hi Sujit,

You can do this sort of thing with Table and Sections.

There's a sample here Tables and sections | Assure Dynamics developing dynamic LiveCycle and Flex solutions

Regards

Bruce

[sgurung88]

Thanks Bruce, this is certainly helpful.

[19sumonoo90]

I need to do same requirement. I visited above helpful link. But I can't download that file. Because Adobe acrobat doesn't allow to use in some country. So could you please share some screen shot for that requirement? Sorry for busy to you.