Skip to Content
author's profile photo Former Member
Former Member

smartforms

how to calculate subtotals in smartforms.

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 11, 2008 at 11:56 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 11, 2008 at 12:00 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 11, 2008 at 12:02 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 18, 2008 at 12:41 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 27, 2008 at 11:38 AM

    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.....

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 23, 2008 at 11:10 AM

    Hi,

    to calculate subtotal en smartforms

    create->program lines

    *Or*

    en englet calculate de la table.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.