smartforms

[Former Member]

how to calculate subtotals in smartforms.

[Former Member]

Hi,

to calculate subtotal en smartforms

create->program lines

*Or*

en englet calculate de la table.

[Former Member]

u can maintain on table as it is differnt table lines as per ur rqquirement.

one is total (table line1).

second one is for sub total ( table line2).

in that we create program line and text. as per ur.....

[Former Member]

Hi,

There are two diffrent ways of calulating Sub totals in smartforms,

1. Subtotals at the end of main window.

in this case in the Table node. there is an calculation tab.

in that select TOTAL in the operations, give the field name infrom the internal table to which u have to do total ,,, and give the variable name where it has to store in target field name.

2. Subtotals at the end of each sales order or purchase order.

in loop node. go to data tab and in the below sort criteria

give the field and select event on sort begin.

for the given given field select event on sort end.

in between these two nodes u can sum the required field sub totals

regards

kumar

[Former Member]

hi

please follow this procedure

.

right click on respective window where u want to display subtotals,

create->program lines

give input and output parameters.

write a code for calculation in program lines(Before doing the calculations, declare variables for subtotal in Global definitions).

thanks,

Usha

[Former Member]

Hi,

Use program lines in the end of the body section to add the relevant fields and use the options 'Footer at Page Break ' in the events tab of the table to display the subtotals pagewise in the footer section.

Regards,

Ram

[Former Member]

use the loop event 'Event on sort end'.

Create a loop and in the data section of the loop, under the sort criteria give the field name againts which u want to create the sub total and check the 'Event on sort end' check box.

Inside the loop u will see an event will be created. Under this node u add your code.