Command in Smartform not working

[Former Member]

Hi all,

I need to print totals in every page, for that how to know the end of the page.

i tried to print only 15 rows in page and set a flag, if flag = X then im printing total in footer.

But in some instances, the page has more than 15 rows then after 15th row the total is printing then the

remaining records are printing. Now i called the Command with flag = X and in goto new page i gave second page.

But the flag has set to X, total is also printing but the command is not trigerring.

after 15th record the total is getting displayed and remaining item are printing.

anybody has a clue on this why the command is not trigerring?

pls suggest.

Regards,

Priya

[Former Member]

Declare your total line in Footer of table. There you will have the option to display it at end of table or end of each page.

No need to calculate 15 lines or so.

Just keep calculating the total in a variable and display it in footer.

Double click on Footer node of table and you will see the optin to display it 'At page break' or 'End of table'

Revert if in any doubt.

Edited by: Ankesh Saharan on Dec 24, 2008 2:19 PM

[Former Member]

Hi ,

Thanks for ur reply!

I tried like that also, but if the records are less say only 2 items then the total is coming at end of table but at page break again the footer with total is displaying.

What to do?

[Former Member]

Hello Ankesh,

Whats up?

[Former Member]

Hi Priya ,

Was thinkin over your problem only.

[Former Member]

Thanks,

The problem is with footer only. if i check both at page break and at end of table, at end of table the total is coming and at page break is also coming. But the problem is in some instances some items are only few then at page break it should not display right!

Unable to trace it out, pls suggest some clue.

Regards,

Priya

[Former Member]

I too am of the opinion that in case of table with few entries 'Page break' event should not have been triggered for the table.

Are the two totals being printed on the same page?

[Former Member]

Ya buddy,

But that should not happen right!

[Former Member]

hi,

This may not be the right solution...try and make the size of the footer window where it can hold only one record...as u r telling only totals u r displaying right...

If u have no solution..may be it should work...

Rgds.,

subash

[Former Member]

Hi subash,

I have not taken footer window separately, its in table footer.

at end of table it is displaying, if the items are few even then also at page break it is displaying.

But it should not happen.

Pls suggest.

Regards

Priya

[Former Member]

hi,

then try this way take a seperate footer window, under conditions tab check if page greaterthan 1 , only then it should trigger for at page break...check this whether it works or not...

Rgds.,

subash

[jayanthi_jayaraman]

Hi,

Use this command.

&SFSY-PAGE& of &SFSY-FORMPAGES(3Z)&