I don't have much experience creating reports in any application. I'm using QuickBooks Advanced Reporting and attempting to build a "phone book." I would like to have the Primary Contact, Secondary Contact and all Alternate Contacts names appear in the same column. I cannot figure out the proper syntax. I do have all the alternate contacts in one column with the expression
= [CustomerAdditionalContact.First Name] &' '& [CustomerAdditionalContact.Last Name]. (I have all the associated contact information for the contact also).How do I add to the expression to get Primary and secondary contacts in the directory? See simple example below:
I am not sure if I understand your setting, could you post some sample lines of your input records?
If you want to get all contacts into a single column, that should be feasable, and if you still want to be able to distinguish between the primary / secondary contacts, maybe just create an additional field in the data model that flags records as belonging to a primary / secondary contact?
The information I have captured is quite wide so that is why I don't want to add a column for Primary Contact and Secondary Contact. Those designations are not really important to see for what I'm doing. Thank you for helping!
I think I just miss what you are asking for then. Is it to get several fields describing the same into a common field?
That's why I've asked for a description of your input records, the ones you are loading from the source DB, so I can imagine where you might have problems with (and we can imagine this much better if you also describe what your expected result is).
The table you posted above is probably a piece of the puzzle, but I just can't find out in which context.
Yes, I would like to get [CustomerAdditionalContact.First Name] &' '& [CustomerAdditionalContact.Last Name] AND [CustomerPrimaryContact.First Name] &' '& [CustomerPrimaryContact.Last Name] AND [CustomerSecondaryContact.First Name] &' '& [CustomerSecondaryContact.Last Name] in the column labeled "Name".