Skip to Content
author's profile photo
Former Member

Smartform total sum

Hi All,

I am a newer of smartform. Now I face a problem, I want to do total sum at the bottom of main table without showed at each page. But I tried many method and it is not ok.

Plz help me.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

6 Answers

  • Posted on Oct 10, 2007 at 02:57 AM

    Do it like this...

    Inside the loop,use program lines. Declare input variable as field name to be summed, declare output variable which contains the summation value.

    now for displaying the total after all line items or tale lines,

    Do a doubleclick on table node you will see the tabs goto EVENTS tab.

    Choose EVENTS and set the flag of FOOTER checkbox.

    Now a FOOTER node is opened into the TABLE NODE (at the end of the table) and so you can insert a text for the total and value that is calculated in program lines.

    Close the thread once your question is answered.

    Regards,

    SaiRam

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Oct 10, 2007 at 04:40 AM

    Hi,

    In your total text field click check box only after end of main window.

    or create a template put the condition as only at end of main window

    Regards

    Shiva

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      I can't use at end of main window. Since I used the command for page break. If i choose at end of main window, the sum will be showed on the last page. It is wrong.

  • author's profile photo
    Former Member
    Posted on Oct 10, 2007 at 05:55 AM

    Hi

    After your main window create a final window. copy paste the table from main window to final window. do al the necessary calculation and place the field in the footer section of the table.

    hope ur problem is solved.

    regards,

    shiva

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 10, 2007 at 06:03 AM

    Hi,

    Use calculations tab in table for calculations and then use text element footer to display the total.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Oct 10, 2007 at 06:15 AM

    Hi,

    In the node where u r printing the value , u will be printing each value in the textelement. so Before that text elelment u create a program line.

    u take a variable and assign the variable as zero .

    in the program lines u put the code as

    variable = variable + (text-value).

    ex:-itab-menge.( uwant to make sum of menge).

    var type menge. = 0.(This u do in global def.).

    in the program lines.

    var = var + itab-menge.

    after the loop.

    var will be sum of the all .

    Assign points if useful.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Oct 10, 2007 at 06:51 AM

    I got all the result of sum. My problem is how to display the result at the end of the main window.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      in main window there is 3 sub windows like herder main & fotter

      in that fotter window pass the filed which u r declear the sum for ex: &itab-netwr&

      drag & drop the particuler palce then whenver page break is trigger the total will displayed on the that page it self next page again it will calculat add the previous total lastely displyed ground total of all iteam.

      in fotter window u place like this

      total : &t_itab-netwar&

      t_tab-netwr is decleard in the global data of type netwr

      t_tab-netwr type netwr.

      in the table there one tab called calcultion in that u pass this files give the option after the loop.

      this will help u...

      thanks...