topic Re: samrtforms wrong calculations within table loop in Application Development and Automation Discussions

samrtforms wrong calculations within table loop

Former Member — Thu, 15 Jan 2009 17:50:17 GMT

Hi experts!!

I have the following problem.

I loop through an internal table in my smartform. On the table footer i display the CarryForward value (subtotals of the items printed on each page). Before writing each item i add its value to a variable and before end of main window on the footer i display this variable.

The problem is that subtotals are wrong. Calculations take into account next page's first item.

Any idea????

Please help!!!!

Edited by: Vijay Babu Dudla on Jan 16, 2009 4:24 AM

Re: samrtforms wrong calculations within table loop

Former Member — Thu, 15 Jan 2009 17:54:54 GMT

Have u put page protection at line item level, it shud be thr.

Also to solve ur problem what u need is to adjust the main window,

just slipghtly reduce it, may be by 2-3 mm and now execute and see by little adjustment ur problem will be solved.

кu03B1ятu03B9к

Re: samrtforms wrong calculations within table loop

amit_khare — Thu, 15 Jan 2009 17:55:02 GMT

Did you try doing calculations after writing the line...?

Please don't use ALL upper case in title of the post.

Re: samrtforms wrong calculations within table loop

Former Member — Thu, 15 Jan 2009 18:04:50 GMT

hey how u r summing the total, do it like this.

if u r using a table node then goto calculations tab .

selct the operation as totals, then give src and target field, it will autmatically calulate the sum into target field but if still the problem persists then changing main window will definately help.

Re: samrtforms wrong calculations within table loop

Former Member — Fri, 16 Jan 2009 08:57:57 GMT

Hi all & thank u!

I tried adjusting the main window but it did not work..

How can put page protection at item level & will it help???

Thank u once again!

Re: samrtforms wrong calculations within table loop

Former Member — Mon, 19 Jan 2009 13:41:58 GMT

I still haven't been able to find a solution.

What i have noticed during tests is that the calculations are correct if the remaining space of the main window is reduced. What i mean by remaining space?? in my main window before the line items i display a line with some header data. If the data take 3 lines of space then the calculations are correct, otherwise the calculations take into account next page's first line item, even though it is not displayed on the page..

Please help!!!!

Re: samrtforms wrong calculations within table loop

Former Member — Mon, 02 Feb 2009 10:38:04 GMT

actually this problem occurs because the calculation is done in smartforms before it prints so before it may estimate that 4 line items are fitting into one page so it calculates total accordingly, now if at time of printing the 4th line item doesnot fit completely and u hv applied page protection so at that time it is moved to next oage but since total is already calculated so u get sum of 4 line items even if u see 3 on one page.