merge multiple lines in single report

[madwoman]

I am trying to generate a report from a database query which contains exam results, and the report is a letter which confirms a candidates results to their employer. In most cases each candidate only has one record line each year containing multiple exams and results and I can generate a letter for each of these candidates without any problem. However there are some candidates who have two or more record lines each year containing exams and results because they have sat more than one set of exams (eg. one set in Feb and one set of resits in July). Is it possible to generate a single letter for each of these candidates which lists all of the results from the two record lines? and if so how would I do this?

Any help would be much appreciated

 

[Len Boorman]

Basically group the records by candidate.

You will then need to play a little with forcing page breaks after sections (See Properties of report sections)

What actually happens is that asingle report is created with a page break forced when the candidate changes.

Report Header/footer cannot be used because they would only appear on first and last pages. Similarly Page Header and Footer need to be a bit careful with.

Candidate Header and footer are the areas to investigate along with the forced page break ..... available from the toolbox

Len