Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

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

Avatar

Avatar
Boost 1
Level 1
sgurung88
Level 1

Like

1 like

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
Applaud 5
View profile

Avatar
Boost 1
Level 1
sgurung88
Level 1

Like

1 like

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
Applaud 5
View profile
sgurung88
Level 1

25-05-2019

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.

datasource.jpg

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

    

Line#ItemDescriptionQuantityCostChargeSummaryType
1Office License15000Office
2Office License211000Office
3Parking1500Parking
4Boardroom2100RoomHire
5Fine120Parking
6Office211000Office
7Room11200RoomHire

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Boost 50
MVP
_Bruce_Robertson
MVP

Likes

270 likes

Total Posts

1,782 posts

Correct Reply

372 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 250
Boost 25
View profile

Avatar
Boost 50
MVP
_Bruce_Robertson
MVP

Likes

270 likes

Total Posts

1,782 posts

Correct Reply

372 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 250
Boost 25
View profile
_Bruce_Robertson
MVP

03-06-2019

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

Answers (2)

Answers (2)

Avatar

Avatar
Level 1
19sumonoo90
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile

Avatar
Level 1
19sumonoo90
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile
19sumonoo90
Level 1

26-09-2019

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.

Avatar

Avatar
Boost 1
Level 1
sgurung88
Level 1

Like

1 like

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
Applaud 5
View profile

Avatar
Boost 1
Level 1
sgurung88
Level 1

Like

1 like

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
Applaud 5
View profile
sgurung88
Level 1

03-06-2019

Thanks Bruce, this is certainly helpful.