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

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

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

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

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