one to many records in report, repeating records

G

Guest

I am trying to create a contact list report that will list the contact
information as well as listing previous call history. (Call info stored in
separate table with one to many relationship)

How do I get around all the data presenting itself mutiple times rather than
the main data once with the many call entries under it? (preferably the
simplest as possible as I know little about coding etc)

Cheers
 
R

Rick Brandt

triplespiral said:
I am trying to create a contact list report that will list the contact
information as well as listing previous call history. (Call info
stored in separate table with one to many relationship)

How do I get around all the data presenting itself mutiple times
rather than the main data once with the many call entries under it?
(preferably the simplest as possible as I know little about coding
etc)

Cheers

You need to set up Group sections in your report using the Primary Key of the
contact to group on. You then place the controls for contact data in the group
section and controls dealing with call data in the detail section.
 
G

Guest

hurrah! that was painless! thank you!!!

Rick Brandt said:
You need to set up Group sections in your report using the Primary Key of the
contact to group on. You then place the controls for contact data in the group
section and controls dealing with call data in the detail section.
 
G

Guest

eeek. spoke to soon regarding painless :)

what you suggested does work, however, now records that do not have any call
entries attached are not showing up in the report - is there a workaround??

Help, please? Thanks!!
 
G

Guest

scratch that - I figured it out. duh

(changing the one-to-many join properties in the query for anyone having the
same problem in the future)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top