Reporting Problem

[REByers]

When using the reports module adding fields causes no results to be shown.

I have a report that is based on industry type for account, and then also shows any contact records with a 'Primary contact' check box checked.

This works fine, however when you then want to display an email address (if it exists) any contacts without an email address (even though is a display field and not a selection criteria) disappear.

I've noticed this happens a lot in the reporting tool.

Is there anyway around this?

[sugarcane]

Hello,

Go into your report and click the Edit button. Then click on the 'Report Details' link.

At the bottom of the panel, you should notice something called 'Optional Related Modules'. Any related modules to your main report module will appear here (IE: Email address is a related module to the contact module). Checking off the checkboxes will expand the results in your report since the report will display values from the main module, even if there are no values in the related modules.

In your example, checking off the Contacts>Email Address will display Contacts in your report, even if they do not have an email address populated.