Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Grouping data

I have the following data

Table 1:

Company_id Company_name Location Website

Id 1 C1 L1 W1

id 2 C2 L2 W2

Table 2:

Company_id Contact_per_name Email_id

id1 Person1 E1

id1 Person2 E2

Now in my reprot i have created a command where i joined two tbales (Left join) and i got the below data,

id1 C1 L1 W1 Person1 E1

id1 C1 L1 W1 Person2 E2

id2 C2 L2 W2

Now i need to display the report with each company details in each page,

First page:

Company Name:C1

Location:L1 Website: W1

Contact person Email id

person1 E1

Person 2 E2

Second page:

Compnay name: C2

Location:L2 Website:W1

I have created a company name group and placed the location, website, contact person detials in the details section. If Contact person does not exist for a company, it is displaying correctly. But when the company is having more than one contact person details, location & website is getting displayed twice. How to group the report?

Thank you.

Former Member
Former Member replied

I thought you did not want to see companies with out employees. Using an equal join between company and employee table will automatically suppress the companies without employees.

If you want to manually supress then go to section expert and enter



0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question