how to display total amount in Smart form's main window

[former_member953603]

hi,

how to display total amount in Smart form's main window.

Regards,

BBR.

Edited by: BBR on Nov 24, 2008 3:03 PM

[Former Member · Accepted solution]

Hi

In the table you create..in Main Window..There is a tab named "Calculations".

In that give:

Operation: Total

Field Name: Here give the field name for which you want to do the total.

Target Field Name: Here give the field name..where you want to store the total value.

Time:After Loop.

This will take care of the totals.

Regards,

Vishwa.

[Former Member]

hi ,

in the footer of main window create a text element which will contain a variable total.

now if u are having a table then go to the tab calculations of table and

now under operation select total , then on which variable u want to add gv that variable in field name and target field name will contain ur total variable and time will contain after loop

this will solve ur issue.

[Former Member]

Hi BBR,

To Print the total in the smarform --> create the window after the mainwindow and create the text node and display.

Regards,

Sravanthi

[Former Member]

My answer will work only if you have a table in the main window. Otherwise Karthik's answer is perfect If there is no table. :).!!!!!!

[former_member953603]

yes i have table in main window.

rgds,

bbr.

[Former Member]

OK. Follow the Steps I gave in the previous reply.

Now, in the footer of the table, create a text element and then give the Field Name which you give in Target Field name in the Calculations tab.

Vishwa.

[former_member953603]

Still it is not working?

regards,

Bala.

[Former Member]

Do your calculations in footer part of table .

and uncheck the check box

At page break in FOOTER -> OUTPUT OPTIONS

[Former Member]

Please provide clear information about your problem in your question.

If the above is the complete question then any one's answer will be : using text element.

Regards

Karthik D

[Former Member]

hi,

u can directly print the data with related field.but u need to define reference field in globle definitions .

then it will display in smartform..still if u have any questions let me know.

Thanks

sai

[former_member953603]

i tried like that only, but where i have to write those variables, to display at the end of main window under Amount field/column.

regrds,

bbr..

[Former Member]

in footer part of main window or create a new window