Posted: 2011-02-27 14:04 |
I need to create a report for an email campaign we're running that shows people's email addresses and the industry sector for their employer. Is this possible? |
Posted: Mon, 28.02.2011 - 10:26 |
Yes, you can join together information from one type of record with information from another type of record using 'breadcrumbs'. When you're choosing columns to add to a report you'll see that some options include a right arrow like this one In your example, you should start by creating a Person report and add columns as normal for the Person Name, their Email address and any other fields from a Person record that you want to include. To add a column showing the Industry sector for the person's employer, choose the Employer This will pull through the Employer's Industry sector column as shown below. This theory applies throughout reporting allowing you to join together information from various record types. |