topic Command in Smartform not working in Application Development and Automation Discussions

Command in Smartform not working

Former Member — Wed, 24 Dec 2008 08:33:48 GMT

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

Re: Command in Smartform not working

Former Member — Wed, 24 Dec 2008 08:46:58 GMT

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

Re: Command in Smartform not working

jayanthi_jayaraman — Wed, 24 Dec 2008 08:52:14 GMT

Hi,

Use this command.

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

Re: Command in Smartform not working

Former Member — Wed, 24 Dec 2008 08:55:48 GMT

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?

Re: Command in Smartform not working

Former Member — Wed, 24 Dec 2008 09:05:50 GMT

Hello Ankesh,

Whats up?

Re: Command in Smartform not working

Former Member — Wed, 24 Dec 2008 09:20:44 GMT

Hi Priya ,

Was thinkin over your problem only.

Re: Command in Smartform not working

Former Member — Wed, 24 Dec 2008 09:24:19 GMT

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

Re: Command in Smartform not working

Former Member — Wed, 24 Dec 2008 09:32:01 GMT

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?

Re: Command in Smartform not working

Former Member — Wed, 24 Dec 2008 09:35:17 GMT

Ya buddy,

But that should not happen right!

Re: Command in Smartform not working

Former Member — Wed, 24 Dec 2008 09:41:36 GMT

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

Re: Command in Smartform not working

Former Member — Wed, 24 Dec 2008 09:49:00 GMT

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

Re: Command in Smartform not working

Former Member — Wed, 24 Dec 2008 09:52:44 GMT

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