topic Re: Reg: Smartforms in Application Development and Automation Discussions

Reg: Smartforms

Former Member — Tue, 13 Jan 2009 07:09:10 GMT

Hi all,

I have the requirement like,

I need to print the sub-total in each page for an invoice if my lineitems are getting printed more than one page...

i have used the table in the main window...

i want to know whether any events are present to calculate and print the sub-total in each page after the line items are printed...

The event should be triggered for end of each page then only i can print the sub-totals for each page...

answers will be rewarded

thanks and regards

vijay

Re: Reg: Smartforms

Former Member — Tue, 13 Jan 2009 07:12:08 GMT

hi,

refer to this link..

Re: Reg: Smartforms

SuhaSaha — Tue, 13 Jan 2009 07:13:45 GMT

Hello Vijay,

In the MAIN window you must be using a Table to display the line items.

The calculation for the page-total values can be done in the "Calculation" tab.

In the footer of the table, there is a block called "Print Time". In that check both the check-boxes: 'at Page Break' & 'at End of Table'. In the footer, you can use the variable from the "Calculation" tab to get the result.

Hope this helps.

BR,

Suhas

Re: Reg: Smartforms

Former Member — Tue, 13 Jan 2009 07:14:05 GMT

In the calculations tab of table use a global variable as v_total and print this .

Give the operation as total, field name as total field target field as v_total time as after loop

and then print it where u want

кu03B1ятu03B9к

Re: Reg: Smartforms

I355602 — Tue, 13 Jan 2009 07:22:20 GMT

Hi,

As you have used table in main window to print the records, and you want to print a sum of a field at end of page.

Use this approcah:-

Take a variable to store the sum of a field to be displayed in GLOBAL DEFINITIONS.

Now, in the FOOTER of the table in main window --> create a line with one column -- > under the cell create a loop statement and in the DATA tab specify the internal table and work area and in the CALCULATION tab give the operation as TOTAL, field name as <work_area>-<field_name>, target field name to store the sum into a variable declared in GLOBAL DEFINITIONS and finally the TIME as AFTER LOOP* as you wan to print the sum for all field value entries.

Now insert a text element after the loop statement, and not under the loop statement (remember this thing).

This will print the sum of the specified field.

Hope this solves your problem.

Thanks & Regards,

Tarun Gambhir

Re: Reg: Smartforms

Former Member — Tue, 13 Jan 2009 08:27:10 GMT

hi all,

Thanks for your reply..

i found the solution

regards

vijay