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

hi guru's in SMART FORMS how i can get subtotals , and page totals

hi guru's in SMART FORMS how i can get subtotals , and page totals plz help me

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 30, 2007 at 04:53 AM

    Hi

    check this

    Subtotals - Check the link...

    <b>subtotal-with-table-node-in-smartforms can use the PROGRAM LINES node to calculate the page totals in Table node.

    Table Node has three sections:

    Header: (Triggered once in the beginning of a page)

    Create a Program lines node to reset the value of TOTAL to 0.

    Main Area (For each row of internal table)

    Create a Program lines node to add the Value to TOTAL

    Footer (Triggered once in the End of a page)

    Display the TOTAL

    Note: 1) You can declare the TOTAL variable in the GLOBAL Definitions under GLOBAL DATA.

    2) In the PROGRAM lines always pass the TOTAL in both INPUT and OUTPUT parameters

    Regards

    Anji

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 30, 2007 at 05:01 AM

    Hi

    One can insert static and dynamic tables. These include the line feeds in the individual table cells, triggering events for table headings and subtotals and sorting data before output.

    Sub window-->Position text on one or more pages

    Main window-->Display text in relation to other nodes in the main window, it may cover several pages

    Template -->Displays texts for table cells of a static table

    Table-->Display table contents

    Header and footer-->Display column headings and grand totals in tables

    Event node-->Display subtotals in a table

    SF_EXAMPLE_02

    Similar to SF_EXAMPLE_01 but with subtotals

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 30, 2007 at 05:03 AM

    In ur program itself u can do this using the control break stmts and then we can call this in the smartforms..

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 30, 2007 at 05:20 AM

    Hi,

    In your smartform itself u can create program lines and use control break statements.( At end of - for subtotals and At last - for page totals).

    Regards,

    Vani

    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.