‎2015 Dec 18 7:59 AM
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
‎2015 Dec 18 8:23 AM
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!!
‎2015 Dec 18 8:39 AM
‎2015 Dec 18 9:16 AM
where can i get sort criteria section?
In smartforms or in program code?
Cause i still new in SAP
‎2015 Dec 18 9:23 AM
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!!
‎2015 Dec 19 1:20 AM
Hi,
i got error when i try like your point.
error like this
thanks
‎2015 Dec 19 5:50 AM
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!!
‎2015 Dec 21 3:42 AM
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
‎2015 Dec 18 8:24 AM
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
‎2015 Dec 18 8:24 AM
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
‎2015 Dec 19 8:35 AM
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