cancel
Showing results for 
Search instead for 
Did you mean: 

Page total particualar field wise

former_member901954
Discoverer
0 Kudos

Hi Team,

How to do page wise & field wise total in smartforms ?

use table in smartforms for summary in pagebreak

ex. page1

CURRENCY LINE ITEM Value

------------------------------------

EUR 10 (line 1)

INR 20 (line 2)

INR 30 (line 3)

CHF 40 (line 4)

Total in EUR 10

Total in CHF 70

Total in INR 50

---------------------------------------

page 2

CHF 30 (line 1)

INR 50 (line 2)

Total in EUR 0

Total in CHF 0

Total in INR 50

---------------------------------------------

Total in CHF in page 1 incorrect = line4(page1) + line1(page2) .

That means Last record of page1 value adding in page1 but printing in page2

please help me guys to solve this problem..

Regards,

Hari Kumar

former_member27
Community Manager
Community Manager
0 Kudos

Welcome to the SAP Community! Thank you for visiting us to get answers to your questions.

Since you're asking a question here for the first time, I'd like to offer some friendly advice on how to get the most out of your community membership and experience.

First, please see https://community.sap.com/resources/questions-and-answers, as this resource page provides tips for preparing questions that draw responses from our members. Secondly, feel free to take our Q&A tutorial at https://developers.sap.com/tutorials/community-qa.html as well, as that will help you when submitting questions to the community.

If you're interested in connecting with community members, please pay a visit to our new Welcome Corner. You'll need to sign up, but it's a great way to interact with peers and get to know other experts!

Finally, I recommend that you include a profile picture. By personalizing your profile, you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html.

I hope you find this advice useful, and we're happy to have you as part of SAP Community!

Regards,

Dedi

Accepted Solutions (0)

Answers (1)

Answers (1)

raymond_giuseppi
Active Contributor
0 Kudos

Suggestion: Place some nodes in your table node.

  • Set the header and footer events at the page break and at the start/end of the main table node.
  • Add program lines into the table header to initialize the 'page totals'.
  • Add text nodes to print the 'page totals' in the footer.
  • Calculate the 'page totals in the item nodes (also count the number of currency codes)
  • Trigger a page break before the number of page totals gets too large for the end of the page with a command/condition.