hyattg wrote:I would like to know if its possible to list the individual phone number (for either husband or wife) in a custom report. I looked through the criteria available in Custom Reports, and the only phone number available is Household phone number.
For custom reports, there are two distinct lists of fields:
- Selection criteria determine which records are selected for inclusion in the report
- Format fields determine which fields are displayed in the report for each selected record.
The list of selection criteria is considerably smaller than the list of format fields. So although it's true that the Household phone number is the only phone number that can be used as a selection criterion, there are three phone number fields which can be included in the format fields: Household phone number, Individual phone number, and Contact phone number (this is defined as the Individual number unless it is blank, in which case it is the Household number).
So unless you really need to select records based on the presence or absence of an individual phone number, or need to select specific numbers, the inability to use individual phone numbers in selection criteria is not a big deal. You can certainly include individual numbers in the output of the report.
hyattg wrote:Is it possible to add criteria to Custom Reports?
The lists of fields allowed for criteria or for format fields are fixed; you can't add fields beyond those that already appear in those lists. But the flexibility inherent in the current options is often more than people realize at first. See the wiki article Custom Reports
for more details.