Formula Help - Please?

[kevinbellnj]

I have a crystal report formula question involving CR 8.5 and Goldmine 6.5 ...again

I need to collect all of the "additional contacts at a customer into one part of a report

The base customer information is in the table CONTACT1 and the additional contact information is in the table CONTSUPP

I can get the contact, title, reference codes, phone numbers and notes into one group because they are all included in one record in the CONTSUPP table and are simply linked via the field ACCOUNTNO in CONTACT1 and CONTSUPP.

The trouble sets in when I try get their email address which is stored as a separate record within the same CONTSUPP table. I am trying to get all of this information on the same line for each additional contact within a customer. Some customers have as many as 10 contacts.

The email address is in CONTSUPP.CONTSUPREF is the following is true
CONTACT1.ACCOUNTNO = CONTSUPP.ACCOUNTNO
AND
CONTSUPP.RECTYPE= 'P'
AND
CONTSUPP.CONTACT = 'E-Mail Address'

Another problem is that if one of them is null (which happens all the time) none of the email addresses show up...
I can get this straight in SQL but trying to get the syntax straight in CR is troubling me... Any Help wil be greatly appreciated!

KB

 

[dgillz]

Please define "one part of a report". Do you mean a single line of data or a single list of contacts?

I have already done this report for a single line of data, although it is in Goldmine 5.5.

If you give me some idea of what you are looking for, I am sure I can help.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[kevinbellnj]

I need to list all contacts for a customer in a list - each additional contact in a single line (well actually two lines because the notes field is a second line)

Contact 1 Title Reference Phone Email
Notes
Contact 2 Title Reference Phone Email
Notes
Contact 3 Title Reference Phone Email
Notes
etc...