I would be very grateful for some help in constructing a report for which I have trying in vain for some time in finding a solution. Apologies for the lengthy explanation which follows:
1. Panel which includes the following fields: First Name, Last Name, date, type of qualification held Typical entries include Victor,Warner,13/10/2009,Lawyer Victor,Warner,09/12/2009,Lawyer Adam, Smith,13/10/2009,Lawyer Adam, Smith,09/12/2009,Lawyer Alison,Jones,13/10/2009, Non-qualified volunteer Alison,Jones,09/12/2009,Non-qualified volunteer David,Burden,13/10/2009,Lawyer David,Burden,09/12/2009,Lawyer Richard,Anderson,13/10/2009,Non-qualified volunteer Richard,Anderson,09/12/2009,Non-qualified volunteer 2. I wish to create a 2 level report sorted on date as follows: [appearing in two-level footer] 13/10/2009 Warner - Smith - Burden [One line] Jones - Anderson [Separate line] 09/12/2009 Warner - Smith - Burden [One line] Jones - Anderson [Separate line] Ie instead of 13/10/2009 Warner Smith Burden Jones Anderson I can put all the names together without putting a hard return between one using a report variable (eg putting a report variable in the two-level header containing “ ”, and putting the report variable with the same number in the report body, containing etc cat.t[rv1;” “P11F5]. However the difficulty I have am having is putting together just the names for those persons who are lawyers and then separately putting together those names which are non-qualified volunteers. Help with this would be very gratefully received. Victor Warner. _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
