[RESOLVED] Reporting help

[glug]

Hi guys

I have three tables.

Jobcard, Comments,DescriptionOfWorkDone

In each of these tables i have a column called JobNo which is the relationship between the tables.

On the form i have the following textboxes. JobNo, customer,vehicle,date contact person which is saved into the jobcard table. Then i have 5 textboxes for comments so the user can enter in 5 different comments. I store those comments as well as the jobno number into the Comments table. This is my problem. i will explain at the end.

So now when the user enters in 5 comments in those text boxes and saves it.
The comments table will look like this.

JobNo Comment
1 test1
1 test2
1 test3
1 test4
1 test5

Which all works ok.

So heres the problem with the report

I have a all the fields from Jobcard table on the report and then the field(comment) from the Comments table.

the jobcard fields aren't the problem its the comment field.

When i display the report this is what i get

Jobcard: 1 Date: 1/1/1
Customer: jerry Contact: Mark
Comments: test1

Jobcard: 1 Date: 1/1/1
Customer: jerry Contact: Mark
Comments: test2

Jobcard: 1 Date: 1/1/1
Customer: jerry Contact: Mark
Comments: test3

Jobcard: 1 Date: 1/1/1
Customer: jerry Contact: Mark
Comments: test4

Jobcard: 1 Date: 1/1/1
Customer: jerry Contact: Mark
Comments: test5

It duplicates everything. I would like it to report like this.

Jobcard: 1 Date: 1/1/1
Customer: jerry Contact: Mark
Comments:
test1
test2
test3
test4
test5

Please can someone help me with this.

[brucevde]

If you are using Crystal, insert a Group into the report. This will add two new sections Group Header and Group Footer. Print the Jobcard and Customer information in the Group Header. Print the Comments in the Details section.

[glug]

Thanks man....