Subtotal Row in Table.

Avatar

Avatar

Ashutosh_T

Avatar

Ashutosh_T

Ashutosh_T

07-04-2015

Hi,

I am trying to develop a form using Adobe LiveCycle Designer. In my form i have a table which has two columns Amount and Currency. I have to introduce a subtotal line whenever the currency changes. Something similar to:

Line Item Amount Currency

1 100 USD

2 200 USD

300 USD

3 100 EUR

4 200 EUR

300 EUR

Please do give suggestion how this can be achieved.

Thanks & Regards

Ashutosh

Accepted Solutions (0)

Answers (3)

Answers (3)

Avatar

Avatar

radzmar

MVP

Total Posts

2.6K

Likes

386

Correct Answer

485

Avatar

radzmar

MVP

Total Posts

2.6K

Likes

386

Correct Answer

485
radzmar
MVP

08-04-2015

Well, I don't work with SAP so I have no idea how it populates data it real, but as Designers works with XML it should be XML-Data as well.

In this case you'll need XSLT to transform your data already during import.

Therefore you need to create a data connection to a sample XML or XML scheme where you also set your XSTL file to Transform Incoming Data.

Can you provide some sample data?

Avatar

Avatar

Ashutosh_T

Avatar

Ashutosh_T

Ashutosh_T

07-04-2015

Hi Radzmar,

Thanks for your reply.

Data in my form comes from SAP ByDesign system.

I create table fields and do binding with SAP system. Let me put my exact scenario:

I need to degin a invoice form, Invoices are entered in SAP ByDesign system and data looks as below.

Product Type     Product     Qty     Price

X                      ABC1          1          100

X                      ABC2          1          200

Y                      PQR1          1          50    

Y                      PQR2          1          100

Y                      PQR3          1          100

X                       ABC3          1          50

The output table should look like

Prodcut Type          Product          Qty          Price

X                            ABC1              1              100

                              ABC2              1              200

                              ABC3              1                50

                         SUB TOTAL                         350

Y                             PQR1              1               50

                               PQR2              1              100

                               PQR3              1              100

                         SUB TOTAL                         250

                           GRAND TOTAL                600.

I tried to do this using nested tables but got stumped as my bindings fails totaly.

Any Idea on this will be really helpful.

Regards

Ashutosh      

         


Avatar

Avatar

radzmar

MVP

Total Posts

2.6K

Likes

386

Correct Answer

485

Avatar

radzmar

MVP

Total Posts

2.6K

Likes

386

Correct Answer

485
radzmar
MVP

07-04-2015

This isn't an easy task.

Where do the data come from in your form?

Does the user enter the amounds and currencies or is the date imported?