topic Re: Clear Entry In Smartforms in Application Development and Automation Discussions

Clear Entry In Smartforms

Former Member — Fri, 18 Dec 2015 07:59:40 GMT

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

Re: Clear Entry In Smartforms

Chintu6august — Fri, 18 Dec 2015 08:23:41 GMT

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!!

Re: Clear Entry In Smartforms

FredericGirod — Fri, 18 Dec 2015 08:24:13 GMT

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

Re: Clear Entry In Smartforms

Former Member — Fri, 18 Dec 2015 08:24:49 GMT

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

Re: Clear Entry In Smartforms

Former Member — Fri, 18 Dec 2015 08:39:02 GMT

Now I've learnt something too!

Thanks Chintu.

Rich

Re: Clear Entry In Smartforms

Former Member — Fri, 18 Dec 2015 09:16:28 GMT

where can i get sort criteria section?

In smartforms or in program code?

Cause i still new in SAP

Re: Clear Entry In Smartforms

Chintu6august — Fri, 18 Dec 2015 09:23:10 GMT

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!!

Re: Clear Entry In Smartforms

Former Member — Sat, 19 Dec 2015 01:20:17 GMT

Hi,

i got error when i try like your point.

error like this

thanks

Re: Clear Entry In Smartforms

Chintu6august — Sat, 19 Dec 2015 05:50:34 GMT

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!!

Re: Clear Entry In Smartforms

jogeswararao_kavala — Sat, 19 Dec 2015 08:35:29 GMT

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

Re: Clear Entry In Smartforms

Former Member — Mon, 21 Dec 2015 03:42:20 GMT

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