Merge records for reporting

[Mountainoak]

Hi,

I'd like to merge records into one field for reporting.

I have a join table where 1 patient is linked to several procedures. These procedures have a code. For reporting i'd like to merge these codes in one field.

I've attached a sample file.

Can somebody help me on how to do this.

I tried a list function but can't get it to work.

Thanks

vraag.fp7_.zip

[comment]

Which code do you want? There's one in Procedures (a calculated one), and one in ProcedureCategories (with no data in it).

[Mountainoak]

I`d like the one in the layout called "patientprocedures" to be merged in one field per patient on the report. So the calculated one.

[comment]

Well, then point the List() function to that field (and that field only)

List ( Procedures::categorie code calc )

Make sure that the result of the calculation is Text. BTW, the same thing applies to the 'categorie code calc' field in Procedures.

[Mountainoak]

Thanks this works.

Is there a way to display the result in a line meaning:

ABC

in stead of:

A

B

C

[Mountainoak]

Got it: Substitute ( List ( Procedures::categorie code calc ) ; ¶ ; ", " )