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 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
isnull({table2.employeeid})
Ian