Small issue with Crystal report

[mike55]

Hi

 

I have a crystal report that is binded with 3 tables:

members(mid, name, other info)

dues(ref, mid, dues date, infor)

history(ref, mid, history date, infor)

Each member can have multiple dues and multiple history records.

 

On my crystal report, I have set-up 3 sections,

section 1: members data

section 2: dues data

section 3: history data

 

My problem is that I am unable to display multiple records in the dues and history data sections. How can I do this?

 

Section 1 should be :

Mid = 001 Name = Michael O'Donnell

Other info: Gaeilge

Section 2 should be:

01/01/2001 membership, �2000

10/01/2001 Fine, �100

23/05/2002 Ticket, �500

Section 3 should be:

10/10/2003 Won cup

11/10/2003 Suspended

12/12/2003 Reinstated.

 

Mike55.

[mike55]

Ok, I think that to solve this problem I need to use sub-reports, I am currently looking for tutorials & examples. If you can suggest any, i would appreciate it.

 

Mike55.

[mike55]

Ok, found my solution.

 

1. Create a report with all the data from the particular table.

2. Add a sub-report to main report, + navigate the newly created report.

3. Right click on sub-report and select "Change Sub-report links".

 

Mike55.