topic Re: Group by + smartforms in Application Development and Automation Discussions

Group by + smartforms

Former Member — Fri, 17 Jan 2014 20:11:03 GMT

Hello,

I am creating a report using smartforms to show a list of sellers grouped by their coordinator (their boss)

This report should show something like this:

Coordinator 1

--Seller 1

--Seller 2

--Seller 3

Coordinator 2

--Seller 4

--Seller 5

Coordinator 3

--Seller 6

--Seller 7

--Seller 8

I haven't been able to do this, so far this is what I'm getting:

Coordinator 1

--Seller 1

Coordinator 1

--Seller 2

Coordinator 1

--Seller 3

Coordinator 2

--Seller 4

Coordinator 2

--Seller 5

As you can see, the coordinator is been repeated for every seller. I don't know how to do in smartforms to group this data by the field coordinator. I've read about page-breaks, but I don't really see how it could help me to achieve what I want.

I'd really appreciate any help.

Thanks in advance.

Best regards.

Re: Group by + smartforms

rosenberg_eitan — Fri, 17 Jan 2014 21:04:11 GMT

Hi,

Have a look at SF_EXAMPLE_03

regards

Re: Group by + smartforms

Former Member — Sat, 18 Jan 2014 08:22:13 GMT

Hi Henry ;

You should create a table in the main window and you should

create a table row.In this table row firstly,write the coordinator text.

After that,create a loop in this table row for seller info.

Regards,

Özgün

Re: Group by + smartforms

thangam_perumal — Mon, 20 Jan 2014 09:56:23 GMT

Hi Hendry,

Please place the screen shots and codes...

Re: Group by + smartforms

Former Member — Mon, 20 Jan 2014 15:23:48 GMT

Hi all,

Thank you very much for your answers and help.

The SF_EXAMPLE_03 was perfect to achieve what I needed. In the Data tab of the table in the Sort Criteria Group Box, I entered the field COORDINATOR, so the table will be sorted by this field, then in the Table Tab I added a new row where the coordinator will be shown.

Thanks a lot.

Best reagrds.

Re: Group by + smartforms

rosenberg_eitan — Tue, 21 Jan 2014 16:19:52 GMT

Hi,

The lesson that I learned from SF_EXAMPLE_03 is that it is much easier to create the data model in the driver program an let the smart form print.

This is the principle of "Separation of concerns" http://en.wikipedia.org/wiki/Separation_of_concerns .

I wrote some blog's about this. see http://scn.sap.com/community/abap/blog/2013/10/09/deeper-dive-into-deep-structure ( 4 chapters)

http://scn.sap.com/community/abap/blog/2013/10/22/deeper-dive-into-deep-structure--part-3 deals with smart form.

Regards.