Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Clear Entry In Smartforms

Former Member
0 Likes
4,750

Hi guys, can anyone help me please.

I 've made a custom report from SAP.

output like this.

And my headoffice want the red ellips show just one line, cause it same.

How to solve guys?

Thanks

10 REPLIES 10
Read only

Chintu6august
Contributor
0 Likes
4,143

hi,

you can achieve this by using the concept of control break statement..

you will find the "sort criteria section" in the Data tab of table or loop, two events are there named as SORT BEGIN AND SORT END.

SORT BEGIN means AT NEW

SORT END means AT END OF.

i.e event on sort begin and event on sort end.  Give the field name on which you want these events to trigger..

thanks!!


Read only

0 Likes
4,143


Now I've learnt something too!

Thanks Chintu.

Rich

Read only

0 Likes
4,143

where can i get sort criteria section?

In smartforms or in program code?

Cause i still new in SAP

Read only

0 Likes
4,143

hi,

what are you using to populate the data in tabular format??

In field name : give field name as per your requirement select event on sort begin (check).

thanks!!

Read only

0 Likes
4,143

Hi,

i got error when i try like your point.

error like this

thanks

Read only

0 Likes
4,143

hi,

Dump is coming due to missing declaration of T_GBS have you declared it in global declaration or in form interface??

can you show me how you have declared fields  in the events and text elements??

please provide screen shots..

thanks!!

Read only

0 Likes
4,142

Hi.

I have already declaree table t_gbs in form interface and also in my code.

just like that. So can you explain where is my mistake?

Thanks

Read only

FredericGirod
Active Contributor
0 Likes
4,142

hi,

its not logic, ask your headoffice about the column "component". witch one he would like to see ?

For me the first part of your grid must be a different table. You need One table for the first part, and another for the second part

it's an impact on the output. ask your headoffice how he would like to manage this output

regards

Fred

Read only

Former Member
0 Likes
4,142

I take it this is being output in a table loop ?

In your form initialisation,  or before the loop that outputs this table,  create a code node that collates the details of your 'item' table and then loop at the 'summary' table instead.

Regards

Rich

Read only

jogeswararao_kavala
Active Contributor
0 Likes
4,142

Hello Afif,

See these pictures of smartform

In this picture, see fields CUST and QMNUM are repeating fields So first I chose to sort on CUST after which I for the STAR icon on left side infront of this field. Under which you have the text field which will come as the heading. So this repeating number will be printing as a headerline for the item lines. So you remove the repeating line from the table.

In the example above I have sorted on Begin for another field also QMNUM. Same story for this too. So what happens is First the CUST line apprears underwhich QMNUM line appears then the item lines start. After the end of QMNUM, for the same CUST another QMNUM start and so on.

For CUST sorted field I have this text as header.

See the result

Good luck

KJogeswaraRao